帮忙看看这个程序,怎么结果出不来

shanyou shanyou 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
DBConnection.java
package my;
import java.sql.*;


public class DBConnection
{
String createConn;
Connection con = null;
Statement stmt;
ResultSet rs;

public DBConnection()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ljn","SYSTEM","manager");
}catch(ClassNotFoundException e)
{
System.out.println(e);
}
catch(SQLException e)
{
System.out.println(e);
}
}

public ResultSet getRs(String s)
{

if(con == null)
{
try
{
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ljn","SYSTEM","manager");
stmt = con.createStatement();
rs = stmt.executeQuery(s);
return rs;
}catch(SQLException e)
{
System.err.println(e);
rs = null;
close();
return rs;
}
}
else
{
try
{
stmt = con.createStatement();
rs = stmt.executeQuery(s);
return rs;
}catch(SQLException e)
{
System.err.println(e);
rs = null;
close();
return rs;
}
}
}

public void close()
{

try
{
if(con != null)
{
con.close();
}
}
catch(SQLException e)
{
System.out.print(e);
}
}
}

AdminLogin.java
package my;
import java.sql.*;


public class AdminLogin
{

String adminName;
String adminPwd;
String success="false",message="";
private DBConnection dbConnection;
ResultSet rs = null;


public AdminLogin()
{
dbConnection = new DBConnection();
}

public void setAdminName(String name)
{
adminName = name;
}
public String getAdminName()
{
return adminName;
}

public void setAdminPwd(String password)
{
adminPwd = password;
}
public String getAdminPwd()
{
return adminPwd;
}
//查询数据库的administrator表
public String getMessage()
{
try
{
String condition = "select * from administrator where adminName = '"+adminName+"'";


rs = dbConnection.getRs(condition);
String name = null;
String ps = null;

while(rs.next())
{
name = rs.getString("adminName");
ps = rs.getString("adminPwd");
name=name.trim();
ps = ps.trim();
System.out.println(name);
System.out.println(ps);
}

if((adminName.equals(name))&&(adminPwd.equals(ps)))
{
message = "OK";
success = "true";
}
else
{
message = "ERROR";
success = "false";
}
dbConnection.close();
return message;
}catch(SQLException e)
{
message = "输入的用户名或密码错误";
System.out.println(e);
return message;
}
}
public static void main(String args[])
{
AdminLogin admin = new AdminLogin();
String s;

admin.setAdminName("ljn");
admin.setAdminPwd("ljn");
s = admin.getMessage();
System.out.println(s);
}

}
rs.next的结果总是false,那个地方出问题了呢,帮忙看看



...全文
评论 6
收藏 已收藏
分享
返回顶部
shanyou
Web 开发 81,108 成员 341,721 内容