登录代码 - 编程论坛

#2

piaoxue2006-04-21 09:56

用户验证的代码？？能有什么代码呀．就是查询语句吧，从你数据库里面查出当前你写的用户名和密码，能和数据库里面的一直，就可以登陆进去，不一致就返回！

#3

zhangyan09292006-04-21 11:34

<%
String rs_username=request.getParameter("rs_username");
String rs_password=request.getParameter("rs_password");
String sql="select * from C_Member where rs_username='"+rs_username+"' and rs_password='"+rs_password+"'";
ResultSet rs=db.executeQuery(sql);
if(rs.next())
{
session.putValue("rs_username",rs_username);
session.putValue("rs_password",rs_password);
response.sendRedirect("index.jsp");
}else
{
out.print("您输入的会员名或密码不正确请重新输入！");
}
%>

#4

lixin10202006-04-21 14:18

给你传个mysql的驱动WEB-INF\lib下mysql-connector-java-3.1.8-bin
提交后的页面
<%
try{
String loginName = request.getParameter("loginName");
String password = request.getParameter("password");
Class.forName("com.mysql.jdbc.Driver");
String dbUrl ="jdbc:mysql://localhost:3306/frm";
String dbUser="root";
String dbPwd ="root";
Connection con = DriverManager.getConnection(dbUrl,dbUser,dbPwd);
Statement stmt = con.createStatement();

ResultSet rs=stmt.executeQuery("SELECT * from test where loginName='" + loginName + "' and password='" + password + "'");
if(rs.next()){
rs.close();
stmt.close();
con.close();
session.setAttribute("loginName",loginName);
response.sendRedirect("welcome.jsp");
}
else {
rs.close();
stmt.close();
con.close();
response.sendRedirect("failure.jsp");
}
}
catch(Exception e){
out.println(e.getMessage());
}

%>