private void resetText() {

 text1.setText("");

 text2.setText("");

 text3.setText("");

 }

 

 // 刷新學(xué)生信息方法（該方法是重新讀取數(shù)據(jù)庫(kù)學(xué)生的信息 然后返回一個(gè)學(xué)生的集合 用于刷新Jtable表格對(duì)象中的數(shù)據(jù)）

 private List<Student> select(ResultSet rs) throws SQLException {

 List<Student> st = new ArrayList<Student>();

 while (rs.next()) {

 Student s = new Student();

 s.setId(rs.getString(1));

 s.setName(rs.getString(2));

 s.setAge(rs.getString(3));

 st.add(s);

 }

 return st;

 

 }

 

 // 添加按鈕-監(jiān)聽(tīng)器（該方法是對(duì)添加按鈕實(shí)現(xiàn)的具體方法 ）

 class insert implements ActionListener {

 

 @Override

 public void actionPerformed(ActionEvent e) {

 stu = new ArrayList<Student>();

 Student sd = new Student();

 JDBCDaoImpl jdbc = new JDBCDaoImpl();

 sd = setStu();

 if (sd != null) {

 jdbc.insert(sd);

 ResultSet rs = jdbc.search();

 try {

  stu = select(rs);

 } catch (SQLException e1) {

  e1.printStackTrace();

 }

 jdbc.closeConnection();

 JTable table = new JTable(new Table(stu));//新建一個(gè)Jtable 對(duì)象 用來(lái)盛放增加后的學(xué)生信息

 setJTable(table);//設(shè)置Jtable信息

 Test.this.scrollpane.setViewportView(table);//把Jtable設(shè)置到Panel

 resetText();

 } else {

 JOptionPane.showMessageDialog(Test.this, "輸入數(shù)據(jù)不完整");

 

 }

 

 }

 

 }

 

 // 刪除按鈕-監(jiān)聽(tīng)器（該方法是對(duì)刪除按鈕實(shí)現(xiàn)的具體方法）

 class delete implements ActionListener {

 

 @Override

 public void actionPerformed(ActionEvent e) {

 stu = new ArrayList<Student>();

 Student sd = new Student();

 JDBCDaoImpl jdbc = new JDBCDaoImpl();

 sd = setStu();

 if (sd != null) {

 jdbc.delete(sd);

 ResultSet rs = jdbc.search();

 try {

  stu = select(rs);

 } catch (SQLException e1) {

  e1.printStackTrace();

 }

 jdbc.closeConnection();

 JTable table = new JTable(new Table(stu));//新建一個(gè)Jtable 對(duì)象 用來(lái)盛放增加后的學(xué)生信息

 setJTable(table);//設(shè)置Jtable信息

 Test.this.scrollpane.setViewportView(table);//把Jtable設(shè)置到Panel

 resetText();

 } else {

 JOptionPane.showMessageDialog(Test.this, "輸入數(shù)據(jù)不完整");

 

 }

 

 }

 

 }

 

 // 更新按鈕-監(jiān)聽(tīng)器（該方法是對(duì)更新按鈕實(shí)現(xiàn)的具體方法）

 class update implements ActionListener {

 

 @Override

 public void actionPerformed(ActionEvent e) {

 stu = new ArrayList<Student>();

 Student sd = new Student();

 JDBCDaoImpl jdbc = new JDBCDaoImpl();

 sd = setStu();

 if (sd != null) {

 jdbc.update(sd);

 ResultSet rs = jdbc.search();

 try {

  stu = select(rs);

 } catch (SQLException e1) {

  e1.printStackTrace();

 }

 jdbc.closeConnection();

 JTable table = new JTable(new Table(stu));//新建一個(gè)Jtable 對(duì)象 用來(lái)盛放增加后的學(xué)生信息

 setJTable(table);//設(shè)置Jtable信息

 Test.this.scrollpane.setViewportView(table);//把Jtable設(shè)置到Panel

 resetText();

 } else {

 JOptionPane.showMessageDialog(Test.this, "輸入數(shù)據(jù)不完整");

 

 }

 

 }

 

 }

 

 // Student類 （用于封裝數(shù)據(jù)信息和數(shù)據(jù)庫(kù)表進(jìn)行映射）

 public class Student {

 // 學(xué)生的id name age信息

 private String id;

 private String name;

 private String age;

 

 // get&set方法

 public String getId() {

 return id;

 }

 

 public void setId(String id) {

 this.id = id;

 }

 

 public String getName() {

 return name;

 }

 

 public void setName(String name) {

 this.name = name;

 }

 

 public String getAge() {

 return age;

 }

 

 public void setAge(String age) {

 this.age = age;

 }

 }

 

 // JTable 表模式類 （JTable對(duì)象 初始化的時(shí)候通過(guò) 這個(gè)Table獲取表格的行數(shù)、列數(shù)、列標(biāo)題、以及每個(gè)單元格存放的數(shù)據(jù) 具體使用原因放在開(kāi)頭的備注了）

 public class Table extends AbstractTableModel {

 List<Student> stu = new ArrayList<Student>();

 

 public Table(List s) {

 this.stu = s;

 

 }

 public List<Student> getStu() {

 return stu;

 }

 

 public void setStu(List<Student> stu) {

 this.stu = stu;

 }

 

 @Override

 // 獲取行數(shù)

 public int getRowCount() {

 return stu.size();

 }

 

 @Override

 // 獲取列數(shù)

 public int getColumnCount() {

 // TODO Auto-generated method stub

 return 3;

 }

 

 @Override

 public boolean isCellEditable(int rowIndex, int columnIndex) {

 return true;

 }

 

 @Override

 // 獲取列名字

 public String getColumnName(int col) {

 String res = "";

 switch (col) {

 case 0:

 res = "ID";

 break;

 case 1:

 res = "Name";

 break;

 case 2:

 res = "Age";

 break;

 default:

 break;

 }

 return res;

 }

 

 @Override

 // 獲取具體值

 public Object getValueAt(int rowIndex, int columnIndex) {

 // TODO Auto-generated method stub

 Object res = "";

 Student temp = stu.get(rowIndex);

 switch (columnIndex) {

 case 0:

 res = temp.getId();

 break;

 case 1:

 res = temp.getName();

 break;

 case 2:

 res = temp.getAge();

 break;

 default:

 break;

 }

 return res;

 }

 

 }

 

 // JDBCDAO類 配置連接數(shù)據(jù)的信息，鏈接釋放操作和基本增刪改查操作

 public class JDBCDaoImpl {

 String driver = "com.mysql.jdbc.Driver";

 String url = "jdbc:mysql://localhost:3306/test1?useUnicode=true&characterEncoding=utf-8&useSSL=false";

 String user = "root";

 String passwd = "123456";

 Connection conn = null;

 Statement stmt = null;

 ResultSet rs = null;

 

 // 數(shù)據(jù)庫(kù)連接開(kāi)始

 public Connection getConnection() {

 try {

 Class.forName("com.mysql.jdbc.Driver");

 conn = DriverManager.getConnection(url, user, passwd);

 stmt = conn.createStatement();

 } catch (Exception e) {

 e.printStackTrace();

 }

 return conn;

 }

 

 // 數(shù)據(jù)庫(kù)連接釋放

 public void closeConnection() {

 if (rs != null) {

 try {

  rs.close();

  stmt.close();

  conn.close();

 } catch (SQLException e) {

  // TODO Auto-generated catch block

  e.printStackTrace();

 }

 }

 

 if (rs == null) {

 try {

  stmt.close();

  conn.close();

 } catch (SQLException e) {

  e.printStackTrace();

 }

 }

 }

 

 // 查找操作

 public ResultSet search() {

 getConnection();

 try {

 String sql = "SELECT * FROM student";

 rs = stmt.executeQuery(sql);

 } catch (SQLException e) {

 e.printStackTrace();

 }

 return rs;

 }

 

 // 添加操作

 public void insert(Student sd) {

 // TODO Auto-generated method stub

 getConnection();

 try {

 String sql = "INSERT INTO student(id,name,age)" + "VALUES('" + sd.getId() + "','" + sd.getName() + "','"

  + sd.getAge() + "')";

 int count = stmt.executeUpdate(sql);

 } catch (SQLException e) {

 e.printStackTrace();

 }

 }

 

 // 刪除操作

 public void delete(Student sd) {

 // TODO Auto-generated method stub

 getConnection();

 try {

 String sql = "DELETE FROM student WHERE id = '" + sd.getId() + "'";

 int count = stmt.executeUpdate(sql);

 } catch (SQLException e) {

 e.printStackTrace();

 }

 }

 

 // 更新操作

 public void update(Student sd) {

 // TODO Auto-generated method stub

 getConnection();

 try {

 String sql = "UPDATE student SET name='" + sd.getName() + "',age= '" + sd.getAge() + "'WHERE id = '"

  + sd.getId() + "'";

 int count = stmt.executeUpdate(sql);

 } catch (SQLException e) {

 e.printStackTrace();

 }

 }

 

 }

 

 // main 方法

 public static void main(String[] args) throws BadLocationException, SQLException {

 new Test().setVisible(true);

 

 }

}