©2020-2024 ioDraw All rights reserved
利用Java连接MySQL做登陆界面
1、首先需要建立一个类，在这里，我命名为newLogin
newLogin类的代码如下
package p4; import java.awt.Dimension; import java.awt.Font; import
java.awt.Toolkit; import java.awt.event.ActionEvent; import
java.awt.event.ActionListener; import java.sql.Connection; import
java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;
import javax.swing.ButtonGroup; import javax.swing.JButton; import
javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane;
import javax.swing.JPasswordField; import javax.swing.JRadioButton; import
javax.swing.JTextField; public class newLogin extends JFrame implements
ActionListener{ private static final long serialVersionUID = 1L; private
Connection con = null; private Statement statement = null; private ResultSet
res = null; private ButtonGroup buttongroup = new ButtonGroup(); private
MyPanel jp = new MyPanel(); private JLabel ul = new JLabel("用户名："); private
JLabel pl = new JLabel("密 码："); private JLabel ts = new JLabel(""); private
JTextField uname = new JTextField(); private JPasswordField pword = new
JPasswordField(); private JRadioButton[] butArray = { new
JRadioButton("学生",true), new JRadioButton("教师") }; private JButton login = new
JButton("登陆"); private JButton reset = new JButton("重置"); public newLogin() {
addListener(); initialFrame(); } private void initialFrame() { Font font = new
Font("宋体",Font.BOLD,12); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setTitle("登陆"); jp.setLayout(null); ul.setBounds(100, 30, 60, 30); jp.add(ul);
uname.setBounds(170, 30, 140, 30); jp.add(uname); pl.setBounds(100, 80, 60,
30); pword.setBounds(170, 80, 140, 30); jp.add(pl); jp.add(pword);
ts.setBounds(100, 160, 200, 50); jp.add(ts); ts.setFont(font);
login.setBounds(100, 220, 70, 30); jp.add(login); login.setFont(font);
reset.setBounds(220, 220, 70, 30); jp.add(reset); reset.setFont(font); add(jp);
setResizable(false); buttongroup.add(butArray[0]);
buttongroup.add(butArray[1]); butArray[0].setBounds(120, 130, 100, 50);
jp.add(butArray[0]); butArray[1].setBounds(220, 130, 100, 50);
jp.add(butArray[1]); butArray[0].setContentAreaFilled(false);
butArray[1].setContentAreaFilled(false); Dimension screenSize =
Toolkit.getDefaultToolkit().getScreenSize(); int centerX = screenSize.width/2;
int centerY = screenSize.height/2; int w = 427; int h = 331;
setBounds(centerX-w/2, centerY-h/2, w, h); setVisible(true);
uname.requestFocus(true); getContentPane().add(jp);
jp.getRootPane().setDefaultButton(login); } private void addListener() {
this.login.addActionListener(this); this.uname.addActionListener(this);
this.pword.addActionListener(this); } @Override public void
actionPerformed(ActionEvent e) { if(e.getSource() == uname) {
pword.requestFocus(); } if(e.getSource() == pword) {
butArray[0].requestFocus(); } if(e.getSource() == butArray[0]||e.getSource() ==
butArray[1]||e.getSource() == login) { //
this.ts.setText("正在为您努力加载，请稍等......"); int type =
this.butArray[0].isSelected()?0:1; String username =
this.uname.getText().trim(); char[] p = this.pword.getPassword(); String
password = String.valueOf(p).trim(); if(username.equals("")) {
JOptionPane.showMessageDialog(this, "请输入用户名！","错误",JOptionPane.ERROR_MESSAGE);
ts.setText(""); return ; } if(password.equals("")) {
JOptionPane.showMessageDialog(this, "请输入密码！","错误",JOptionPane.ERROR_MESSAGE);
ts.setText(""); return ; } try { con = new connection().getConnection();
//调用自己写的一个数据库连接类 statement = con.createStatement(); if(type == 0) { String sql
= "select * from stuuser where "+ "username_stu='"+username+"'and
password_stu='"+password+"'"; res = statement.executeQuery(sql); if(res.next())
{ JOptionPane.showMessageDialog(this,
"登录成功！","提示",JOptionPane.INFORMATION_MESSAGE); this.dispose(); } else {
JOptionPane.showMessageDialog(this,
"用户名或密码错误！","错误",JOptionPane.ERROR_MESSAGE); ts.setText(""); uname.setText("");
pword.setText(""); } //关闭数据库连接 if(res != null) { res.close(); } if(statement !=
null) { statement.close(); } if(con != null) { con.close(); } } else { String
sql = "select * from teauser where "+ "username_tea='"+username+"'and
password_tea='"+password+"'"; res = statement.executeQuery(sql); if(res.next())
{ String spec_name = res.getString(1); JOptionPane.showMessageDialog(this,
"登录成功！","提示",JOptionPane.INFORMATION_MESSAGE); this.dispose(); } else {
JOptionPane.showMessageDialog(this,
"用户名或密码错误！","错误",JOptionPane.ERROR_MESSAGE); ts.setText(""); uname.setText("");
pword.setText(""); } //关闭数据库连接 if(res != null) { res.close(); } if(statement !=
null) { statement.close(); } if(con != null) { con.close(); } }
}catch(SQLException ea) { ea.printStackTrace(); } } else if(e.getSource() ==
reset) { uname.setText(""); pword.setText(""); } } }
2、编写数据库连接类，在这里命名为connection,然后在类里写一个获取连接的放回，并返回一个连接。
connection类的代码如下：
package p4; import java.sql.Connection; import java.sql.DriverManager;
//import java.sql.ResultSet; import java.sql.SQLException; //import
java.sql.Statement; public class connection { private Connection con = null; //
private Statement statement = null; // private ResultSet res = null; String
driver = "com.mysql.cj.jdbc.Driver"; String url =
"jdbc:mysql://localhost:3306/Stu_manager?serverTimezone=Asia/Shanghai"; String
name = "root"; String passwd = "123456"; public connection() { } public
Connection getConnection() { try{ Class.forName(driver).newInstance(); con =
DriverManager.getConnection(url,name,passwd); }catch(ClassNotFoundException e){
System.out.println("对不起，找不到这个Driver"); e.printStackTrace(); }catch(SQLException
e){ e.printStackTrace(); }catch(Exception e){ e.printStackTrace(); } return
con; } }
3、在MySQL数据库中需建立两个用户表，分别用来存储不同用户的登陆账号和密码，这里学生用户表为stuuser,教师用户表为teauser,建表的SQL语句如下:
stuuser表：
create table stuuser( username_stu varchar(20) primary key, password_stu
char(20) not null, )ENGINE=InnoDB DEFAULT CHARSET=utf8;
teauser表：
create table teauser( username_tea varchar(20) primary key, password_tea
char(20) not null, )ENGINE=InnoDB DEFAULT CHARSET=utf8;
我也是初学不久，分享一下！