各位编程界的高手,我是一个初学java的人,想问一下在用java语言如何判断不是数据库里的数据啊,我摸索了好长时间都无较好的结果,请各位帮帮忙我的代码如下packagecn.czmec;importja...
各位编程界的高手,我是一个初学java的人,想问一下在用java语言如何判断不是数据库里的数据 啊,我摸索了好长时间都无较好的结果,请各位帮帮忙 我的代码如下
package cn.czmec;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import db.Jdbc;
import bean.LoginBean;
public class LoginServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
PrintWriter out = response.getWriter();
String name=request.getParameter("username").trim();
String pwd=request.getParameter("pwd").trim();
try {
Jdbc user=new Jdbc();
/*ResultSet rs=user.getRs("select * from users where name='"+name+"' ");
while(rs.next())
{
String uname=rs.getString("name").trim();
String upwd=rs.getString("pw").trim();
if(uname.equals(name)&& upwd.equals(pwd))
{
response.sendRedirect("info.jsp");
return;
}
else
{
response.sendRedirect("error.jsp");
return;
}
}*/
ArrayList us=new ArrayList();
us=user.getRecord("select * from users where name='"+name+"'");
for(int i=0;i
{
if(us.get(i).getName().trim().equals(name))
{
if(us.get(i).getPwd().trim().equals(pwd))
{
HttpSession session =request.getSession();
session.setAttribute("usname",us.get(i).getName());
response.sendRedirect("info.jsp");
}
else
{
response.sendRedirect("error.jsp");
}
}
else
{
out.print("没有该用户");
}
}
}
catch (Exception e) {
e.printStackTrace();
}
out.flush();
out.close();
}
}
我把连接数据库的代码写在一个单独的类里了,实例化以后我调用了里面的一个方法 我估计是在if(rs.next)与while(rs.next)之间可能有问题,当然我现在用的是while(rs.next),请高手再指教指教
展开