package user;
public class User {
private int number;
private int password;
public int getNumber() {
return number;
}
public void setNumber(int number) {
this.number = number;
}
public int getPassword() {
return password;
}
public void setPassword(int password) {
this.password = password;
}
public User() {
super();
// TODO Auto-generated constructor stub
}
public User(int number, int password) {
super();
this.number = number;
this.password = password;
}
}
package user;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
public class Preson {
public static int addstu(User s) throws ClassNotFoundException,
SQLException {
int i = 0;
try {
// 加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
// 获取数据库连接对象
Connection conn = (Connection) DriverManager.getConnection(
"jdbc:mysql:///stu", "root", "123456");
// 获取SQL语句执行者
PreparedStatement pstmt = (PreparedStatement) conn
.prepareStatement("insert into number values(?,?)");
// 执行SQL语句
ResultSet rs = (ResultSet) pstmt.executeQuery();
// 5.处理结果集
pstmt.setInt(1, s.getNumber());
pstmt.setInt(2, s.getPassword());
i = pstmt.executeUpdate();
conn.close();
pstmt.close();
rs.close();
} catch (Exception e) {
}
return i;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<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="submit" value="注册">
</form>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="user.Preson"%>
<%@ page import="user.User"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<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">
</head>
<body>
<%
User s = new User();
strig name = request.getParameter("user");
s.setNumber(name);
string password = request.getParameter("psw");
s.setPassword(password);
Preson ps = new Preson();
if (ps.addstu(s) > 0) {
out.print("注册成功");
} else {
out.println("注册失败");
}
%>
</body>
</html>
