example15_7.java

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

import java.sql.*;
import java.util.LinkedList;
public class Example15_7
{  
	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:sun1","gxy","123");
             sql=con.createStatement();
			 int math=99,english=0;
			 String number="2003001",date,name,recode,updateStr,insertStr,delStr;
			 updateStr="UPDATE chengjibiao SET math = "+math+" WHERE number= "+"'"+number+"'";
             math=92;english=66;number="2003039";name="周王";date="1999-12-28";
			 recode="("+"'"+number+"'"+","+"'"+name+"'"+","+"'"+date+"'"+","+math+","+english+")";
			 
			 insertStr="INSERT INTO chengjibiao VALUES"+recode;			 
			 delStr="DELETE FROM chengjibiao WHERE number= '2003004' ";			 
             sql.executeUpdate(updateStr);			 
			 sql.executeUpdate(insertStr);			 
			 sql.executeUpdate(delStr);
             rs=sql.executeQuery("SELECT * FROM chengjibiao");
			 
			 while(rs.next())
			  {
				 number=rs.getString(1);
				 name=rs.getString(2);
				date=rs.getString(3);
				 math=rs.getInt("math");
				 english=rs.getInt("english");
				 System.out.print("学号："+number);
				 System.out.print(" 姓名："+name);
				 System.out.print(" 出生："+date);
				 System.out.print(" 数学："+math);
				 System.out.println(" 英语："+english);   

			   }
			   
            con.close();
           }
      catch(SQLException e1) {}
   
   }    
}