功能要求：
1) 在磁盘上创建一个Mysql数据库，名称自定，在该数据库下建立一个数据表，名称为userTable，表结构如图12-4所示，表中的数据不要录入（用注册窗口添加）。
2) 用户在登录窗口点击注册进入注册界面，在注册窗口中输入账号、姓名、性别、出生日期、email和密码（要验证两次密码一致性）等信息后，单击“注册”按钮后完成用户注册功能。并且将数据添加到数据库中。
3) 注册帐号过程中，输入完账号后，回车，进行账号字符有效性验证，如果正确，将焦点自动切换到姓名文本框（不用鼠标切换）；否则，弹出对话框，提示错误，并将焦点保持在账号文本框；用同样方法实现Email地址合法性验证；在确认密码输入结束后，按回车，完成注册功能（即等同于点击注册按钮）
4) 用户在登录窗口中输入用户和口令，单击“登录”按钮后，如果用户和口令与数据表文件中某一行匹配，则弹出对话框（对话框的文字提示信息是“登录成功！”），并进入“更改密码”窗口，否则弹出对话框（对话框的文字提示信息是“用户或口令不正确！”）
5) 在“更改密码”窗口中输入相应信息后，单击“确定”，完成更改密码功能。可以打开数据库验证是否成功！
6) 建议设计三个窗口类（登录、注册和更改密码）、一个用户类（至少包括以下方法：数据库连接方法、添加数据方法、登录验证方法、更改密码方法以及用于数据合法性检测的方法）。
package mytest; public class Login { boolean success = false; String id; String password; public void setID(String string) { this.id = string; } public void setPassword(String password) { this.password = password; } public String getID() { return id; } public String getPassword() { return password; } public void setSuccess(boolean success) { this.success = success; } public boolean getSuccess() { return success; } } package mytest; public class Change { boolean success = false; String id; String password; public void setID(String string) { this.id = string; } public void setPassword(String password) { this.password = password; } public String getID() { return id; } public String getPassword() { return password; } public void setSuccess(boolean success) { this.success = success; } public boolean getSuccess() { return success; } } package mytest; public class Register { String id; String password; String email; String sex; String name; String birth; public void setID(String string) { this.id = string; } public void setPassword(String password) { this.password = password; } public void setSex(String sex) { this.sex = sex; } public void setEmail(String email) { this.email = email; } public void setBirth(String birth) { this.birth = birth; } public void setName(String name) { this.name = name; } public String getName() { return name; } public String getID() { return id; } public String getPassword() { return password; } public String getSex() { return sex; } public String getEmail() { return email; } public String getBirth() { return birth; } } package mytest; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JFrame; import mytest.*; import mytest.Login; import mytest.Register; public class RegAndLog extends JFrame { RLview rl; RegAndLog(){ setBounds(100,100,800,260); rl = new RLview(); add(rl); setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); setVisible(true); } public static void main(String args[]) { RegAndLog window = new RegAndLog(); window.setTitle("登录"); } } package mytest; import java.awt.*; import javax.swing.*; import mytest.Register; import java.awt.event.*; public class RegisterView extends JPanel implements ActionListener, ItemListener{ Register register; JTextField id,name,email,password1,password2; JComboBox sex,year,month,day; int[] DAY={31,28,31,30,31,30,31,31,30,31,30,31}; JButton reg,esc; RegisterView(){ register = new Register(); id = new JTextField(15); name =new JTextField(15); email =new JTextField(15); password1 = new JTextField(15); password2 =new JTextField(15); reg = new JButton("注册"); esc = new JButton("退出"); add(new JLabel("账号：")); add(id); add(new JLabel("姓名：")); add(name); add(new JLabel("性别")); sex = new JComboBox(); sex.addItem("male"); sex.addItem("female"); add(sex); year=new JComboBox(); month=new JComboBox(); day=new JComboBox(); add(new JLabel("出生日期")); for(int i=1910;i<2021;i++) { year.addItem(i); } add(year); add(new JLabel("年")); for(int i=1;i<13;i++) { month.addItem(i); month.addItemListener(this); } add(month); add(new JLabel("月")); add(day); add(new JLabel("日")); // add(new JLabel("Email")); add(new JLabel(“email：")); add(email); add(new JLabel("密码：")); add(password1); add(new JLabel("确认密码")); add(password2); add(reg); add(esc); reg.addActionListener(this); esc.addActionListener(this); } @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub if(e.getSource()==esc) { System.exit(0); } if(e.getSource()==reg) { register.setID(id.getText()); register.setName(name.getText()); register.setEmail(email.getText()); register.setSex(sex.getSelectedItem().toString()); String born = year.getSelectedItem().toString()+"-"+ month.getSelectedItem().toString() +"-"+day.getSelectedItem().toString(); register.setBirth(born); if(password1.getText().equals(password2.getText())) { register.setPassword(password1.getText()); } else { JOptionPane.showMessageDialog(null,"密码前后不一致","警告",JOptionPane.WARNING_MESSAGE); } HandleReg hr = new HandleReg(); hr.writeReg(register); } } public void itemStateChanged(ItemEvent e) { if (e.getSource() == month) { String year = this.year.getSelectedItem().toString();//获取选中 //已知年份 String mon = this.month.getSelectedItem().toString();//获取月份 int y = Integer.valueOf(year); int m = Integer.valueOf(mon);//转换为int if ((y % 4 == 0 && y % 100 != 0) || y % 400 == 0) { DAY[1] = 29; } else { DAY[1] = 28;//判断闰年 } day.removeAllItems();//清空选项列表、 for (int i = 0; i < DAY[m - 1]; i++) { day.addItem(i + 1); } } } } package mytest; import java.awt.*; import javax.swing.*; import mytest.*; import mytest.Login; import java.awt.event.*; public class LoginView extends JPanel implements ActionListener{ Login login; JTextField id; JPasswordField pass; JButton log,esc; boolean success; LoginView(){ login = new Login(); id = new JTextField(15); pass = new JPasswordField(15); log = new JButton("登录"); esc = new JButton("退出"); add(new JLabel("账号")); add(id); add(new JLabel("密码")); add(pass); add(log); add(esc); log.addActionListener(this); esc.addActionListener(this); } public boolean isSuccess() { return success; } @Override public void actionPerformed(ActionEvent e) { if(e.getSource()==esc) { System.exit(0); } if(e.getSource()==log) { login.setID(id.getText()); char [] pw = pass.getPassword(); login.setPassword(new String (pw)); HandleLog hl = new HandleLog(); login = hl.queryVerify(login); success = login.getSuccess(); } } } package mytest; import java.sql.*; import javax.swing.JOptionPane; import mytest.Register; public class HandleReg { Connection con; PreparedStatement preSql; public HandleReg() { try { Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} String uri = "jdbc:mysql://localhost:3306/test?useSSL=true&characterEncoding=utf-8"; try { // 表名↑ 密码↓ con = DriverManager.getConnection(uri,"root","z123"); } catch (SQLException e) {System.out.println(e.toString());} } public void writeReg(Register register) {//更新 String sqlStr = "insert into mess values(?,?,?,?,?,?)"; int ok = 0; try { preSql = con.prepareStatement(sqlStr);//链接 preSql.setString(1,register.getID());//更新数据 preSql.setString(2, register.getName()); preSql.setString(3, register.getSex()); preSql.setString(4, register.getBirth()); preSql.setString(5, register.getEmail()); preSql.setString(6, register.getPassword()); ok = preSql.executeUpdate(); con.close(); } catch (NullPointerException e){ System.out.println(e.toString()); } catch(SQLException e) { System.out.println(e.toString()); JOptionPane.showMessageDialog(null,"id不能重复","警告",JOptionPane.WARNING_MESSAGE);//提示 } if(ok!=0) { JOptionPane.showMessageDialog(null,"注册成功","恭喜",JOptionPane.WARNING_MESSAGE); } } } package mytest; import java.sql.*; import javax.swing.JOptionPane; import mytest.Login; public class HandleLog { Connection con;//链接 PreparedStatement pre;//驱动 ResultSet rs; public HandleLog() { try { Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} String uri = "jdbc:mysql://localhost:3306/test?useSSL=true&characterEncoding=utf-8"; try { // ku名 密码↓ con = DriverManager.getConnection(uri,"root","zyk123"); } catch(Exception e){System.out.println(e.toString());} } public Login queryVerify(Login logins) { String id = logins.getID(); String pw = logins.getPassword(); String sqlStr = "select userID,password from mess where userID = ? and password = ?";//注意语法 try { pre = con.prepareStatement(sqlStr); pre.setString(1,id); pre.setString(2, pw); rs = pre.executeQuery(); if(rs.next()==true) { logins.setSuccess(true); JOptionPane.showMessageDialog(null,"登录成功","恭喜",JOptionPane.WARNING_MESSAGE); } else { logins.setSuccess(false); JOptionPane.showMessageDialog(null,"登录失败","抱歉",JOptionPane.WARNING_MESSAGE); } } catch(Exception e){ System.out.println(e.toString()); } return logins; } } package mytest; import java.sql.*; import javax.swing.JOptionPane; import mytest.Login; public class HandleChange { Connection con; PreparedStatement sql; ResultSet rs; public HandleChange() { try { Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} String uri = "jdbc:mysql://localhost:3306/test?useSSL=true&characterEncoding=utf-8"; try { // 数据库名 密码↓ con = DriverManager.getConnection(uri,"root","z123"); } catch(Exception e){ System.out.println(e.toString()); } if(con==null) return; } public Change query(Change ch) { String id = ch.getID(); String pw = ch.getPassword(); String sqlStr = "update mess set password=? where userID =?"; try { sql = con.prepareStatement(sqlStr); sql.setString(1,ch.getPassword()); sql.setString(2,ch.getID()); int ok = sql.executeUpdate();//括号里面不能再写sqlStr ch.setSuccess(true); System.out.println(ok); } catch(Exception e){ System.out.println(e.toString()); } return ch; } } package mytest; import java.awt.BorderLayout; import javax.swing.JPanel; import javax.swing.JTabbedPane; import java.awt.*; public class RLview extends JPanel{ JTabbedPane p; RegisterView reg; LoginView log; ChangePass pa; public RLview() { reg = new RegisterView(); log = new LoginView(); pa = new ChangePass(); setLayout(new BorderLayout()); p =new JTabbedPane(); p.add("注册",reg); p.add("登录",log); p.add("修改密码",pa); p.invalidate(); add(p,BorderLayout.CENTER); } } package mytest; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JFrame; import mytest.*; import mytest.Login; import mytest.Register; public class RegAndLog extends JFrame { RLview rl; RegAndLog(){ setBounds(100,100,800,260); rl = new RLview(); add(rl); setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); setVisible(true); } public static void main(String args[]) { RegAndLog window = new RegAndLog(); window.setTitle("登录"); } }