给个例子你吧:
private Connection Conn = null;
private Statement Stmt = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Conn = DriverManager.getConnection(dbUrl, user, password);
Stmt = Conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sqlStr = "UPDATE OR INSERT TABLE";//更新或添加记录
Stmt.executeUpdate(sqlStr);
sqlStr = "SELECT * FROM TABLE";//查询
ResultSet rs = Stmt.executeQuery(sqlStr);
}catch(Exception e){}
private Connection Conn = null;
private Statement Stmt = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Conn = DriverManager.getConnection(dbUrl, user, password);
Stmt = Conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sqlStr = "UPDATE OR INSERT TABLE";//更新或添加记录
Stmt.executeUpdate(sqlStr);
sqlStr = "SELECT * FROM TABLE";//查询
ResultSet rs = Stmt.executeQuery(sqlStr);
}catch(Exception e){}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货