在Jtable中显示增加删除查询修改的数据库信息

本文介绍了一个课程管理系统中涉及的数据库操作,包括课程信息的增删改查及考试安排的管理。通过具体代码展示了如何使用Java进行Oracle数据库的交互。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

/**
  * 连接数据库函数
  */
 public static Connection fetchconnection()
 {
  try{
         Class.forName("oracle.jdbc.driver.OracleDriver");
      String url ="jdbc:oracle:thin:@192.168.119.108:1521:orclcn";
   String user = "zenggan";
   String pwd = "zeng";
      return DriverManager.getConnection(url, user, pwd);
  }
  catch(Exception e)
  {
   e.printStackTrace();
   return null;
  }
 }
 
 private void addsubinfoButtonActionPerformed(ActionEvent evt) throws Exception {
  /**
   * 插入语句
   */
  Statement statement = null;
  Connection connection =null;
  try{
   connection = fetchconnection();
   statement = connection.createStatement();
   
   String sql = "insert into subject values('"+this.sub_idTextField.getText()+"','"+this.sub_nameTextField.getText()+"','"+this.creditTextField.getText()+"')";
      statement.executeUpdate(sql);
      JOptionPane.showMessageDialog(this, "增加成功!!");
      this.sub_idTextField.setText("");
   this.sub_nameTextField.setText("");
   this.creditTextField.setText("");
     
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   statement.close();
   connection.close();
  }
 }
 
 private void modifysub_infoButtonActionPerformed(ActionEvent evt) throws SQLException {
  Statement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  
  try{
   connection = fetchconnection();
   statement = connection.createStatement();
   
   String sql = "update subject set sub_name='"+this.editsub_nameTextField.getText()+"' where sub_id='"+this.editsub_idTextField.getText()+"'";
   resultSet = statement.executeQuery(sql);
   sql = "update subject set credit='"+this.editcreditTextField.getText()+"' where sub_id='"+this.editsub_idTextField.getText()+"'";
   resultSet = statement.executeQuery(sql);
   JOptionPane.showMessageDialog(this,"修改成功!!");
   this.editsub_idTextField.setText("");
   this.editsub_nameTextField.setText("");
   this.editcreditTextField.setText("");
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   resultSet.close();
   statement.close();
   connection.close();
  }
 }
 
 public static String[] data = new String[3];//定义一数组存储字段
 private void subjectinfoButtonActionPerformed(ActionEvent evt) throws SQLException {
  Statement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  
  ((DefaultTableModel) this.subjectinfoTable.getModel()).getDataVector().clear();
  this.subjectinfoTable.updateUI();
  
  try{
   connection = fetchconnection();
   statement = connection.createStatement();
   
   String sql = "select * from subject";//查询subject表的所有信息
   resultSet = statement.executeQuery(sql);
     while(resultSet.next())  {
      data[0] = resultSet.getString("sub_id");   //将类型赋值给定义的数组
      data[1] = resultSet.getString("sub_name");
      data[2] = resultSet.getString("credit");
      ((DefaultTableModel) this.subjectinfoTable.getModel()).addRow(data);//table中显示
     }
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   resultSet.close();
   statement.close();
   connection.close();
  }
 }
 
 private void deletesub_infoButtonActionPerformed(ActionEvent evt) throws SQLException {
  Statement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  
  try{
   connection = fetchconnection();
   statement = connection.createStatement();
   
   String sql = "delete subject where sub_id='"+this.editsub_idTextField.getText()+"'";
   resultSet = statement.executeQuery(sql);
   JOptionPane.showMessageDialog(this,"删除成功!!");
   this.editsub_idTextField.setText("");
   this.editsub_nameTextField.setText("");
   this.editcreditTextField.setText("");
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   resultSet.close();
   statement.close();
   connection.close();
  }
 }
 
 private void addtestButtonActionPerformed(ActionEvent evt) throws SQLException {
  Statement statement = null;
  Connection connection =null;
  try{
   connection = fetchconnection();
   statement = connection.createStatement();
   
   String sql = "insert into test values('"+this.test_idTextField.getText()+"','"+
                                            this.class_idTextField.getText()+"','"+
                                            this.testsub_idTextField.getText()+"','"+
                                            this.teacher_idTextField.getText()+"','"+
                                            this.test_timeTextField.getText()+"','"+
                                            this.test_addressTextArea.getText()+"')";
      statement.executeUpdate(sql);
      JOptionPane.showMessageDialog(this, "增加成功!!");
      this.test_idTextField.setText("");
            this.class_idTextField.setText("");
            this.testsub_idTextField.setText("");
            this.teacher_idTextField.setText("");
            this.test_timeTextField.setText("");
            this.test_addressTextArea.setText("");
     
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   statement.close();
   connection.close();
  }
 }
 
 public static String[] dataone = new String[6];
 
 private void testinfoButtonActionPerformed(ActionEvent evt) throws SQLException {
  Statement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  
  ((DefaultTableModel) this.testinfoTable.getModel()).getDataVector().clear();
  this.testinfoTable.updateUI();
  try{
   connection = fetchconnection();
   statement = connection.createStatement();
   String sql = "select * from test";//查询test表的所有信息
   resultSet = statement.executeQuery(sql);
     while(resultSet.next())  {
      dataone[0] = resultSet.getString("test_id");   //将类型赋值给定义的数组
      dataone[1] = resultSet.getString("class_id");
      dataone[2] = resultSet.getString("sub_id");
      dataone[3] = resultSet.getString("teacher_id");
      dataone[4] = resultSet.getString("test_time");
      dataone[5] = resultSet.getString("test_adress");
      ((DefaultTableModel) this.testinfoTable.getModel()).addRow(dataone);//table中显示
     }
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   resultSet.close();
   statement.close();
   connection.close();
  }
 }
 
 private void edittestmodifyButtonActionPerformed(ActionEvent evt) throws SQLException {
  Statement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  
  try{
   connection = fetchconnection();
   statement = connection.createStatement();
   
   String sql = "update test set class_id='"+this.editclass_idTextField.getText()+"' where test_id='"+this.edittest_idTextField.getText()+"'";
   resultSet = statement.executeQuery(sql);
   sql = "update test set sub_id='"+this.edittestsub_idTextField.getText()+"' where test_id='"+this.edittest_idTextField.getText()+"'";
   resultSet = statement.executeQuery(sql);
   sql = "update test set teacher_id='"+this.edittestteacheridTextField.getText()+"' where test_id='"+this.edittest_idTextField.getText()+"'";
   resultSet = statement.executeQuery(sql);
   sql = "update test set test_time='"+this.edittesttimeTextField.getText()+"' where test_id='"+this.edittest_idTextField.getText()+"'";
   resultSet = statement.executeQuery(sql);
   sql = "update test set test_adress='"+this.edittestaddressTextArea.getText()+"' where test_id='"+this.edittest_idTextField.getText()+"'";
   resultSet = statement.executeQuery(sql);
   JOptionPane.showMessageDialog(this,"修改成功!!");
   this.edittest_idTextField.setText("");
   this.editclass_idTextField.setText("");
   this.edittestsub_idTextField.setText("");
   this.edittestteacheridTextField.setText("");
   this.edittesttimeTextField.setText("");
   this.edittestaddressTextArea.setText("");
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   resultSet.close();
   statement.close();
   connection.close();
  }
 }
 
 private void edittestdeleteButtonActionPerformed(ActionEvent evt) throws SQLException {
  Statement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  
  try{
   connection = fetchconnection();
   statement = connection.createStatement();
   
   String sql = "delete test where test_id='"+this.edittest_idTextField.getText()+"'";
   resultSet = statement.executeQuery(sql);
   JOptionPane.showMessageDialog(this,"删除成功!!");
   this.edittest_idTextField.setText("");
   this.editclass_idTextField.setText("");
   this.edittestsub_idTextField.setText("");
   this.edittestteacheridTextField.setText("");
   this.edittesttimeTextField.setText("");
   this.edittestaddressTextArea.setText("");
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   resultSet.close();
   statement.close();
   connection.close();
  }
 }
 
 private void tuichuButtonActionPerformed(ActionEvent evt) {
  System.exit(0);
 }
