java学生管理系统-数据库小项目

package com.qxl; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.SQLException; import java.util.Collection; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.table.JTableHeader; import com.qxl.DAO.IStudentDao; import com.qxl.DAO.StudentDaoImpl; import com.qxl.bo.Student; import com.qxl.util.MyFrame; /** * 此窗口用来显示所有的使学生信息 */ public class Show extends JPanel{ private IStudentDao stuDao; JFrame frame; private JScrollPane scrollPane; private JTableHeader th; private JTable table; private JButton bt_show; private JButton bt_add; private JButton bt_delete; private JButton bt_modify; public Show(){ stuDao = StudentDaoImpl.getInstance(); initComponent(); frame = new MyFrame("Show"); frame.add(this); selectAll(); } private void initComponent(){ this.setLayout(null); int x_scroll = 10; int y_scroll = 10; int width = 560; int height = 240; scrollPane = new JScrollPane(); scrollPane.setBounds(x_scroll,y_scroll,width,height); this.add(scrollPane); int x_bt = 60; int y_bt = y_scroll+height+20; int width_bt = 120; bt_add = new JButton("增加"); bt_add.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { frame.dispose(); //当前窗口释放 new Add(); } }); bt_add.setBounds(x_bt,y_bt,60,30); this.add(bt_add); bt_delete = new JButton("删除"); bt_delete.setBounds(x_bt+width_bt*1,y_bt,60,30); bt_delete.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { int row = table.getSelectedRow(); //System.out.println(row); if(row==-1){ JOptionPane.showMessageDialog(null,"未选中任意一行","错误",JOptionPane.ERROR_MESSAGE); }else if(row>=0){ //获取第row+1行第1列的单元格的值 Integer id = (Integer)table.getValueAt(row,0); //YES-0 NO-1 CANCEl-2 String sname = (String)table.getValueAt(row,1); int n = JOptionPane.showConfirmDialog(null,"确定删除姓名为"+sname+"的记录"); //System.out.println(n); //System.out.println("id:"+id); if(n==0){ delete(id); } } } }); this.add(bt_delete); bt_modify = new JButton("修改"); bt_modify.setBounds(x_bt+width_bt*2,y_bt,60,30); bt_modify.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { int row = table.getSelectedRow(); //System.out.println(row); if(row==-1){ JOptionPane.showMessageDialog(null,"未选中任意一行","错误",JOptionPane.ERROR_MESSAGE); }else if(row>=0){ //获取第row+1行第1列的单元格的值 Integer id = (Integer)table.getValueAt(row,0); //YES-0 NO-1 CANCEl-2 String sname = (String)table.getValueAt(row,1); String gender = (String)table.getValueAt(row,2); String address = (String)table.getValueAt(row,3); Student student = new Student(id, sname, gender, address); frame.dispose(); //当前窗口释放 new Update(student); } } }); this.add(bt_modify); bt_show = new JButton("显示"); bt_show.setBounds(x_bt+width_bt*3,y_bt,60,30); bt_show.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { //System.out.println("show_button"); selectAll(); } }); this.add(bt_show); } /** * 删除指定的记录 */ private void delete(int id){ try { boolean flag = stuDao.delete(id); if(flag){ JOptionPane.showMessageDialog(null,"成功删除！","提示",JOptionPane.INFORMATION_MESSAGE); selectAll(); }else{ JOptionPane.showMessageDialog(null,"删除出错！","错误",JOptionPane.ERROR_MESSAGE); } } catch (Exception e) { e.printStackTrace(); } } /** * 查询数据库所有数据 */ private void selectAll(){ try { Collection<Student> c = stuDao.showAll(); String[] title = new String[]{"id","姓名","性别","住址"}; Object[][] info = new Object[c.size()][4]; int count = 0; for(Student s : c){ info[count][0] = s.getId(); info[count][1] = s.getSname(); info[count][2] = s.getGender(); info[count++][3] = s.getAddress(); } this.table = new JTable(info,title); //显示表头 this.th = this.table.getTableHeader(); // 将JTable加入到带滚动条的面板中 this.scrollPane.getViewport().add(table); } catch(ClassNotFoundException cnfe){ JOptionPane.showMessageDialog(null,"数据源错误","错误",JOptionPane.ERROR_MESSAGE); } catch(SQLException sqle){ JOptionPane.showMessageDialog(null,"数据库错误","错误",JOptionPane.ERROR_MESSAGE); } catch(Exception e){ e.printStackTrace(); } } public static void main(String[] args) { Show show = new Show(); } }