jdbc:mysql://localhost:3306/test1?characterEncoding=UTF-8
數據庫配置
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns=" xmlns:xsi=" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
<servlet>
<servlet-name>RegServlet</servlet-name>
<servlet-class>com.jht.RegServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>RegServlet</servlet-name>
<url-pattern>/RegServlet</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
index.jsp
<%
@ 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>
<title>用戶注冊</title>
<style type="text/css">
body{}{
margin: 0px;font-size: 12px;
}
.box{}{
border: 1px solid #D1DEB2; width: 150px; height: 20px;
}
.div1{}{
background-image: url(images/bg.jpg);
height: 600px;
width: 803px;
padding-left:20px;
padding-top:220px;
text-align:left;
}
</style>
<script type="text/javascript">
function reg(form){
if(form.username.value == ""){
alert("用戶不能為空！");
return false;
}
if(form.password.value == ""){
alert("密碼不能為空！");
return false;
}
if(form.repassword.value == ""){
alert("確認密碼不能為空！");
return false;
}
if(form.password.value != form.repassword.value){
alert("兩次密碼輸入不一致！");
return false;
}
if(form.question.value == ""){
alert("密碼找回問題不能為空！");
return false;
}
if(form.answer.value == ""){
alert("密碼找回答案不能為空！");
return false;
}
if(form.email.value == ""){
alert("電子郵箱不能為空！");
return false;
}
}
</script>
</head>
<body>
<div align="center">
<div class="div1">
<form action="RegServlet" method="post" onsubmit="return reg(this);">
<table align="center" border="0" width="500">
<tr>
<td align="right" width="30%">用戶名：</td>
<td><input type="text" name="username" class="box"></td>
</tr>
<tr>
<td align="right">密 碼：</td>
<td><input type="password" name="password" class="box"></td>
</tr>
<tr>
<td align="right">確認密碼：</td>
<td><input type="password" name="repassword" class="box"></td>
</tr>
<tr>
<td align="right">性 別：</td>
<td>
<input type="radio" name="sex" value="男" checked="checked">男
<input type="radio" name="sex" value="女">女
</td>
</tr>
<tr>
<td align="right">密碼找回問題：</td>
<td><input type="text" name="question" class="box"></td>
</tr>
<tr>
<td align="right">密碼找回答案：</td>
<td><input type="text" name="answer" class="box"></td>
</tr>
<tr>
<td align="right">郵 箱：</td>
<td><input type="text" name="email" class="box"></td>
</tr>
<tr>
<td colspan="2" align="center" height="40">
<input type="submit" value="注 冊">
<input type="reset" value="重 置">
</td>
</tr>
</table>
</form>
</div>
</div>
</body>
</html>
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
//import javax.print.DocFlavor.STRING;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
//import org.apache.catalina.util.URLEncoder;
/**
* Servlet implementation class RegServlet
*/
@WebServlet("/RegServlet")
public class RegServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private Connection conn;
private String charEncode = null;
// 初始化方法
public void init() throws ServletException {
super.init();
try {
this.charEncode = "UTF-8";
// 加載驅動
Class.forName("com.mysql.jdbc.Driver");
// 數據庫連接url
String url = "jdbc:mysql://localhost:3306/test1?characterEncoding=UTF-8";
// 獲取數據庫連接
conn = DriverManager.getConnection(url, "root", "root");
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* Default constructor.
*/
public RegServlet() {
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
// 設置request與response的編碼
//System.out.println("OK");
response.setContentType("text/html");
//servletRequest.setCharacterEncoding(charEncode);
//filterChain.doFilter(servletRequest, servletResponse);
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
// 獲取表單中屬性值
String username = request.getParameter("username");
String password = request.getParameter("password");
String sex = request.getParameter("sex");
String question = request.getParameter("question");
String answer = request.getParameter("answer");
String email = request.getParameter("email");
// 判斷數據庫中否連接成功
if (conn != null) {
try {
// 插入注冊信息的SQL語句(使用?占位符)
String sql = "insert into tb_user(username,password,sex,question,answer,email) "
+ "values(?,?,?,?,?,?)";
// 創建PreparedStatement對象
PreparedStatement ps = conn.prepareStatement(sql);
// 對SQL語句中的參數動態賦值
ps.setString(1, username );
ps.setString(2, password);
ps.setString(3, sex);
ps.setString(4, question);
ps.setString(5, answer);
ps.setString(6, email);
// 執行更新操作
ps.executeUpdate();
// 獲取PrintWriter對象
PrintWriter out = response.getWriter();
// 輸出注冊結果信息
out.print("<h1 aling='center'>");
out.print(username + "注冊成功！");
out.print("</h1>");
out.flush();
out.close();
} catch (Exception e) {
e.printStackTrace();
}
} else {
// 發送數據庫連接錯誤提示信息
response.sendError(500, "數據庫連接錯誤！");
}
}
}