example15_9.java.bak

不错的教程 适合中高级人员的使用

import java.sql.*;
public class Example15_9
{  public static void main(String args[])
   {  Connection con;PreparedStatement sqlOne,sqlTwo,sqlThree; 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");
             sqlOne=con.prepareStatement("UPDATE chengjibiao SET math=? WHERE number=?"); 
			 sqlOne.setInt(1,100);
			 sqlOne.setString(2,"2003001");
			 sqlOne.executeUpdate();	
			 sqlOne.setInt(1,99);
			 sqlOne.setString(2,"2003002");
			 sqlOne.executeUpdate();

			 sqlTwo=con.prepareStatement("INSERT INTO chengjibiao VALUES(?,?,?,?,?)"); 			 
			 sqlTwo.setString(1,"2003888");
			 sqlTwo.setString(2,"李向阳");
			 sqlTwo.setString(3,"1919-05-04");
			 sqlTwo.setInt(4,99);
			 sqlTwo.setInt(5,88);
			 sqlTwo.executeUpdate();	

			 sqlThree=con.prepareStatement("SELECT number,math,english FROM chengjibiao WHERE english>=? AND math>=?"); 
			 sqlThree.setInt(1,88);
			 sqlThree.setInt(2,90);
			 rs=sqlThree.executeQuery();

			 
             while(rs.next())
             { 
				 System.out.print("学号："+rs.getString(1));               
                 System.out.print("  数学："+rs.getInt(2)); 
				 System.out.println("  英语："+rs.getInt(3));
             }
            con.close();
           }
      catch(SQLException e1) { System.out.print(e1);}
   }    
}