Mysql+java的简单注册登录案例

import javax.swing.JFrame; import javax.swing.JFrame; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPasswordField; import javax.swing.JTextField; import javax.swing.WindowConstants; import java.io.FileWriter; import javax.swing.*; import java.awt.event.*; import java.awt.Component; import java.awt.Container; import java.awt.FlowLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.io.BufferedWriter; import java.io.File; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.awt.BorderLayout; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JTextField; import java.sql.*; public class LoginSurface extends JFrame { public LoginSurface() { //登录模块 JFrame enter=new JFrame("学生请假管理系统"); enter.setLayout(null); enter.setBounds(10, 10,520,500); enter.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE); enter.setVisible(true); JLabel account=new JLabel("登陆账号"); account.setBounds(70,5,120,40); enter.add(account); final JTextField accountfield=new JTextField(); accountfield.setBounds(130,10,180,30); enter.add(accountfield); JLabel enterpassword=new JLabel("登陆密码"); enterpassword.setBounds(70,45,120,40); enter.add(enterpassword); final JPasswordField enterpassword1=new JPasswordField(); enterpassword1.setBounds(130,50,180,30); enter.add(enterpassword1); JButton student=new JButton("登录"); student.setBounds(60,120,100,80); student.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent arg){ String LoginAccount=accountfield.getText(); String LoginPassword=enterpassword1.getText(); //1 获得连接 Connection conn = JDBCUtils.getConnection(); //2 拼装sql语句 String sql = "SELECT * FROM t_stu WHERE account=? AND password=?"; //3 获得PrepareStatement PreparedStatement ps = null; //5 运送参数,执行sql并拿到结果 ResultSet rs = null; try { ps = conn.prepareStatement(sql); //4 设置参数到ps对象中 ps.setString(1, LoginAccount); ps.setString(2, LoginPassword); rs = ps.executeQuery(); //5 根据结果判断是否登录成功 if (rs.next()) { System.out.println("登录成功!"); JOptionPane.showMessageDialog(null, "登录成功"); } else { System.out.println("登录失败!"); } } catch (SQLException e) { System.out.println("服务器繁忙，请稍后尝试");// TODO Auto-generated catch block e.printStackTrace(); } //6关闭资源 JDBCUtils.close(conn, ps, rs); } }); enter.add(student); //注册模块 JButton tutor=new JButton("注册"); tutor.setBounds(170,120,100,80); tutor.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent arg){ JFrame enterregister=new JFrame("欢迎进入注册端"); enterregister.setLayout(null); enterregister.setBounds(10, 10,520,500); enterregister.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE); enterregister.setVisible(true); JLabel accountregister=new JLabel("登陆账号"); accountregister.setBounds(70,5,120,40); enterregister.add(accountregister); final JTextField accountregisterfield=new JTextField(); accountregisterfield.setBounds(130,10,180,30); enterregister.add(accountregisterfield); JLabel enterpasswordregister=new JLabel("登陆密码"); enterpasswordregister.setBounds(70,45,120,40); enterregister.add(enterpasswordregister); final JPasswordField enterpasswordregister1=new JPasswordField(); enterpasswordregister1.setBounds(130,50,180,30); enterregister.add(enterpasswordregister1); JButton input=new JButton("提交"); input.setBounds(130,150,100,80); input.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent arg){ String account=accountregisterfield.getText(); String password=enterpasswordregister1.getText(); try { //1 获得连接 Connection conn = JDBCUtils.getConnection(); //2 书写sql语句 String sql="insert into t_stu (id,account,password)values(null,'"+account+"','"+password+"')"; //3 创建PrepareStatement PreparedStatement ps = conn.prepareStatement(sql); ps.executeUpdate(sql); System.out.println("测试"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("服务器正忙，请稍后操作"); } } }); enterregister.add(input); } }); enter.add(tutor); } public static void main(String[] args) { new LoginSurface();// TODO Auto-generated method stub } }