package com.example.controller;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.example.pojo.User;
import com.example.service.UserService;
import com.example.service.UserServiceImpl;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.net.URLDecoder;
@WebServlet(name = "Reiister", value = "/Reigister")
public class Reigister extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        /* 設(shè)置中文字符編碼，防止亂碼*/
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("UTF-8");
        //以json數(shù)據(jù)完成操作
        response.setContentType("application/json;charset=UTF-8");
        System.out.println(request.getContentType());// 得到客戶端發(fā)送過(guò)來(lái)內(nèi)容的類型，application/json;charset=UTF-8
        System.out.println(request.getRemoteAddr());// 得到客戶端的ip地址，
        BufferedReader br = new BufferedReader(new InputStreamReader(// 使用字符流讀取客戶端發(fā)過(guò)來(lái)的數(shù)據(jù)
                request.getInputStream()));
        String line = null;
        StringBuffer s = new StringBuffer();//StringBuffer String的區(qū)別，如果要對(duì)數(shù)據(jù)作頻繁的修改，則用StringBuffer
        // 以一行的形式讀取數(shù)據(jù)
        while ((line = br.readLine()) != null) {
            s.append(line);
        }
        // 關(guān)閉io流
        br.close();
        System.out.println(s.toString());
        //JSON：這是json解析包，idea是沒(méi)有的，要我們自己導(dǎo)入
        User user = JSON.parseObject(s.toString(), User.class);//是用了發(fā)射機(jī)制來(lái)完成對(duì)象的封閉
        //以u(píng)tf-8解碼操作
        String number = URLDecoder.decode(user.getNumber(), "utf-8");
        String name = URLDecoder.decode(user.getName(), "utf-8");
        String phone = URLDecoder.decode(user.getPhone(), "utf-8");
        String password = URLDecoder.decode(user.getPassword(), "utf-8");
        System.out.println("用戶名是：" + name + ", 密碼;" + password);
        System.out.println(user);
        // 去數(shù)據(jù)庫(kù)完成用戶注冊(cè)功能
        UserService us = new UserServiceImpl();
        //調(diào)用注冊(cè)的方法
        int i = us.reigisterUser(number, name, phone, password);
        boolean rs = false;
        //判斷是否注冊(cè)成功
        if (i > 0) {
            System.out.println("注冊(cè)成功");
            rs = true;
        }
        //將結(jié)果返回給客戶端	，將結(jié)果構(gòu)建成json數(shù)據(jù)返回給客戶端
        JSONObject rjson = new JSONObject();
        rjson.put("json", rs);
        response.getOutputStream().write(
                rjson.toString().getBytes("UTF-8"));// 向客戶端發(fā)送一個(gè)帶有json對(duì)象內(nèi)容的響應(yīng)
    }
}

package com.example.pojo;
public class User {
    private int id;
    private String number;
    private String name;
    private String password;
    private String phone;
    private String remark;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getNumber() {
        return number;
    }
    public void setNumber(String number) {
        this.number = number;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getPhone() {
        return phone;
    }
    public void setPhone(String phone) {
        this.phone = phone;
    }
    public String getRemark() {
        return remark;
    }
    public void setRemark(String remark) {
        this.remark = remark;
    }
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", number='" + number + '\'' +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                ", phone='" + phone + '\'' +
                ", remark='" + remark + '\'' +
                '}';
    }
}

package com.example.service;
public class UserServiceImpl implements UserService {
    UserDao ud = new UserDaoImpl();
    @Override
    public int reigisterUser(String number, String name, String phone, String password) {
        int i = ud.insertUser(number, name, phone, password);
        return i;
    }
}

package com.example.dao;
public class UserDaoImpl implements UserDao {
    @Override
    public int insertUser(String number, String name, String phone, String password) {
        String sql = "insert into user (number, name, phone, password, remark) values(?,?,?,?,?);";
        //i如果操作成功，就是操作成功的條數(shù)
        int i = JDBCUtil.executeUpdate(sql, number, name, phone, password, "1");
        System.out.println("數(shù)據(jù)庫(kù)的條數(shù):");
        return i;
    }
}

package com.example.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBCUtil {
    private static final String DRIVER = "com.mysql.jdbc.Driver";
    private static final String URL = "jdbc:mysql://127.0.0.1:3306/androiddb1?useUnicode=true&characterEncoding=utf-8";
    private static final String USER = "root";
    private static final String PASSWORD = "jin1687062650";
    private static Connection ct;
    private static PreparedStatement ps;
    private static ResultSet rs;
    static {
        // 1.加載驅(qū)動(dòng),只需要加載一次,所以放到靜態(tài)代碼塊中
        try {
            Class.forName(DRIVER);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    /**
     * 描述:封裝一個(gè)方法可以獲得連接,目的可以在其他地方之接調(diào)用
     */
    public static Connection getConnection() {
        try {
            ct = DriverManager.getConnection(URL, USER, PASSWORD);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return ct;
    }
    /**
     * 描述:封裝一個(gè)方法可以完成查詢操作
     *
     * @param sql 要查詢的sql語(yǔ)句
     * @param obj 占位符的具體內(nèi)容
     * @return ResultSet 將查詢到的結(jié)果返回
     */
    public static ResultSet executeQuery(String sql, Object... obj) {
        // 1.得到連接
        ct = getConnection();
        // 2.創(chuàng)鍵發(fā)送對(duì)象
        try {
            ps = ct.prepareStatement(sql);
            // 處理占位符問(wèn)題
            if (obj != null) {
                for (int i = 0; i < obj.length; i++) {
                    ps.setObject(i + 1, obj[i]);
                }
            }
            rs = ps.executeQuery();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return rs;
    }
    /**
     * 描述:封裝一個(gè)方法可以完成DDL,DML操作
     *
     * @param sql 要操作的sql語(yǔ)句
     * @param obj 占位符
     * @return
     */
    public static int executeUpdate(String sql, Object... obj) {
        // 1.得到連接
        ct = getConnection();
        // 2.創(chuàng)鍵發(fā)送對(duì)象
        try {
            ps = ct.prepareStatement(sql);
            // 處理占位符問(wèn)題
            if (obj != null) {
                for (int i = 0; i < obj.length; i++) {
                    ps.setObject(i + 1, obj[i]);
                }
            }
            int in = ps.executeUpdate();
            close(ct, ps, null);
            return in;
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return 0;
    }
    /**
     * 描述:封裝一個(gè)關(guān)閉資源的方法
     *
     * @param ct 連接對(duì)象
     * @param ps 發(fā)送sql語(yǔ)句對(duì)象
     * @param rs 返回值對(duì)象
     */
    public static void close(Connection ct, PreparedStatement ps, ResultSet rs) {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        if (ps != null) {
            try {
                ps.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        if (ct != null) {
            try {
                ct.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
    // 給外部一個(gè)訪問(wèn)ct,和ps的方法
    public static Connection getCt() {
        return ct;
    }
    public static PreparedStatement getPs() {
        return ps;
    }
}