java注册页面

来源：互联网发布：网络数据采集卡编辑：程序博客网时间：2024/05/17 09:22

<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");

String username = request.getParameter("username");
String password = request.getParameter("password");
String name = request.getParameter("name");
String code = request.getParameter("code");
String sex = request.getParameter("sex");
String email = request.getParameter("email");

Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student?characterEncoding=UTF-8",
"root", "");
PreparedStatement ps = conn.prepareStatement(
"insert into t_student(name, code, sex,email) values(?,?,?,?)");
ps.setString(1, name);
ps.setString(2, code);
ps.setInt(3, new Integer(sex));
ps.setString(4, email);
int i = ps.executeUpdate();//对象插入的条数
ps.close();

if(i == 1) { //判断如果等于1，就说明插入成功
ps = conn.prepareStatement(
"insert into t_studentcopy(username, password, type, stu_id) values(?,?,1,?)");
ps.setString(1, username);
ps.setString(2, password);
ps.setInt(3,1);
ps.executeUpdate();
ps.close();
}
conn.close();
%>
success
</body>
</html>

阅读全文

0 0