JSP登陆界面.doc

用Jsp做的一个简单的登陆界面，连接Mysql，数据库名字为school，表为user。 主要分为四个Jsp界面：index.jsp登陆界面，check.jsp检验页面，main.jsp登陆成功界面，error.jsp登陆失败界面。 如下所示： %@ page language=java import=java.util.* pageEncoding=utf-8% html head meta http-equiv=Content-Type content=text/html;charset=UTF-8 title登陆界面/title /head body brbrbrbrbrbrbrbr center form action=check.jsp method=post table width=380 border=2 bgcolor=#95BDFF tr tdbrh1nbsp nbsp nbsp 欢迎光临，请登陆/h1/td /tr tr td brnbsp nbsp nbsp nbsp 用户名字 : nbsp input name=username type=text size=28 brbr nbsp nbsp nbsp nbsp 用户密码 : nbsp input name=userpass type=password size=29 brbr nbsp nbsp nbsp nbsp nbsp nbsp nbsp nbsp nbsp input type=submit name=submit value=提交 style=height:30px;width:80px nbsp nbsp nbsp nbsp nbsp nbsp input type=reset name=reset value=取消 style=height:30px;width:80px brnbsp /td /tr /table /form /center /body /html %@ page language=java import=java.sql.* pageEncoding=utf-8% html head meta http-equiv=Content-Type content=text/html;UTF-8 title登陆界面/title /head body % String username = new String(request.getParameter(username).getBytes(ISO-8859-1),utf-8); String password = new String(request.getParameter(userpass).getBytes(ISO-8859-1),utf-8); session.setAttribute(name,username); Connection dbconn = null; Statement stmt = null; ResultSet rs = null; if(username.equals()){ response.sendRedirect(index.jsp); } try{ String driver = com.mysql.jdbc.Driver; String url = jdbc:mysql://localhost:3306/school; String user = sa; String Password = 123; Class.forName(driver); dbconn = DriverManager.getConnection(url, user, Password); stmt = dbconn.createStatement()