Java连接数据库登录表设计+登录界面

public class Registe {

private void button1ActionPerformed(ActionEvent e) {//注册按钮响应事件
    if(textField1.getText().equals("")||textField2.getText().equals("")||textField3.getText().equals("")||textField4.getText().equals("")){
        JOptionPane.showMessageDialog(null,"信息未填写完整");
    }
    else{
        try {
            con=DriverManager.getConnection(conURL,USER,PASS);  //连接数据库URL
            s=con.createStatement();
            ResultSet rs=s.executeQuery("select * from 用户");
            int flag=0;
            while (rs.next())
            {
                if(rs.getString(1).equals(textField1.getText()))
                {
                    JOptionPane.showMessageDialog(null,"用户名已存在");
                    flag=1;
                }
            }
            if(flag==0)     //用户名正确
            {
                if(!textField2.getText().equals(textField3.getText()))
                    JOptionPane.showMessageDialog(null,"两次输入的密码不相同");
                else    //密码两次输入相同
                {
                    String regExp = "^((13[0-9])|(14[5,7,9])|(15[0-3,5-9])|(166)|(17[3,5,6,7,8])" +
                            "|(18[0-9])|(19[8,9]))\\d{8}$";
                    Pattern p = Pattern.compile(regExp);
                    Matcher m = p.matcher(textField4.getText());
                    if(!m.matches()) {
                        JOptionPane.showMessageDialog(null, "手机号输入有误");
                        return;
                    }
                    //信息无误 保存至数据库
                    String str1=textField1.getText();
                    String str2=textField2.getText();
                    String str3=textField4.getText();
                    String sql="insert into 用户 values("+str1+","+str2+","+str3+");";
                    s.executeUpdate(sql);
                    JOptionPane.showMessageDialog(null,"注册成功,请登录!");
                    frame1.setVisible(false);
                }
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
}
public void initComponents() {
    // JFormDesigner - Component initialization - DO NOT MODIFY  //GEN-BEGIN:initComponents
    ResourceBundle bundle = ResourceBundle.getBundle("form.form");
    frame1 = new JFrame();
    panel2 = new JPanel();
    label3 = new JLabel();
    textField1 = new JTextField();
    panel3 = new JPanel();
    label4 = new JLabel();
    textField2 = new JTextField();
    panel4 = new JPanel();
    label5 = new JLabel();
    textField3 = new JTextField();
    panel5 = new JPanel();
    label6 = new JLabel();
    textField4 = new JTextField();
    panel6 = new JPanel();
    button1 = new JButton();

    //======== frame1 ========
    {
        var frame1ContentPane = frame1.getContentPane();
        frame1ContentPane.setLayout(new GridLayout(5, 0));

        //======== panel2 ========
        {
            panel2.setLayout(new FlowLayout(FlowLayout.CENTER, 5, 17));

            //---- label3 ----
            label3.setText(bundle.getString("label3.text"));
            panel2.add(label3);

            //---- textField1 ----
            textField1.setHorizontalAlignment(SwingConstants.LEFT);
            textField1.setPreferredSize(new Dimension(230, 30));
            panel2.add(textField1);
        }
        frame1ContentPane.add(panel2);

        //======== panel3 ========
        {
            panel3.setLayout(new FlowLayout(FlowLayout.CENTER, 5, 17));

            //---- label4 ----
            label4.setText(bundle.getString("label4.text"));
            panel3.add(label4);

            //---- textField2 ----
            textField2.setPreferredSize(new Dimension(230, 30));
            panel3.add(textField2);
        }
        frame1ContentPane.add(panel3);

        //======== panel4 ========
        {
            panel4.setLayout(new FlowLayout(FlowLayout.CENTER, 5, 17));

            //---- label5 ----
            label5.setText(bundle.getString("label5.text"));
            panel4.add(label5);

            //---- textField3 ----
            textField3.setPreferredSize(new Dimension(230, 30));
            panel4.add(textField3);
        }
        frame1ContentPane.add(panel4);

        //======== panel5 ========
        {
            panel5.setLayout(new FlowLayout(FlowLayout.CENTER, 5, 17));

            //---- label6 ----
            label6.setText(bundle.getString("label6.text"));
            panel5.add(label6);

            //---- textField4 ----
            textField4.setPreferredSize(new Dimension(230, 30));
            panel5.add(textField4);
        }
        frame1ContentPane.add(panel5);

        //======== panel6 ========
        {
            panel6.setLayout(new FlowLayout(FlowLayout.CENTER, 5, 17));

            //---- button1 ----
            button1.setText(bundle.getString("button1.text_2"));
            button1.setPreferredSize(new Dimension(200, 40));
            button1.addActionListener(e -> button1ActionPerformed(e));
            panel6.add(button1);
        }
        frame1ContentPane.add(panel6);
        frame1.setSize(440, 360);
        frame1.setLocationRelativeTo(frame1.getOwner());
    }
    // JFormDesigner - End of component initialization  //GEN-END:initComponents

    frame1.setType(Window.Type.POPUP);
    frame1.setVisible(true);
}

// JFormDesigner - Variables declaration - DO NOT MODIFY  //GEN-BEGIN:variables
private JFrame frame1;
private JPanel panel2;
private JLabel label3;
private JTextField textField1;
private JPanel panel3;
private JLabel label4;
private JTextField textField2;
private JPanel panel4;
private JLabel label5;
private JTextField textField3;
private JPanel panel5;
private JLabel label6;
private JTextField textField4;
private JPanel panel6;
private JButton button1;
String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";  //声明JDBC驱动程序对象
String conURL= "jdbc:sqlserver://localhost:1433;DatabaseName=Phone_Storage";
String USER = "sa";       //MySql用户名
String PASS = "123456";   //MySql密码,要采用你的密码
Connection con=null;
Statement s;
}
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值