example15_8.java.bak

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

import java.sql.*;
public class Example15_8
{  public static void main(String args[])
   {  Connection con;PreparedStatement 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.prepareStatement("SELECT * FROM chengjibiao");             
			 rs=sql.executeQuery();	 
             while(rs.next())
             { String number=rs.getString(1);
				 String  name=rs.getString(2);
				 System.out.print("学号："+number);               
                 System.out.println("  姓名："+name);              
             }
            con.close();
           }
      catch(SQLException e1) { System.out.print(e1);}
   }    
}