import java.sql.*;
public class Test {
/** Creates a new instance of Test */
public Test() {
}
public static void main(String agr[]){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
try {
Connection cn=DriverManager.getConnection("jdbc:odbc:example");
PreparedStatement ps=cn.prepareStatement("insert into UserOnLine (user_id,user_name) values('5','7')");
ps.executeUpdate();
ps=cn.prepareStatement("insert into UserOnLine (user_id,user_name) values('5','7')");
ps.executeUpdate();
ps=cn.prepareStatement("select * from UserOnLine",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
System.out.println(rs.getString(3));
}
rs.last();
System.out.println(rs.getRow());
cn.commit();
rs.close();
ps.close();
cn.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
打印说明已经插入成功但是没有在UserOnline里显示怎么回事
public class Test {
/** Creates a new instance of Test */
public Test() {
}
public static void main(String agr[]){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
try {
Connection cn=DriverManager.getConnection("jdbc:odbc:example");
PreparedStatement ps=cn.prepareStatement("insert into UserOnLine (user_id,user_name) values('5','7')");
ps.executeUpdate();
ps=cn.prepareStatement("insert into UserOnLine (user_id,user_name) values('5','7')");
ps.executeUpdate();
ps=cn.prepareStatement("select * from UserOnLine",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
System.out.println(rs.getString(3));
}
rs.last();
System.out.println(rs.getRow());
cn.commit();
rs.close();
ps.close();
cn.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
打印说明已经插入成功但是没有在UserOnline里显示怎么回事
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货