关于“数据库"的问题

Question

public register_ui() {
        JFrame frame = new JFrame("注册");
        frame.setDefaultCloseOperation(3);
        frame.setBounds(500, 100, 600, 600);
        JPanel panel = new JPanel(new GridBagLayout());
        frame.setContentPane(panel);
        GridBagConstraints constraints = new GridBagConstraints();
        constraints.fill = GridBagConstraints.NONE;
        constraints.anchor = GridBagConstraints.WEST;
        constraints.insets = new Insets(10, 10, 10, 10);

        JLabel label1 = new JLabel("学号/职工号:");
        constraints.gridx = 0;
        constraints.gridy = 0;
        constraints.insets = new Insets(10, 10, 10, 10);
        panel.add(label1, constraints);

        JTextField textField1 = new JTextField(20);
        constraints.gridx = 1;
        constraints.gridy = 0;
        panel.add(textField1, constraints);

        JLabel label2 = new JLabel("密码:");
        constraints.gridx = 0;
        constraints.gridy = 1;
        panel.add(label2, constraints);

        JPasswordField passwordField = new JPasswordField(20);
        constraints.gridx = 1;
        constraints.gridy = 1;
        panel.add(passwordField, constraints);

        JLabel label3 = new JLabel("手机号:");
        constraints.gridx = 0;
        constraints.gridy = 2;
        panel.add(label3, constraints);

        JTextField textField3 = new JTextField(20);
        constraints.gridx = 1;
        constraints.gridy = 2;
        panel.add(textField3, constraints);

        JButton button0 = new JButton("发送验证码");
        constraints.gridx = 2;
        constraints.gridy = 2;
        panel.add(button0, constraints);

        JButton button = new JButton("确认注册");
        constraints.gridx = 0;
        constraints.gridy = 3;
        constraints.gridwidth = 2;
        constraints.insets = new Insets(20, 10, 10, 10);
        panel.add(button, constraints);

        JButton button2 = new JButton("返回上一步");
        constraints.gridx = 0;
        constraints.gridy = 4;
        panel.add(button2, constraints);
        button2.addActionListener((e) -> {
            frame.dispose();
                new login_ui();
        });

        String password = new String(passwordField.getPassword());
        button.addActionListener((e)->{
            try {
                frame.dispose();
                add(textField1.getText(),password);
                new registerok_ui();
            } catch (SQLException ex) {
                throw new RuntimeException(ex);
            }
        }) ;
        frame.setVisible(true);
    } 
protected void add(String text, String text1) throws SQLException {
        String url = "jdbc:mysql:///test";
        String username = "root";
        String password = "000";
        Connection conn = DriverManager.getConnection(url, username, password);

        //定义插入的内容
        String ID = text;
        String password1 = text1;

        //定义sql语句
        String sql1 = "insert into lo_res(ID,password1) values(?,?);";

        PreparedStatement pstmt = conn.prepareStatement(sql1);

        //设置对应的参数
        pstmt.setString(1, ID);
        pstmt.setString(2, password1);

        //执行sql
        int count = pstmt.executeUpdate();   //影响的行数
        //释放资源
        System.out.println(count > 1);
        pstmt.close();
        conn.close();
    }

密码插不进去数据表

Answer 1

这里传进去的有值么