帮忙看看这个程序,怎么结果出不来
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,那个地方出问题了呢,帮忙看看
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,那个地方出问题了呢,帮忙看看
...全文
相关推荐
modelsim中当你的波形出不来的时候你改怎么办呢?
在modelsim中进行仿真的时候,当你的波形出不来的时候,你该怎么弄呢!入门者请关注,或许对你有帮助!!
C#写Windows服务调用EXE,界面出不来,需要调用Cjwdev.WindowsApi.dll
最近项目中需要用C#写Windows服务调用EXE,最终进程什么的都有了,就是界面出不来,查看相关的资料,需要调用Cjwdev.WindowsApi.dll,但是这个在网上可不好下载,所以就拿来分享了。
c语言程序结果。c语言程序结果。c语言程序结果。c语言程序结果。
c语言程序结果。c语言程序结果。c语言程序结果。c语言程序结果。c语言程序结果。c语言程序结果。c语言程序结果。c语言程序结果。c语言程序结果。c语言程序结果。c语言程序结果。
表格导出Excel,表格导出excel出不来,GO源码.zip
表格导出Excel,表格导出excel出不来,GO源码.zip
pycharm运行程序时看不到任何结果显示的解决
今天小编就为大家分享一篇pycharm运行程序时看不到任何结果显示的解决,具有很好的参考价值,希望对大家有所帮助。一起跟随小编过来看看吧


Web 开发
