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:zhaoguoxian","system","1375413");
sql=con.createStatement
(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=sql.executeQuery("SELECT * FROM message");
rs.absolute(3);//到达指定行
rs.updateString(2,"ssss");
rs.updateRow(); //将message表第3行记录的name的值更新为“王晓二”
rs.moveToInsertRow();
rs.updateString(1,"aa");
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);
}
}
}
用结果集更新数据库时
查询结果出现16进制的数;
1000 ,aaaa,1998-10-01,1.75
2000 ,bbbb,1990-12-20,1.6
3000 ,73737373,2004-01-10,1.8
6161 ,CCEFD5F0,1999-10-18,1.79
6161 ,CCEFD5F0,1999-10-18,1.79