jsp实现的简单登陆代码.docVIP

jsp实现的简单登陆代码 Jsp Login页面(配合数据库) 前台login.html和后台verifylogin.jsp两个页面组成: login.html内容: html head title登录/title meta http-equiv=content-type content=text/html; charset=UTF-8 meta http-equiv=Content-Language content=ch-cn /head body !-- Form 用来提取用户填入并提交的信息-- form method=post name=frmLogin action=verifylogin.jsp h1 align=center用户登录/h1br div align=center用户名： input type=text name=txtUserName value=Your name onfocus=if(this.value==Your name)this.value=;br密码： input type=password name=txtPassword value=Your password onfocus=if(this.value==Your password)this.value=;br input type=submit name=Submit　value=提交 nbsp;nbsp;nbsp;nbsp;nbsp; input type=reset name=Reset value=重置br /div/form/body /html verifylogin.jsp内容: %@ page language=java contentType=text/html;charset=gb2312 pageEncoding=UTF-8% %@ page import=java.sql.*% %@ page import=java.util.*% !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head title登录/title meta http-equiv=pragma content=no-cache meta http-equiv=cache-control content=no-cache meta http-equiv=expires content=0 meta http-equiv=keywords content=keyword1,keyword2,keyword3 meta http-equiv=description content=This is my page !-- link rel=stylesheet type=text/css href=styles.css -- /head body div align=center % //获取用户名 String sUserName = request.getParameter ( txtUserName ); //获取密码 String sPasswd = request.getParameter ( txtPassword ); //登记JDBC驱动程序 Class.forName ( org.gjt.mm.mysql.Driver ).newInstance ( ); //连接参数与Access不同 String url = jdbc:mysql://localhost/LearnJSP; //建立连接 Connection connection = DriverManager.getConnection ( url, root, 011124 ); //SQL语句 String sql = select * from userinfo where username= + sUserName + and userpwd = + sPasswd + ; Statement stmt = connection.createStatement ( ); ResultSet rs = stmt.executeQuery ( sql ); //返回查询结果 //如果记录集非空，表明有匹配的用户名和密码，登陆成功 if ( rs.next ( ) ) { out.println ( 登录成功！ ); } else //否则登录失败 { ou