package BookTest; import java.awt.*; import java.awt.event.*; import java.util.AbstractQueue; import java.util.Vector; import javax.swing.*; import javax.swing.table.*; import javax.swing.tree.DefaultMutableTreeNode; import javax.swing.tree.DefaultTreeCellRenderer; import javax.swing.tree.DefaultTreeModel; import javax.swing.tree.TreeSelectionModel; import javax.swing.event.*; import javax.swing.table.TableColumnModel; //import DbHelp.OperatorJobs; import Dao.ArrayBook; public class Test extends JFrame { public JPanel jp=null; public String aa; //JTable jTable1 = new JTable(); public JTable jTable1=null; private JTree jTree1; DefaultTableModel mode; private JScrollPane scrollPane = null; DefaultMutableTreeNode node; JButton[] btn={new JButton("增加"),new JButton("删除"),new JButton("修改"),new JButton("查询"),new JButton("重置")}; public JTextField[] txt ={new JTextField(),new JTextField(),new JTextField(),new JTextField(),new JTextField(),new JTextField()}; public String[] str1={"1","summer","boy","20","",""}; public String[] str2={"2","wulei","girl","19","",""}; public String[] str3={"3","west","boy","20","",""}; public String[] str4={"4","fish","girl","18","",""}; public String[] str5={"5","youku","boy","21","",""}; public String[] str6={"6","aa","boy","21","",""}; public String[][] tempData1={str1,str2,str3,str4,str5,str6}; public String[] aa1={"1","summer","boy","20","123","123"}; public String[] aa2={"2","wulei","girl","19","123",""}; public String[] aa3={"3","west","boy","20","123",""}; public String[] aa4={"4","fish","girl","18","1",""}; public String[] aa5={"5","youku","boy","21","12",""}; public String[] aa6={"6","aa","boy","21","123",""}; public String[][] tempData4={aa1,aa2,aa3,aa4,aa5,aa6}; //设置表头数据 public String[] tempTitle={"ID","标题","内容","作者","时间","是否选中"}; //设置表格的数据集合 Vector v1=new Vector(); Vecto
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值