主要写的是doPost方法的
类Servlet.java
package com.sinsoft.service;
import java.io.IOException;
import java.io.Writer;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;
/**
* @auther madong
* @date 2019/5/6-15:28
*/
@javax.servlet.annotation.WebServlet(name = "servlet")
public class Servlet extends javax.servlet.http.HttpServlet {
private Connection conn = null;
protected void doPost(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {
// TODO Auto-generated method stub
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
Writer out = response.getWriter();
//向服务器发送请求获取到参数
String username = request.getParameter("username");
String password = request.getParameter("password");
String password2 = request.getParameter("password2");
String email = request.getParameter("email");
String age = request.getParameter("age");
if (password.equals(password2)) {
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test";
conn = DriverManager.getConnection(url, "root", "000000");
String sql = "INSERT INTO tr_user (username,password,email,age) VALUES (?,?,?,?)";
Statement stmt = conn.createStatement();
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, password);
pstmt.setString(3, email);
pstmt.setString(4, age);
pstmt.executeUpdate();
pstmt.close();
conn.close();
response.setHeader("Content-Type", "text/html; charset=UTF-8");
out.write("用户名：" + username);
out.write("密码：" + password);
out.flush();
out.close();
} catch (Exception e) {
System.out.println("数据库连接失败！");
e.printStackTrace();
}
}else {
response.setHeader("Content-Type", "text/html; charset=UTF-8");
out.write("两次输入的密码不一致");
}
}
protected void doGet(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {
}
}
页面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>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录</title>
</head>
<body>
<h3>登录</h3>
<hr>
<form action="servlet" method="post">
用户名： <input type="text" name="username"/><br>
密码: <input type="text" name="password"/><br>
确认密码:<input type="text" name="password2"/><br>
邮箱: <input type="text" name="email"/><br>
年龄: <input type="text" name="age"/><br>
<input type="submit" />
</form>
</body>
</html>
web.xml文件配置
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<servlet>
<servlet-name>Servlet</servlet-name>
<servlet-class>com.sinsoft.service.Servlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Servlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
