<%@ 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>
