我用以下代码访问数据库,但奇怪的是无论查询条件是否满足,getFetchSize的返回值总是1,不知为何?请高人指教!!Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Example");
Statement sql=con.createStatement();
ResultSet rs=null;String StrSQL="SELECT * FROM tb_UserInfo WHERE Email='"+StrEmail+"' AND Password='"+StrPassword+"'";
System.out.println(StrSQL);
rs=sql.executeQuery(StrSQL);
if(rs.getFetchSize()==1){
SystemMessage=SM_LOGIN_OK;
System.out.println("Login OK");
}else{
SystemMessage=SM_LOGIN_FAILED;
System.out.println("Login FAILED");
}
Connection con=DriverManager.getConnection("jdbc:odbc:Example");
Statement sql=con.createStatement();
ResultSet rs=null;String StrSQL="SELECT * FROM tb_UserInfo WHERE Email='"+StrEmail+"' AND Password='"+StrPassword+"'";
System.out.println(StrSQL);
rs=sql.executeQuery(StrSQL);
if(rs.getFetchSize()==1){
SystemMessage=SM_LOGIN_OK;
System.out.println("Login OK");
}else{
SystemMessage=SM_LOGIN_FAILED;
System.out.println("Login FAILED");
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货