example15_1.java.bak

来自「不错的教程 适合中高级人员的使用」· BAK 代码 · 共 34 行

import java.sql.*;
public class Example15_1
{  public static void main(String args[])
   {  Connection con;Statement sql; ResultSet rs;
      try {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
          }
     catch(ClassNotFoundException e)
          {  System.out.println(""+e);
          }
      try
          { 
             con=DriverManager.getConnection("jdbc:odbc:sun","gxy","123");
             sql=con.createStatement();
             rs=sql.executeQuery("SELECT * FROM chengjibiao");
             while(rs.next())
             { String  number=rs.getString(1);
               String  name=rs.getString(2);  
               Date    date=rs.getDate(3);
               int     math=rs.getInt("math");
                
               int  english=rs.getInt("english");
               System.out.print("学号："+number); 
               System.out.print("  姓名："+name);
               System.out.print("  出生："+date);
               System.out.print("  数学："+math);               
               System.out.print("  英语："+english);
             }
            con.close();
           }
      catch(SQLException e1) {}
   
   }    
}