1、在数据库jdbc中建立表teach，如下；
2、初始界面
3.1、按姓名查找（number为主键）
3.2、按学号进行删除（建议先查询再删除，也可直接输入学号删除）
3.3、增加记录（学号不可重复（主键））
3.4、修改记录
注意：本小应用未对异常进行处理，需要进行深一步优化，支持初学者对知识巩固。
代码如下
1：
package studentManager;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public final class JDBCUtils {
private static String url = "jdbc:mysql://127.0.0.1:3306/jdbc?"
+ "useUnicode=true&characterEncoding=utf-8&useSSL=false";
private static String user = "root";
private static String password = "user182872";
private JDBCUtils() {}
static {// 静态代码只会执行一次
// 1.加载驱动，
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url, user, password);
}
public static void free(ResultSet rs, Statement st, Connection conn) {
try {
if (rs != null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (st != null)
st.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
2：
package studentManager;
import java.awt.EventQueue;
import javax.swing.JFrame;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.JLabel;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.event.ActionEvent;
public class StudentManager {
private JFrame frame;
private JTextField nameT;
private JTextField cT;
private JTextField mT;
private JTextField classT;
private JTextField eT;
private JTextField numberT;
private JTextArea info;
private Connection conn = null;
private java.sql.PreparedStatement ps = null;
private ResultSet rs = null;
private String name;
private String number;
private String team;
private String chinese;
private String math;
private String english;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
StudentManager window = new StudentManager();
window.frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the application.
*/
public StudentManager() {
initialize();
}
/**
* Initialize the contents of the frame.
*/
private void initialize() {
frame = new JFrame();
frame.setBounds(100, 100, 433, 303);
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.getContentPane().setLayout(null);
JLabel label = new JLabel("\u59D3\u540D");
label.setBounds(23, 22, 54, 15);
frame.getContentPane().add(label);
JLabel label_1 = new JLabel("\u5B66\u53F7");
label_1.setBounds(102, 22, 54, 15);
frame.getContentPane().add(label_1);
JLabel label_2 = new JLabel("\u73ED\u7EA7");
label_2.setBounds(174, 22, 34, 15);
frame.getContentPane().add(label_2);
JLabel label_3 = new JLabel("\u8BED\u6587");
label_3.setBounds(231, 22, 54, 15);
frame.getContentPane().add(label_3);
JLabel label_4 = new JLabel("\u6570\u5B66");
label_4.setBounds(289, 22, 54, 15);
frame.getContentPane().add(label_4);
JLabel label_5 = new JLabel("\u82F1\u8BED");
label_5.setBounds(357, 22, 54, 15);
frame.getContentPane().add(label_5);
nameT = new JTextField();
nameT.setBounds(10, 47, 56, 24);
frame.getContentPane().add(nameT);
cT = new JTextField();
cT.setBounds(228, 47, 41, 24);
frame.getContentPane().add(cT);
mT = new JTextField();
mT.setBounds(288, 47, 41, 24);
frame.getContentPane().add(mT);
eT = new JTextField();
eT.setBounds(353, 47, 41, 24);
frame.getContentPane().add(eT);
classT = new JTextField();
classT.setBounds(167, 47, 41, 24);
frame.getContentPane().add(classT);
numberT = new JTextField();
numberT.setBounds(89, 47, 56, 24);
frame.getContentPane().add(numberT);
JButton addB = new JButton("\u589E");
addB.addActionListener(new Handle() {
public void actionPerformed(ActionEvent e) {
try {
get();
add();
info.setText("插入成功！");
// set();
} catch (SQLException e1) {
// e1.printStackTrace();
info.setText("插入失败！请确认学号是否重复？");
}
}
});
addB.setBounds(10, 101, 69, 23);
frame.getContentPane().add(addB);
JButton deleteB = new JButton("\u5220");
deleteB.addActionListener(new Handle() {
public void actionPerformed(ActionEvent e) {
try {
delete();
clc();
info.setText("删除成功！");
} catch (SQLException e1) {
// e1.printStackTrace();
info.setText("删除失败！请确认该记录是否存在？");
}
}
});
deleteB.setBounds(110, 101, 69, 23);
frame.getContentPane().add(deleteB);
JButton lookB = new JButton("\u67E5");
lookB.addActionListener(new Handle() {
public void actionPerformed(ActionEvent e) {
try {
get();
look();
set();
info.setText("查询成功！");
} catch (SQLException e1) {
// e1.printStackTrace();
info.setText("查询失败！请确认是否以输入姓名进行查询？");
}
}
});
lookB.setBounds(216, 101, 69, 23);
frame.getContentPane().add(lookB);
JButton changeB = new JButton("\u6539");
changeB.addActionListener(new Handle() {
public void actionPerformed(ActionEvent e) {
try {
get();
update();
set();
info.setText("修改成功！");
} catch (SQLException e1) {
// e1.printStackTrace();
info.setText("修改失败！");
}
}
});
changeB.setBounds(318, 101, 69, 23);
frame.getContentPane().add(changeB);
JButton clcB = new JButton("\u6E05\u7A7A");
clcB.addActionListener(new Handle() {
public void actionPerformed(ActionEvent e) {
clc();
}
});
clcB.setBounds(301, 231, 93, 23);
frame.getContentPane().add(clcB);
info = new JTextArea();
info.setBounds(10, 156, 384, 65);
frame.getContentPane().add(info);
JButton exitB = new JButton("\u9000\u51FA");
exitB.addActionListener(new Handle() {
public void actionPerformed(ActionEvent e) {
System.exit(0);
}
});
exitB.setBounds(10, 231, 93, 23);
frame.getContentPane().add(exitB);
}
private void look() throws SQLException {
try {
conn = JDBCUtils.getConnection();
String sql1 = "select * from teach where name=?";
ps = conn.prepareStatement(sql1);
ps.setString(1, name);
rs = ps.executeQuery();
while (rs.next()) {
read();
}
} finally {
rs.close();
ps.close();
conn.close();
}
}
private void add() throws SQLException {
try {
conn = JDBCUtils.getConnection();
String sql1 = "insert into teach values(?,?,?,?,?,?)";
ps = conn.prepareStatement(sql1);
setStringOne();
} finally {
rs.close();
ps.close();
conn.close();
}
}
private void delete() throws SQLException {
try {
conn = JDBCUtils.getConnection();
String sql1 = "delete from teach where number = ?";
ps = conn.prepareStatement(sql1);
ps.setInt(1, Integer.parseInt(number));
ps.executeUpdate();
} finally {
rs.close();
ps.close();
conn.close();
}
}
private void update() throws SQLException {
try {
conn = JDBCUtils.getConnection();
String sql1 = "update teach set name = ? , class = ? , Chinese = ?, Math = ? , English = ? where number = ?";
ps = conn.prepareStatement(sql1);
setStringTow();
} finally {
rs.close();
ps.close();
conn.close();
}
}
private void read() throws SQLException {
name = rs.getString(1);
number = rs.getString(2);
team = rs.getString(3);
chinese = rs.getString(4);
math = rs.getString(5);
english = rs.getString(6);
System.out.println(name + "\t" + number + "\t" + team + "\t" + chinese + "\t" + math + "\t" + english);
}
private void get() {
name = nameT.getText().trim();
number = numberT.getText().trim();
team = classT.getText().trim();
chinese = cT.getText().trim();
math = mT.getText().trim();
english = eT.getText().trim();
}
private void set() {
nameT.setText(name);
numberT.setText(number + "");
classT.setText(team);
cT.setText(chinese + "");
mT.setText(math + "");
eT.setText(english + "");
}
private void setStringOne() throws SQLException {
ps.setString(1, name);
ps.setInt(2, Integer.parseInt(number));
ps.setString(3, team);
ps.setInt(4, Integer.parseInt(chinese));
ps.setInt(5, Integer.parseInt(math));
ps.setInt(6, Integer.parseInt(english));
ps.executeUpdate();
}
private void setStringTow() {
try {
ps.setString(1, name);
ps.setString(2, team);
ps.setInt(3, Integer.parseInt(chinese));
ps.setInt(4, Integer.parseInt(math));
ps.setInt(5, Integer.parseInt(english));
ps.setInt(6, Integer.parseInt(number));
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
private void clc() {
nameT.setText(" ");
numberT.setText(" ");
classT.setText(" ");
cT.setText(" ");
mT.setText(" ");
eT.setText(" ");
}
class Handle implements ActionListener {
@Override
public void actionPerformed(ActionEvent e) {
}
}
}