关于jsp的用户验证的问题!急急急 师兄,我给你说提示一下!用Servlet可以做出来的!去看一Servlet一下就明白了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 login.jsp:...<form action="login_do.jsp" method="post"> <input type="text" name="username"> <input type="password" name="password"></form>...login_do.jsp:...<% String username=request.getParameter("username"); String password=request.getParameter("password"); //这里验证用户和密码长度等等的代码就不写了 try{ //第一步 //MySql数据库 Class.forName("org.gjt.mm.mysql.Driver").netInstance(); //SqlServer数据库 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //MySql的驱动到官方网去找,SqlServer的到google找 //第二步 //MySql Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/ 数据库名 ","用户名,一般是root","密码"); //SqlServer Connection conn=DriverManager.getConnection(("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=数据库名","用户,一般是sa","密码"); //第三步 Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery("select * from user_table where username='"+username+"'"); //这里假设表为user_table,有两列,分别是username和password if(rs.next()){ String pass=rs.getString("password"); if(password.equals(pass){ out.write("成功"); }else{ out.write("密码错误");} }else{out.write("找不到用户名");} }catch(Exception e){out.write(e.toString());} 给你个简单的程序,我测试通过的:<form action="login.jsp" method="post"><center><img src="images/login_bk.gif" ></center><br>用户:<input type="text" name="username" onMouseOver=this.focus() onFocus=this.select() value="guest" size=10> <br> 密码:<input type="password" name="password" onMouseOver=this.focus() onFocus=this.select() size=10> <br> <br> <input name="submit" type="submit" value="登录系统"> ======================================================================下面是LOGIN。JSP<%String username=new String(request.getParameter("username").getBytes("ISO-8859-1")).trim();String password=new String(request.getParameter("password").getBytes("ISO-8859-1")).trim();ResultSet rs=null; try{ rs=myCon.myQuery("select * from login where username='"+username+"'"); rs.absolute(1); session.setAttribute("username1",rs.getString("username")); session.setAttribute("password1",rs.getString("password")); session.setAttribute("user_level",rs.getString("user_level")); }catch(SQLException e){ out.print(e); } if (password.equals(rs.getString("password").trim())) { response.sendRedirect("admin.jsp"); } else { out.print("对不起,禁止访问!"); }%> SSH中如何处理事务回滚的问题。 为什么文本域里面的内容不能选中 急问关于jsp配置问题 用java怎样将htm在网页中打开 通过Servlet选取htm 很急 在线等!!!!!!各位大大帮帮我吧!!! jsp程序运行出问题!!菜鸟求高手帮忙!!! jsp验证用户是否已经登录 引包时import net.sf.hibernate.*;提示无法解析导入是怎么事啊? jsp写入数据库乱码问题!!!! ie6下select会遮挡div应该怎么解决? 【JSP】IE无法加载flash 比较日期和日期相减 这样的网站。有人出5万。
.
.
.
<form action="login_do.jsp" method="post">
<input type="text" name="username">
<input type="password" name="password">
</form>
.
.
.
login_do.jsp:
.
.
.
<%
String username=request.getParameter("username");
String password=request.getParameter("password");
//这里验证用户和密码长度等等的代码就不写了
try{
//第一步
//MySql数据库
Class.forName("org.gjt.mm.mysql.Driver").netInstance();
//SqlServer数据库
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//MySql的驱动到官方网去找,SqlServer的到google找
//第二步
//MySql
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/
数据库名 ","用户名,一般是root","密码");
//SqlServer
Connection conn=DriverManager.getConnection(("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=数据库名","用户,一般是sa","密码");
//第三步
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from user_table where username='"+username+"'");
//这里假设表为user_table,有两列,分别是username和password
if(rs.next()){
String pass=rs.getString("password");
if(password.equals(pass){
out.write("成功");
}else{ out.write("密码错误");}
}else{out.write("找不到用户名");}
}catch(Exception e){out.write(e.toString());}
<center><img src="images/login_bk.gif" ></center><br>
用户:<input type="text" name="username" onMouseOver=this.focus() onFocus=this.select() value="guest" size=10> <br>
密码:<input type="password" name="password" onMouseOver=this.focus() onFocus=this.select() size=10>
<br> <br>
<input name="submit" type="submit" value="登录系统"> ======================================================================
下面是LOGIN。JSP<%String username=new String(request.getParameter("username").getBytes("ISO-8859-1")).trim();
String password=new String(request.getParameter("password").getBytes("ISO-8859-1")).trim();
ResultSet rs=null;
try{
rs=myCon.myQuery("select * from login where username='"+username+"'");
rs.absolute(1);
session.setAttribute("username1",rs.getString("username"));
session.setAttribute("password1",rs.getString("password"));
session.setAttribute("user_level",rs.getString("user_level"));
}catch(SQLException e){
out.print(e);
}
if (password.equals(rs.getString("password").trim())) {
response.sendRedirect("admin.jsp");
}
else {
out.print("对不起,禁止访问!");
}%>