第二十天：Servlet+mysql+html 增删改查 (代码)

本文链接：https://blog.csdn.net/java_wht/article/details/72803559

0.数据库的sql如下：

create table user(
 id int primary key auto_increment,
 name varchar(20),
 salary varchar(9),
 age varchar(2),
 sex char(2),
 tel varchar(11));

1.index.html 用户注册的首页：

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>用户注册！</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="add" method="post" align="center">
  		<h1> 这是一个用户注册页面！</h1>
    		<table align="center">
    			<tr><td>name:</td><td><input type="text" name="name"/></td></tr>
    			<tr><td>salary</td><td><input type="text" name="salary"/></td></tr>
    			<tr><td>age:</td><td><input type="text" name="age"/></td></tr>
    			<tr><td>sex:</td><td>M:<input type="radio" name="sex" value="M"/>
    			W:<input type="radio" name="sex" value="W"/></td></tr>
    			<tr><td>tel:</td><td><input type="text" name="tel"/></td></tr>
    		</table>
    		<input type="submit" value="提交"/>
    	</form> <br>
  </body>
</html>

2.add的Servlet

package com.user.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

//页面注册用户的Servlet
@SuppressWarnings("serial")
public class Add extends HttpServlet{
    protected void service(HttpServletRequest request,HttpServletResponse response) throws IOException{
        //避免出现乱码可以提前设置一下
        request.setCharacterEncoding("GBK");
        response.setContentType("text/html;charset=gbk");
        PrintWriter pw=response.getWriter();
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test01","root","1234");
            String sql="insert into user(name,salary,age,sex,tel) values(?,?,?,?,?)";
            PreparedStatement ps= conn.prepareStatement(sql);
            ps.setString(1, request.getParameter("name"));
            ps.setString(2, request.getParameter("salary"));
            ps.setString(3, request.getParameter("age"));
            ps.setString(4, request.getParameter("sex"));