import java.sql.*;import javax.swing.*; class jdbcExample1{ public static void main(String args[]){  try{   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");   String url="jdbc:odbc:studyDSN";   String login="sa";   String password="";      Connection conn=DriverManager.getConnection(url,login,password);   Statement statement=conn.createStatement();   String sqlQuery="select * from course";   ResultSet rs=statement.executeQuery(sqlQuery);      while(rs.next()){    System.out.print(rs.getString(1)+",");    System.out.print(rs.getString(2)+",");    System.out.print(rs.getInt(3)+",");   }      statement.close();   conn.close();  }    catch(SQLException sqlException){   JOptionPane.showMessageDialog(null,sqlException.getMessage(),"database error",JOptionPane.ERROR_MESSAGE);   System.exit(1);  }    catch(ClassNotFoundException classNotFound){   JOptionPane.showMessageDialog(null,classNotFound.getMessage(),"driver not found",JOptionPane.ERROR_MESSAGE);      System.exit(1);  } }}

评论