String count = "select count(*) from XT_UnitSet";
String sql = "";
try {
GetOaDb god = new GetOaDb();
Connection cnn = god.getConnection();
PreparedStatement pstmt = cnn.prepareStatement(count);
// pstmt.setString(1, unitActionForm.getUserCode());
// pstmt.setString(2, unitActionForm.getPassword()); ResultSet resultSet = pstmt.executeQuery();
if (resultSet.getString(1)=="0") {
sql = "insert into XT_UnitSet(U_Name,U_Tel,U_Fax,U_Zipcode,U_Address,U_Website,U_Email,U_Bank,U_Account,UnitID) values(?,?,?,?,?,?,?,?,?,'1')";
}
else
{
sql="update XT_UnitSet set U_Name=?,U_Tel=?,U_Fax=?,U_Zipcode=?,U_Address=?,U_Website=?,U_Email=?,U_Bank=?,U_Account=?";
}
运行到红色的地方就报错
String sql = "";
try {
GetOaDb god = new GetOaDb();
Connection cnn = god.getConnection();
PreparedStatement pstmt = cnn.prepareStatement(count);
// pstmt.setString(1, unitActionForm.getUserCode());
// pstmt.setString(2, unitActionForm.getPassword()); ResultSet resultSet = pstmt.executeQuery();
if (resultSet.getString(1)=="0") {
sql = "insert into XT_UnitSet(U_Name,U_Tel,U_Fax,U_Zipcode,U_Address,U_Website,U_Email,U_Bank,U_Account,UnitID) values(?,?,?,?,?,?,?,?,?,'1')";
}
else
{
sql="update XT_UnitSet set U_Name=?,U_Tel=?,U_Fax=?,U_Zipcode=?,U_Address=?,U_Website=?,U_Email=?,U_Bank=?,U_Account=?";
}
运行到红色的地方就报错
System.out.println(resultSet.getRow()); 打印出来看看结果集的行数.
试下
Java语言深入:深入研究Java equals方法,equals,==,equals用法
或者if (resultSet.getString(1).equals("0"))
一运行到这句还是报错
不过你比较还是得用equals!
可能 resultSet 是空的所以 报错。
{
....................................................
}