2022-5-6

CREATE DATABASE filmdb CHARACTER SET utf8;

USE filmdb;

CREATE TABLE filmdb(
  uid VARCHAR(32) PRIMARY KEY,    -- 用户ID
  uname VARCHAR(20) , -- 用户名
  upass VARCHAR(20) , -- 密码
  phone VARCHAR(20) , -- 电话
  sex VARCHAR(10) -- 性别
); 

public class zuoye {

    public static void main(String[] args) {

        {
            Scanner sc = new Scanner(System.in);
            System.out.print("请输入您的姓名:");
            String uname = sc.next();
            System.out.print("请输入您的密码:");
            String upass = sc.next();
            System.out.print("请输入您的性别:");
            String sex = sc.next();
            System.out.print("请输入您的手机:");
            String phone = sc.next();


            Connection conn;
            Statement statement;

            try {
                Class.forName("com.mysql.jdbc.Driver");
                conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/filmdb?characterEncoding=UTF-8&rewriteBatchedStatements=true", "root", "123456");
                statement = conn.createStatement();

                String sql = "INSERT INTO users VALUES (null,'" + uname + "','" + upass + "','" + sex + "','" + phone + " ')"; //注册的SQL语句

                System.out.println("注册成功，欢迎你："+uname);
                int count = statement.executeUpdate(sql);
            } catch (ClassNotFoundException | SQLException e) {
                e.printStackTrace();
            }



        }
    }
}