例12-4.txt

这是一本java基础教程 对新手上路有很大帮助

import java.sql.*; 
import java.util.*; 
public class Example12_4{
    public static void main(String args[]){
         Connection con;
         Statement sql; 
         ResultSet rs;
         Calendar calendar=Calendar.getInstance();
         calendar.set(1999,9,18); //注意9代表十月
         java.sql.Date date=new java.sql.Date(calendar.getTimeInMillis()); 
         try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
         }
         catch(ClassNotFoundException e){
               System.out.println(""+e);
         }
         try{   con=DriverManager.getConnection("jdbc:odbc:hello","","");
               sql=con.createStatement
              (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
               rs=sql.executeQuery("SELECT * FROM message");
               rs.absolute(3);
               rs.updateString(2,"王晓二");
               rs.updateRow();    //将message表第3行记录的name的值更新为“王晓二”
               rs.moveToInsertRow();
               rs.updateString(1,"005");
               rs.updateString(2, "陈大林");
               rs.updateDate(3,date);
               rs.updateDouble(4,1.79);
               rs.insertRow();     //向message表插入一行记录
               rs=sql.executeQuery("SELECT * FROM message");
               while(rs.next()){
                  String number=rs.getString(1);
                  String name=rs.getString(2);
                  java.sql.Date birth=rs.getDate(3);
                  double height=rs.getDouble(4);
                  System.out.println(number+","+name+","+birth+","+height);
               }
               con.close();
         }
         catch(SQLException e){
               System.out.println(e);
         }
    }
}