utilize Java connect MySQL Do login interface
1, First, you need to create a class , ad locum , I named it newLogin
newLogin The code for the class is as follows
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(" user name :"); private
JLabel pl = new JLabel(" dense code :"); private JLabel ts = new JLabel(""); private
JTextField uname = new JTextField(); private JPasswordField pword = new
JPasswordField(); private JRadioButton[] butArray = { new
JRadioButton(" student ",true), new JRadioButton(" teacher ") }; private JButton login = new
JButton(" land "); private JButton reset = new JButton(" Reset "); public newLogin() {
addListener(); initialFrame(); } private void initialFrame() { Font font = new
Font(" Song style ",Font.BOLD,12); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setTitle(" land "); 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(" Loading for you , One moment please ......"); 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, " enter one user name !"," error ",JOptionPane.ERROR_MESSAGE);
ts.setText(""); return ; } if(password.equals("")) {
JOptionPane.showMessageDialog(this, " Please input a password !"," error ",JOptionPane.ERROR_MESSAGE);
ts.setText(""); return ; } try { con = new connection().getConnection();
// Call a database connection class written by yourself 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,
" Login successful !"," Tips ",JOptionPane.INFORMATION_MESSAGE); this.dispose(); } else {
JOptionPane.showMessageDialog(this,
" Wrong user name or password !"," error ",JOptionPane.ERROR_MESSAGE); ts.setText(""); uname.setText("");
pword.setText(""); } // Close database connection 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,
" Login successful !"," Tips ",JOptionPane.INFORMATION_MESSAGE); this.dispose(); } else {
JOptionPane.showMessageDialog(this,
" Wrong user name or password !"," error ",JOptionPane.ERROR_MESSAGE); ts.setText(""); uname.setText("");
pword.setText(""); } // Close database connection 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, Write database connection class , Name it here connection, Then write a return to get the connection in the class , And return a connection .
connection The code for the class is as follows :
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(" I'm sorry , I can't find this Driver"); e.printStackTrace(); }catch(SQLException
e){ e.printStackTrace(); }catch(Exception e){ e.printStackTrace(); } return
con; } }

3, stay MySQL Two user tables need to be established in the database , It is used to store the login account and password of different users , The student user table is stuuser, The teacher user table is teauser, Tabular SQL The statement is as follows :
stuuser surface :
create table stuuser( username_stu varchar(20) primary key, password_stu
char(20) not null, )ENGINE=InnoDB DEFAULT CHARSET=utf8;
teauser surface :
create table teauser( username_tea varchar(20) primary key, password_tea
char(20) not null, )ENGINE=InnoDB DEFAULT CHARSET=utf8;

I'm a beginner too , Share it !

Technology