我写了一个小程序
是用html页面提交给jsp页面处理登陆 我把链接数据库都封装到了一个类里面,对数据库的操作也是一样
但是 他给我报ResultSet没当前行 是什么? 下面是我的代码
这是JSP页面的
<%
javabean obj = new javabean();
String name = request.getParameter("txtUserName");
String pass = request.getParameter("txtUserPassword");
String yanzhengma = request.getParameter("txtName");
obj.setTxtUserNmae(name);
obj.setTxyUserPass(pass);
ResultSet rs = obj.yanzheg();
int namelength = name.length();
int passlength = pass.length();
int yanzhengmalength = yanzhengma.length();
String varcode = (String)session.getAttribute("varcode");
String str1 = rs.getString(1);
System.out.println("------------------------------");
String str2 = rs.getString(2);
if( namelength != 0 && passlength != 0 && yanzhengmalength != 0)
{
System.out.println("ccccccccccccccc");
while(rs.next())
{
if(varcode.equals(yanzhengma))
{
if(str1.equals(name) && str2.equals(pass))
{
out.print("window.alert('登陆成功')");
out.print("window.location.herf='login.jsp'");
}
}
else
{
out.print("window.alert('验证码输入错误,请重新输入')");
out.print("window.location.herf='login.jsp'");
}
}
out.print("window.alert('无此用户或用户密码错误')");
out.print("window.location.herf='login.jsp'");
}
else
{
out.print("window.alert('输入不完整,请检查输入')");
out.print("window.location.herf='login.jsp'");
}
%>
这是JAVABEAN的
package org.baijie8.JDBC;
import java.sql.ResultSet;
import java.sql.SQLException;
public class javabean {
private String TxtUserNmae;
private String TxyUserPass;
public String getTxtUserNmae() {
return TxtUserNmae;
}
public void setTxtUserNmae(String txtUserNmae) {
TxtUserNmae = txtUserNmae;
}
public String getTxyUserPass() {
return TxyUserPass;
}
public void setTxyUserPass(String txyUserPass) {
TxyUserPass = txyUserPass;
}
public ResultSet yanzheg()
{
try {
User u = new User();
ResultSet rs = u.resultset(this);
return rs;
}
catch (SQLException e){
e.printStackTrace();
}
return null;
}
}
package org.baijie8.JDBC;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class User {
private Connection conn= null;
public ResultSet resultset(javabean user) throws SQLException
{
try
{
JdbcUtil ju =new JdbcUtil();
conn = ju.getsqlConnection();
String sql = "select * from controller_info where controller_name=? and controller_pass=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,user.getTxtUserNmae());
ps.setString(2, user.getTxyUserPass());
return ps.executeQuery();
}
catch (SQLException e)
{
e.printStackTrace();
}
return null;
}
}