連接數(shù)據(jù)庫模塊

1、.連接數(shù)據(jù)庫模塊。主要是連接數(shù)據(jù)庫相關的端口和用戶名、密碼以及Jdbc連接 本地數(shù)據(jù)庫等信息，其主要實現(xiàn)代碼如下：public class DatabaseBean public static Connection getConnection() Connection conn = null;String driver = oracle.jdbc.driver.OracleDriver”;String url = jdbc:oracle:thin:localhost:1521:xe;String user = hr;String password = oracle;try Class.forN

2、ame(driver);conn = DriverManager.getConnection(url, user, password); catch (ClassNotFoundException | SQLException ex) Logger.getLogger(DatabaseBean.class.getName().log(Level.SEVERE, null, ex);return conn;public static void close(ResultSet rs, Statement st, Connection conn) try if (rs != null) rs.clo

3、se();if(st != null) st.close();if(conn != null) conn.close(); catch (SQLException ex) Logger.getLogger(DatabaseBean.class.getName().log(Level.SEVERE, null, ex);2 .調用存儲過程（此處只舉例學生表存儲過程）調用學生表的查詢所有信息、根據(jù)學號查詢學生表的所有信息返 回游標顯示出來，以及插入、更新等存儲過程，具體實現(xiàn)代碼如下： public class StudentDaoImpl implements IStudentDao public

4、 static ResultSet executQuery(String sqlString) throw new UnsupportedOperationException(Not supported yet.); /To change body of generated methods, choose Tools | Templates.Overridepublic List getAllStudent() List students = new ArrayList();Connection conn = null;CallableStatement cs = null;ResultSet

5、 rs = null;try conn = DatabaseBean.getConnection();cs = conn.prepareCall(call students.select_all(?);cs.registerOutParameter(1, OracleTypes.CURSOR);cs.executeQuery();rs = (ResultSet) cs.getObject(1);while (rs.next() Student stu = new Student();stu.setSno(rs.getString(sno);stu.setSname(rs.getString(s

6、name);stu.setSsex(rs.getString(ssex);stu.setSage(rs.getInt(sage);stu.setSdept(rs.getString(sdept);students.add(stu); catch (SQLException ex) Logger.getLogger(StudentDaoImpl.class.getName().log(Level.SEVERE, null, ex); finally DatabaseBean.close(rs, cs, conn);return students;Overridepublic Student ge

7、tStudent(String sno) Student stu = new Student();Connection conn = null;CallableStatement cs = null;ResultSet rs = null;try conn = DatabaseBean.getConnection();cs = conn.prepareCall(call students.select_sno(?,?)”);cs.setString(1, sno);cs.registerOutParameter(2, OracleTypes.CURSOR);cs.executeQuery();

8、rs = (ResultSet) cs.getObject(2);if (rs.next() stu.setSno(rs.getString(sno);stu.setSname(rs.getString(sname);stu.setSsex(rs.getString(ssex);stu.setSage(rs.getInt(sage);stu.setSdept(rs.getString(sdept); catch (SQLException ex) Logger.getLogger(StudentDaoImpl.class.getName().log(Level.SEVERE, null, ex

9、); finally DatabaseBean.close(rs, cs, conn);return stu;Overridepublic boolean insertStudent(Student stu) Connection conn = null;CallableStatement cs = null;try conn = DatabaseBean.getConnection();cs = conn.prepareCall(call students.insert_msg(?,?,?,?,?)”);cs.setString(1, stu.getSno();cs.setString(2,

10、 stu.getSname();cs.setString(3, stu.getSsex();cs.setInt(4, stu.getSage();cs.setString(5, stu.getSdept();cs.executeUpdate();return true; catch (SQLException ex) Logger.getLogger(StudentDaoImpl.class.getName().log(Level.SEVERE, null, ex); return false; finally DatabaseBean.close(null, cs, conn);Overri

11、depublic boolean updateStudent(Student stu) Connection conn = null;CallableStatement cs = null;try conn = DatabaseBean.getConnection();cs = conn.prepareCall(call students.update_msg(?,?,?,?,?)”);cs.setString(1, stu.getSno();cs.setString(2, stu.getSname();cs.setString(3, stu.getSsex();cs.setInt(4, st

12、u.getSage();cs.setString(5, stu.getSdept();cs.executeUpdate();return true; catch (SQLException ex) Logger.getLogger(StudentDaoImpl.class.getName().log(Level.SEVERE, null, ex); return false; finally DatabaseBean.close(null, cs, conn);Overridepublic boolean deleteStudent(String sno) Connection conn =

13、null;CallableStatement cs = null;try conn = DatabaseBean.getConnection();cs = conn.prepareCall(call students.delete_sno(?);cs.setString(1, sno);cs.executeUpdate();return true; catch (SQLException ex) Logger.getLogger(StudentDaoImpl.class.getName().log(Level.SEVERE, null, ex); return false; finally D

14、atabaseBean.close(null, cs, conn);3.表模型模塊：public class StudentTableModel extends AbstractTableModelList rowsData;List columnsData;public StudentTableModel() rowsData = DaoFactory.getStudentDao().getAllStudent(); setColumnNames();public StudentTableModel(String sno) rowsData = new ArrayList();rowsDat

15、a.add(DaoFactory.getStudentDao().getStudent(sno); setColumnNames();public int getRowCount() return rowsData.size();public int getColumnCount() return columnsData.size();public Object getValueAt(int rowIndex, int columnIndex) switch (columnIndex) case 0:return rowsData.get(rowIndex).getSno();case 1:r

16、eturn rowsData.get(rowIndex).getSname();case 2:return rowsData.get(rowIndex).getSsex();case 3:return rowsData.get(rowIndex).getSage();case 4:return rowsData.get(rowIndex).getSdept();default:return s;private void setColumnNames（） columnsData = new ArrayList（）;columnsData.add（學號）;columnsData.add（姓名）;c

17、olumnsData.add（性別）;columnsData.add（年齡）;columnsData.add（院系）;public String getColumnName（int column） return columnsData.get（column）;4.主界面模塊：主界面采用Form窗體，來實現(xiàn)操作主界面窗體，里面包含有三個按鈕，分 別為學生信息管理、課程信息管理、成績信息管理。用戶可通過點擊這三個按鈕 分別進入相應的功能模塊。其實現(xiàn)代碼主要有：private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) j

18、ava.awt.EventQueue.invokeLater(new Runnable() public void run() new studentFrame().setVisible(true););private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) java.awt.EventQueue.invokeLater(new Runnable() public void run() new courseFrame().setVisible(true);)；private void jButton3Action

19、Performed(java.awt.event.ActionEvent evt) ( java.awt.EventQueue.invokeLater(new Runnable() (public void run() (new gradeFrame().setVisible(true);)；5.學生信息管理模塊:(1)此模塊實現(xiàn)學生信息管理，主要實現(xiàn)學生信息的添加、查詢、修改和刪除，運行截圖如下:話輸入要查句的學號：學話輸入要查句的學號：學W眺名T |查詢浦加信息酬信自刪除信,性刖年檔學站扁9512101 李勇男19計算機條951210295121039512101 李勇男19計算機條951

20、2102951210395211019521102952110395311019531102/- Xfi工202022?1201819計翼機兼 計賓機崩1= m共 故學弩 數(shù)學窘學號:9512101年都:19I算機蚤:其主要實現(xiàn)代碼有：private void queryButtonActionPerformed(java.awt.event.ActionEvent evt) (String sno = snoQueryText.getText().trim();JOptionPane.showMessageDialog(this, sno);if (”.equals(sno) (sm = n

21、ew StudentTableModel(); else (sm = new StudentTableModel(sno);studentTable.setModel(sm);snoQueryText.setText();private void addStudentButtonActionPerformed(java.awt.event.ActionEvent evt) ( AddStudentDialog dialog = new AddStudentDialog(this, true);dialog.setLocationRelativeTo(this);dialog.setVisibl

22、e(true);if(AddStudentDialog.RET_OK = dialog.getReturnStatus() (sm = new StudentTableModel();studentTable.setModel(sm);private void studentTableMouseClicked(java.awt.event.MouseEvent evt) (int rowNum = studentTable.getSelectedRow();if (rowNum = 0) (String sno = (String) studentTable.getVdueAt(rowNum,

23、 0);if (snoText.getText().trim().equals(sno) (return;Student stu = DaoFactory.getStudentDao().getStudent(sno);snoText.setText(stu.getSno();snameText.setText(stu.getSname();if (男”.equals(stu.getSsex() (maleRadioButton.setSelected(true); else (femaleRadioButton.setSelected(true);sageText.setText(Strin

24、g.valueOf(stu.getSage();sdeptText.setText(stu.getSdept();private void deleteStudentButtonActionPerformed(java.awt.event.ActionEvent evt) (int rowNum = studentTable.getSelectedRow();if (rowNum = 0) (String sno = snoText.getText().trim();int choise = JOptionPane.showConfirmDialog(this,是否要刪除學生的信息 內容”，”

25、提示”，JOptionPane.YES_NO_OPTION);if(choise = JOptionPane.YES_OPTION) (if (!DaoFactory.getStudentDao().deleteStudent(sno) (JOptionPane.showMessageDialog(this,”學生信息刪除失敗，請與系統(tǒng)管理員聯(lián)系！”）；sm = new StudentTableModel();studentTable.setModel(sm); else (JOptionPane.showMessageDialog(this,”請選擇要刪除的學生信息！”)；private v

26、oid updateStudentButtonActionPerformed(java.awt.event.ActionEvent evt) (String sno = snoText.getText().trim();String sname = snameText.getText().trim();String ssex;if (maleRadioButton.isSelected() (ssex = maleRadioButton.getText(); else (ssex = femaleRadioButton.getText();String sage = sageText.getT

27、ext().trim();String sdept = sdeptText.getText().trim();if(!validateData(sno, sname, ssex, sage, sdept) ( return;if (!DaoFactory.getStudentDao().findStudent(sno) (JOptionPane.showMessageDialog(this,”指定學號的學生記錄不存在，請重 新輸入！)；return;Student stu = new Student(sno, sname, ssex, Integer.parseInt(sage), sdept

28、);如果數(shù)據(jù)驗證正確，則插入學生記錄內容if (!DaoFactory.getStudentDao().updateStudent(stu) (JOptionPane.showMessageDialog(this,”學生記錄更新失敗，請檢查輸入的 數(shù)據(jù)內容！)；sm = new StudentTableModel();studentTable.setModel(sm);private void queryButtonMouseClicked(java.awt.event.MouseEvent evt) (/ TODO add your handling code here:String sno

29、 = snoQueryText.getText().trim();if (”.equals(sno) (sm = new StudentTableModel();sdept) (字！”)sdept) (字！”)；間！)；sm = new StudentTableModel(sno);studentTable.setModel(sm);snoQueryText.setText();private boolean validateData(String sno, String sname, String ssex, String sage, Stringif (”.equals(sno) | !Tools.isNumeric(sno) | sno.length() != 7) (JOptionPane.showMessageDialog(this,”請輸入正確的學號，并且學號為數(shù)snoText.requestFocus(); return fa