<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@ page contentType="text/html"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>My JSP 'index.jsp' starting page</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> <form action="my.jsp" method="get" name="登录"> <h2>登录界面</h2> 账号：<input id="uname" type="text" name="user"> </br> 密码：<input id="upass" type="password" name="psw"></br> <input type="submit" value="注册"> <input id="login" type="button" value="登录"> </form> </body> </html> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@ page contentType="text/html"%> <%@ page import="java.sql.*"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>My JSP 'index.jsp' starting page</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> <% Connection con = null; Statement sql; ResultSet rs; String num1="123"; String password1="123"; try { //加载数据库驱动 Class.forNmae("com.mysql.jdbc.Driver"); } catch (Exception e) { out,print("<h>"+e); } String url="jdbc:mysql:///stu"; String user="root"; String password="123456"; try{ con=DriverManager.getConnection(url,user,password); rs=sql.executeQuery("select * from number"); rs.last(); num1=rs.getInt(1); password=rs.getInt(2); con.close(); } String name = request.getParameter("user"); String password = request.getParameter("psw"); if (name.equals(num1) && password.equals(password1)) { out.println("我的账号是:" + name1); out.println("我的密码是:" + password1); } else { out.println("登录失败"); } %> </body> </html>