50,526
社区成员
发帖
与我相关
我的任务
分享
public class Test2 {
public static void main(String[] args) {
SIMS s=new SIMS();
s.setTitle("JDBC");
}
}
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
import javax.swing.*;
public class SIMS extends JFrame implements ActionListener{
private static final long serialVersionUID=-4699312170519171360L;
JTextField text1,text2,text3,result;
JButton button1,button2,button3;
static Connection con=null;
public SIMS()
{
init();
setBounds(100,100,350,200);
setVisible(true);
setLayout(new FlowLayout());
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
public void init()
{
text1=new JTextField(10);
text2=new JTextField(10);
text3=new JTextField(10);
result=new JTextField(20);
button1=new JButton("追加");
button2=new JButton("查询");
button3=new JButton("删除");
button1.addActionListener(this);
button2.addActionListener(this);
button3.addActionListener(this);
add(new JLabel("学号:"));
add(text1);
add(button1);
add(new JLabel("姓名:"));
add(text2);
add(button2);
add(new JLabel("年龄:"));
add(text3);
add(button3);
add(result);
connect();
}
static Connection connect() {
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/students?useSSL=true&characterEncoding=utf8", "root", "");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return con;
}
public void insert() {
try {
Connection con = connect();
Statement statement = con.createStatement();
String sno, sname, age;
sno = text1.getText();
sname = text2.getText();
age = text3.getText();
String str = "insert into t1 values('" + sno + "','" + sname + "',"
+ age + ")";
statement.executeUpdate(str);
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void select() {
try {
Connection con=connect();
Statement statement=con.createStatement();
String sno;
sno=text1.getText();
String str="select * from t1 where sno="+sno;
ResultSet rs=statement.executeQuery(str);
while(rs.next()) {
sno=rs.getString(1);
String sname=rs.getString(2);
int age=rs.getInt(3);
result.setText(sno+" "+sname+" "+age);
}
rs.close();
statement.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
public void delete() {
try {
Connection con=connect();
Statement statement =con.createStatement();
String sno;
sno=text1.getText();
String str="delete from t1 where sno="+sno;
statement.executeUpdate(str);
statement.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
public void actionPeformed(ActionEvent e)
{
if(e.getSource()==button1)
insert();
if(e.getSource()==button2)
select();
if(e.getSource()==button3)
delete();
}
@Override
public void actionPerformed(ActionEvent e) {
// TODO 自动生成的方法存根
}
}