刚学j2se时做的一个学生管理系统
自己刚开始学Java的时候做的一个学生管理系统,虽然现在看来比较菜,但对于刚入JAVA殿堂的同学来说,应该还是有帮助的,现在拿来和大家分享,希望对于初学者有所帮助.1.StudentInfo类import java.awt.BorderLayout;import java.awt.Container;import java.awt.FlowLayout;import java.awt.Font;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JPasswordField;import javax.swing.JTextField;/* *操作员登录窗口 */public class StudentInfo extends JFrame{private static final long serialVersionUID = 1L;Connection conn = null;Statement stmt = null;ResultSet rs = null;JTextField text1 = new JTextField(16);JTextField text2 = new JPasswordField(16);public StudentInfo(){setTitle("学生信息管理系统");setSize(250, 180);setLocation(300, 400);Container cp = getContentPane(); JPanel p1 = new JPanel(); JPanel p2 = new JPanel(); JPanel p3 = new JPanel(); JLabel label = new JLabel("登录"); label.setFont(new Font("Serif", Font.BOLD, 20)); JButton button = new JButton("确定"); JButton button1 = new JButton("取消"); //button(确定)的监听器 button.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){try{Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/studentinfo?useUnicode=true&characterEncoding=gb2312","root","root");stmt = conn.createStatement();String str1 = text1.getText();String str2 = text2.getText();rs = stmt.executeQuery("select * from user where usename = '"+str1+"' and password = '"+str2+"'");if(rs.next()){new IndexFrame();dispose();}else{JOptionPane.showMessageDialog(null, "登录不正确!");}} catch (ClassNotFoundException cnf){ cnf.printStackTrace();} catch (SQLException sql){sql.printStackTrace();} finally{try{rs.close();stmt.close();conn.close();} catch(SQLException sql){sql.printStackTrace();}}} });// button(取消)的监听器 button1.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){System.exit(0);} }); p1.setLayout(new FlowLayout()); p2.setLayout(new FlowLayout()); p1.add(label); p2.add(button); p2.add(button1); cp.add(p1,BorderLayout.NORTH); cp.add(p2,BorderLayout.SOUTH); JLabel lable1 = new JLabel("用户名:");JLabel lable2 = new JLabel("密 码:");p3.add(lable1);p3.add(text1);p3.add(lable2);p3.add(text2); cp.add(p3); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);setResizable(false);setVisible(true);}public static void main(String[] args){ new StudentInfo();}}2.IndexFrame类import java.awt.BorderLayout;import java.awt.Container;import java.awt.Dimension;import java.awt.FlowLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.MouseAdapter;import java.awt.event.MouseEvent;import java.awt.event.WindowAdapter;import java.awt.event.WindowEvent;import java.io.BufferedReader;import java.io.FileReader;import java.io.IOException;import java.util.Vector;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JMenu;import javax.swing.JMenuBar;import javax.swing.JMenuItem;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JPopupMenu;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.table.DefaultTableModel;/* * 程序主窗口 */public class IndexFrame extends JFrame{private static final long serialVersionUID = 1L;private ConnServer cs = new ConnServer();private Container cp = getContentPane();private JTable table = new JTable();private DefaultTableModel defaultModel;Vector<String> name = new Vector<String>();public static void main(String[] args){new IndexFrame();}public IndexFrame(){setTitle("学生信息管理");setSize(600,500);setLocation(200, 100);setLayout(new BorderLayout());JButton b1 = new JButton("添加");b1.addActionListener(new AdddataAction());JButton b2 = new JButton("删除");b2.addActionListener(new DeleteAction());JButton b3 = new JButton("修改");b3.addActionListener( new UpdateAction());JButton b4 = new JButton("查询");b4.addActionListener( new QueryAction());JButton b5 = new JButton("导出");b5.addActionListener(new OutputAction());JButton b6 = new JButton("导入");b6.addActionListener(new InputAction());JPanel p1 = new JPanel();p1.setLayout(new FlowLayout());p1.add(b1);p1.add(b2);p1.add(b3);p1.add(b4);p1.add(b5);p1.add(b6);cp.add(p1,BorderLayout.SOUTH);JLabel label = new JLabel("学员管理");cp.add(label,BorderLayout.NORTH);name.addElement("学号");name.addElement("姓名");name.addElement("固定电话");name.addElement("手机");name.addElement( "家庭住址");name.addElement("证件号码"); defaultModel = new DefaultTableModel(cs.showTable(), name){private static final long serialVersionUID = 1L;//设置Jtable单元格不可修改public boolean isCellEditable(int row,int column){ return false; } };table = new JTable(defaultModel);table.setPreferredScrollableViewportSize(new Dimension(400, 80));JScrollPane s = new JScrollPane(table);cp.add(s,BorderLayout.CENTER);JMenuBar menubar = new JMenuBar();JMenu menu = new JMenu("学员管理");JMenu menu1 = new JMenu("信息查询");JMenu menu2 = new JMenu("数据备份");JMenuItem addData = new JMenuItem("添加");addData.addActionListener(new AdddataAction());JMenuItem delData = new JMenuItem("删除");delData.addActionListener(new DeleteAction());JMenuItem upData = new JMenuItem("修改");upData.addActionListener( new UpdateAction());JMenuItem queryData = new JMenuItem("查询");queryData.addActionListener(new QueryAction());JMenuItem input = new JMenuItem("导入");input.addActionListener(new InputAction());JMenuItem output = new JMenuItem("导出");output.addActionListener(new OutputAction());menu.add(addData);menu.add(delData);menu.add(upData);menu1.add(queryData);menu2.add(input);menu2.add(output);menubar.add(menu);menubar.add(menu1);menubar.add(menu2);final JPopupMenu popup = new JPopupMenu();JMenuItem addData1 = new JMenuItem("添加");addData1.addActionListener(new AdddataAction());JMenuItem delData1 = new JMenuItem("删除");delData1.addActionListener(new DeleteAction());JMenuItem upData1 = new JMenuItem("修改");upData1.addActionListener( new UpdateAction());JMenuItem queryData1 = new JMenuItem("查询");queryData1.addActionListener(new QueryAction());JMenuItem input1 = new JMenuItem("导入");JMenuItem output1 = new JMenuItem("导出");output1.addActionListener(new OutputAction());popup.add(addData1);popup.add(delData1);popup.add(upData1);popup.add(queryData1);popup.add(input1);popup.add(output1);//设置table鼠标右键单击菜单事件table.addMouseListener(new MouseAdapter(){public void mousePressed(MouseEvent e){if(e.isPopupTrigger())popup.show(e.getComponent(),e.getX(),e.getY());}public void mouseReleased(MouseEvent e){if(e.isPopupTrigger())popup.show(e.getComponent(), e.getX(), e.getY());}});cp.add(menubar,BorderLayout.NORTH); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); addWindowListener (new WindowAdapter(){//设置窗口关闭事件public void windowClosing(WindowEvent e){cs.shutDown();} }); table.addMouseListener(new UpdateAction()); setResizable(false);setVisible(true);}//添加学员信息监听器class AdddataAction implements ActionListener{public void actionPerformed(ActionEvent e){final AppendFrame append = new AppendFrame();append.b1.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){String str =append.text1.getText();if(!str.matches("\\d++")){JOptionPane.showMessageDialog(null, "学号只能为数字,请重新输入!");}else{int id = Integer.parseInt(str);String name = append.text2.getText();String phone = append.text3.getText();if(!phone.matches("\\d{8}"))JOptionPane.showMessageDialog(null, "电话号码只能为8位数字,请重新输入!");else{String mobile = append.text4.getText();if(!mobile.matches("\\d{11}"))JOptionPane.showMessageDialog(null, "手机号码只能为11位数字,请重新输入!");else{String address = append.text5.getText();String cert = append.text6.getText();if(!cert.matches("\\d{18}"))JOptionPane.showMessageDialog(null, "身份证号码为18位数字,请重新输入!");else{cs.addData(id, name, phone, mobile, address, cert);append.text1.setText("");append.text2.setText("");append.text3.setText("");append.text4.setText("");append.text5.setText("");append.text6.setText("");JOptionPane.showMessageDialog(null, "添加信息成功!");//append.dispose();refresh();}}}}}});}}//删除信息监听器class DeleteAction implements ActionListener{public void actionPerformed(ActionEvent e){int row = table.getSelectedRow();if(row == -1){JOptionPane.showMessageDialog(null, "请选择你要删除的数据!");} else{int id = (Integer)table.getValueAt(row, 0);cs.deleteData(id); refresh();}}}//修改信息监听器class UpdateAction extends MouseAdapter implements ActionListener{public void actionDisplay() //内部类updateAction的方法{int row = table.getSelectedRow();if(row==-1){JOptionPane.showMessageDialog(null, "请选择你要修改的数据!");}else{final AppendFrame af = new AppendFrame();int id = (Integer)table.getValueAt(row, 0);String str = Integer.toString(id);String name = table.getValueAt(row, 1).toString();String phone = table.getValueAt(row, 2).toString();String mobile = table.getValueAt(row, 3).toString();String address = table.getValueAt(row, 4).toString();String cert = table.getValueAt(row, 5).toString();af.text1.setText(str);af.text1.setEditable(false);af.text2.setText(name);af.text3.setText(phone);af.text4.setText(mobile);af.text5.setText(address);af.text6.setText(cert);//AppendFrame中(button)b1的监听器af.b1.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){String s = af.text1.getText();int id = Integer.parseInt(s);String name = af.text2.getText();String phone = af.text3.getText();if(!phone.matches("\\d{8}"))JOptionPane.showMessageDialog(null, "电话号码只能为8位数字,请重新输入!");else{String mobile = af.text4.getText();if(!mobile.matches("\\d{11}"))JOptionPane.showMessageDialog(null, "手机号码只能为11位数字,请重新输入!");{String address = af.text5.getText();String cert = af.text6.getText();if(!cert.matches("\\d{18}"))JOptionPane.showMessageDialog(null, "身份证号码为18位数字,请重新输入!");else{cs.upData(id,name, phone, mobile, address, cert);JOptionPane.showMessageDialog(null, "修改数据成功!");af.dispose();refresh();}}}}}); }}//鼠标双击事件public void mouseClicked(MouseEvent e){if(e.getClickCount()==2){actionDisplay();}}//修改信息监听器public void actionPerformed(ActionEvent e){actionDisplay();}}//查询信息监听器class QueryAction implements ActionListener{public void actionPerformed(ActionEvent e){final QueryFrame query = new QueryFrame();query.button1.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){int row = query.table.getSelectedRow();if(row==-1){JOptionPane.showMessageDialog(null, "请选择你要修改的数据!");}else{final AppendFrame af = new AppendFrame();int id = (Integer) query.table.getValueAt(row, 0);String str = Integer.toString(id);String name = query.table.getValueAt(row, 1).toString();String phone = query.table.getValueAt(row, 2).toString();String mobile = query.table.getValueAt(row, 3).toString();String address = query.table.getValueAt(row, 4).toString();String cert = query.table.getValueAt(row, 5).toString();af.text1.setText(str);af.text1.setEditable(false);af.text2.setText(name);af.text3.setText(phone);af.text4.setText(mobile);af.text5.setText(address);af.text6.setText(cert);//AppendFrame中b1(button)的监听器af.b1.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){String s = af.text1.getText();int id = Integer.parseInt(s);String name = af.text2.getText();String phone = af.text3.getText();String mobile = af.text4.getText();String address = af.text5.getText();String cert = af.text6.getText();cs.upData(id,name, phone, mobile, address, cert);JOptionPane.showMessageDialog(null, "修改数据成功!");af.dispose();refresh();query.refresh(id);}}); }}});//QueryFrame中button2(删除)的监听器 query.button2.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){int row = query.table.getSelectedRow();if(row == -1){JOptionPane.showMessageDialog(null, "请选择你要删除的数据!");} else{int id = (Integer)query.table.getValueAt(row, 0);cs.deleteData(id);int rowcount = query.defaultModel.getRowCount() - 1;if (rowcount>= 0) {query.defaultModel.removeRow(row);query.defaultModel.setRowCount(rowcount);}query.refresh(id); refresh();}} });}}//导出数据库信息监听器class OutputAction implements ActionListener{public void actionPerformed(ActionEvent e){cs.Output();JOptionPane.showMessageDialog(null, "导出数据成功!");}} //导入数据库信息监听器class InputAction implements ActionListener{public void actionPerformed(ActionEvent e){try{BufferedReader br = new BufferedReader( new FileReader("f:/data/file.txt"));int result = JOptionPane.showConfirmDialog(table,"是否清空数据库?","警告",JOptionPane.YES_NO_OPTION); if(result == JOptionPane.YES_OPTION) cs.deleteData(); String ss; while((ss = br.readLine())!= null){String [] str = ss.split(","); int id = Integer.parseInt(str[0]); String name = str[1].trim(); String phone = str[2].trim(); String mobile = str[3].trim(); String address = str[4].trim(); String cert = str[5].trim(); cs.addData(id, name, phone, mobile, address, cert); } refresh();} catch(IOException ioe){ioe.printStackTrace();}}}//JTable的刷新public void refresh(){table.setModel(new DefaultTableModel(cs.showTable(),name){private static final long serialVersionUID = 1L;public boolean isCellEditable(int row,int column){ return false; }});table.updateUI();}} 3.AppendFrame类import java.awt.BorderLayout;import java.awt.Container;import java.awt.FlowLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JTextField;/* * 添加、修改信息窗口 */public class AppendFrame extends JFrame{private static final long serialVersionUID = 1L;JTextField text1 = new JTextField(28);JTextField text2 = new JTextField(28);JTextField text3 = new JTextField(28);JTextField text4 = new JTextField(28);JTextField text5 = new JTextField(28);JTextField text6 = new JTextField(28);JButton b1 = new JButton("确定");public AppendFrame(){setTitle("编辑学员信息");setLocation(300, 250);setSize(400, 300);setLayout(new BorderLayout());Container cp = getContentPane();JButton b2 = new JButton("取消");b2.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){dispose();}});JPanel p1 = new JPanel();p1.setLayout(new FlowLayout());p1.add(b1);p1.add(b2);cp.add(p1,BorderLayout.SOUTH);JLabel label = new JLabel("基本信息");cp.add(label,BorderLayout.NORTH);JPanel p2 = new JPanel();p2.setLayout(new FlowLayout());JLabel label1 = new JLabel("学 号:");JLabel label2 = new JLabel("姓 名:");JLabel label3 = new JLabel("固定电话:");JLabel label4 = new JLabel("手 机:");JLabel label5 = new JLabel("家庭住址:");JLabel label6 = new JLabel("证件号码:");p2.add(label1);p2.add(text1);p2.add(label2);p2.add(text2);p2.add(label3);p2.add(text3);p2.add(label4);p2.add(text4);p2.add(label5);p2.add(text5);p2.add(label6);p2.add(text6);cp.add(p2,BorderLayout.CENTER);setResizable(false);setVisible(true);}//重写dispose()方法public void dispose(){super.dispose();}}4.QueryFrame类import java.awt.BorderLayout;import java.awt.Container;import java.awt.Dimension;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.WindowAdapter;import java.awt.event.WindowEvent;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Vector;import javax.swing.ButtonGroup;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JRadioButton;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.JTextField;import javax.swing.table.DefaultTableModel;/* * 查询数据信息窗口 */public class QueryFrame extends JFrame{private static final long serialVersionUID = 1L;ConnServer cs = new ConnServer();Vector<String> name = new Vector<String>();Vector v = new Vector(); JTable table = new JTable();DefaultTableModel defaultModel;Container cp = getContentPane();JButton button1 = new JButton("修改");JButton button2 = new JButton("删除");JRadioButton rb1 = new JRadioButton("学号",false);JRadioButton rb2 = new JRadioButton("姓名",false);ButtonGroup group = new ButtonGroup();JTextField text = new JTextField(12);public QueryFrame(){setTitle("学生信息查询");setBounds(200, 200, 500, 400);JPanel p1 = new JPanel();JPanel p2 = new JPanel();JButton button = new JButton("查询");group.add(rb1);group.add(rb2);p1.add(rb1);p1.add(rb2);p1.add(text);p1.add(button);p2.add(button1);p2.add(button2);cp.add(p1,BorderLayout.NORTH);cp.add(p2,BorderLayout.SOUTH);name.addElement("学号");name.addElement("姓名");name.addElement("固定电话");name.addElement("手机");name.addElement( "家庭住址");name.addElement("证件号码");//主窗口监听器addWindowListener(new WindowAdapter(){public void windowClosed(WindowEvent e){dispose();}}); defaultModel = new DefaultTableModel(v, name){private static final long serialVersionUID = 1L;//设置JTable 单元格不可编辑public boolean isCellEditable(int row,int column){ return false; } };table = new JTable(defaultModel);table.setPreferredScrollableViewportSize(new Dimension(400, 80));JScrollPane s = new JScrollPane(table);cp.add(s,BorderLayout.CENTER);//添加button监听器button.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){if(rb1.isSelected()){try{String s = text.getText();if(!s.matches("\\d++"))JOptionPane.showMessageDialog(null, "学号只能是数字,请重新输入查询!");else{int id = Integer.parseInt(s);int i = 0;Statement stmt = cs.conn.createStatement();String ss = "select * from student where id ="+id+"";ResultSet rs = stmt.executeQuery(ss);while(rs.next()){i = rs.getInt("id");}if(!(i==id))JOptionPane.showMessageDialog(null, "无此学生信息!");else{v= cs.showTable(id);refresh(id);}}}catch (SQLException sql){sql.printStackTrace();}}else{if(rb2.isSelected()){String name = text.getText();v = cs.showTable(name);refresh(name);}else{JOptionPane.showMessageDialog(null, "请选择查询条件!");}}}}); setVisible(true);}//刷新JTable方法public void refresh(int id){table.setModel(new DefaultTableModel(cs.showTable(id),name){private static final long serialVersionUID = 1L;public boolean isCellEditable(int row,int column){ return false; }});table.updateUI();}//重载refresh()方法public void refresh(String cname){table.setModel(new DefaultTableModel(cs.showTable(cname),name){private static final long serialVersionUID = 1L;public boolean isCellEditable(int row,int column){ return false; }});table.updateUI();}//重写dispose(),隐藏窗口public void dispose(){super.dispose();}}5.ConnServer数据库操作类import java.io.BufferedWriter;import java.io.FileWriter;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Vector;import javax.swing.JOptionPane;/* * 数据库连接及相关操作 */public class ConnServer{ Connection conn = null; Statement stmt = null; ResultSet rs = null;public ConnServer(){//数据库的连接try{Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/studentinfo?useUnicode=true&characterEncoding=gb2312","root","root");} catch (ClassNotFoundException e){System.err.println("装载 JDBC 驱动程序失败!");e.printStackTrace();} catch (SQLException e){System.out.println("无法连接数据库!");e.printStackTrace();}}//在JTable中显示数据库中数据的方法 public Vector showTable(){Vector<Object> data = new Vector<Object>();try{Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("select * from student");while(rs.next()){Vector<Object> rowData = new Vector<Object>();rowData.addElement(rs.getInt("id"));rowData.addElement(rs.getString("name"));rowData.addElement(rs.getString("phone"));rowData.addElement(rs.getString("mobile"));rowData.addElement(rs.getString("address"));rowData.addElement(rs.getString("cert"));data.addElement(rowData);}} catch(SQLException e){e.printStackTrace();} return data;}//重载 showTable() 方法public Vector showTable(int id){Vector<Object> data = new Vector<Object>();try{Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("select * from student where id ="+id+"");while(rs.next()){Vector<Object> rowData = new Vector<Object>();rowData.addElement(rs.getInt("id"));rowData.addElement(rs.getString("name"));rowData.addElement(rs.getString("phone"));rowData.addElement(rs.getString("mobile"));rowData.addElement(rs.getString("address"));rowData.addElement(rs.getString("cert"));data.addElement(rowData);}} catch(SQLException e){e.printStackTrace();} return data;} //重载 showTable() 方法public Vector showTable(String name){Vector<Object> data = new Vector<Object>();try{Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("select * from student where name like'%"+name+"%'");while(rs.next()){Vector<Object> rowData = new Vector<Object>();rowData.addElement(rs.getInt("id"));rowData.addElement(rs.getString("name"));rowData.addElement(rs.getString("phone"));rowData.addElement(rs.getString("mobile"));rowData.addElement(rs.getString("address"));rowData.addElement(rs.getString("cert"));data.addElement(rowData);}} catch(SQLException e){e.printStackTrace();} return data;}//删除数据库中的数据public void deleteData() {try{stmt = conn.createStatement();stmt.execute("delete from student");//JOptionPane.showMessageDialog(null, "清空数据成功!");} catch(SQLException e){e.printStackTrace();}}//重载deleteData()方法public void deleteData(int id) {try{stmt = conn.createStatement();stmt.execute("delete from student where id ="+id);JOptionPane.showMessageDialog(null, "删除数据成功!");} catch(SQLException e){e.printStackTrace();}}// 在数据库中添加数据的方法public void addData(int id,String name,String phone,String mobile,String address,String cert){int i = 0;try{stmt = conn.createStatement();String ss = "select * from student where id ="+id+"";rs = stmt.executeQuery(ss);while(rs.next()){ i = rs.getInt("id");}if(i==id){JOptionPane.showMessageDialog(null, "你输入的学号重复,请重新输入!");}else{String str="insert into student values ('"+id+"','"+name+"','"+phone+"','"+mobile+"','"+address+"','"+cert+"')";stmt.execute(str);//JOptionPane.showMessageDialog(null, "添加信息成功!");}} catch (SQLException e){e.printStackTrace();}}//修改数据库中数据的方法public void upData(int id,String name,String phone,String mobile,String address,String cert){try{stmt = conn.createStatement();String str = "update student SET name = '"+name+"',phone = '"+phone+"',mobile = '"+mobile+"',address = '"+address+"',cert = '"+cert+"'where id="+id+"";stmt.execute(str);} catch(SQLException e){e.printStackTrace();}}//导出数据的方法public void Output(){try{BufferedWriter bw = new BufferedWriter(new FileWriter("f:/data/file.txt")); Vector data = showTable(); for(int i=0;i<data.size();i++) { Vector v = (Vector)data.get(i);String id = Integer.toString((Integer) v.get(0));String name = (String)v.get(1);String phone = (String)v.get(2);String mobile = (String)v.get(3);String address = (String)v.get(4);String cert = (String)v.get(5);bw.write(id.trim()+","+"\t"+name.trim()+","+"\t"+phone.trim()+","+"\t"+mobile.trim()+","+"\t"+address.trim()+","+"\t"+cert.trim());bw.newLine(); } bw.flush(); bw.close();} catch (IOException e){e.printStackTrace();}}//关闭数据库连接的方法public void shutDown(){try{if(stmt != null) stmt.close(); stmt = null;if(rs != null) rs.close(); rs = null;if(conn != null)conn.close();conn = null;} catch(SQLException e){e.printStackTrace();}}}项目中用到了MySql数据库,再把MySql的驱动添加到项目中就可以了.至于数据库方面我就不罗嗦了,只有一张表student,字段:id,name,phone,mobile,address,cert 2 楼 steryzone1 2008-11-07 为什么不试试用工厂模式，把数据库密码，用户名都用一个txt文件来放呢？还有如果我想做一个有数个表的系统，那你的那个连接数据库的文件就不能用了，它好像已经在里面写定了只连接一个表 3 楼 weixinjie 2008-11-07 steryzone1 写道
为什么不试试用工厂模式，把数据库密码，用户名都用一个txt文件来放呢？ 还有如果我想做一个有数个表的系统，那你的那个连接数据库的文件就不能用了，它好像已经在里面写定了只连接一个表
1.当时做这个系统的时候,对设计模式不是很很了解.
2.这只是学习的一个例子,当时对安全性倒没有考虑.
3.你可封装一个DBConnection,这样使用起来比较方面. 4 楼 xinjunli13 2008-12-20 你的密码是多少?登录用户名和密码