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;
}