jdbcsample.java

来自「一个通过odbc链接数据库（mysql）的奖学金评定系统！·」· Java 代码 · 共 33 行

import java.sql.*;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;
import java.awt.Dimension;
public class JDBCSample{
 public static void main(String[] args){
  try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  }
  catch(ClassNotFoundException e){
   System.out.println("Unable to load Driver Class");
   return;
  }
  try{  
   Connection con = DriverManager.getConnection("jdbc:odbc:gold","root","luanluan");
   Statement stmt=con.createStatement();
   ResultSet rs=stmt.executeQuery("select sid from student");
   while(rs.next()){
	  System.out.println(rs.getString("sid"));
   }
   rs.close();
   stmt.close();
   con.close();
  }
  catch(SQLException se){
  System.out.println("aaSQL exception: "+se.getMessage());
  se.printStackTrace(System.out);
  }
 }
}