图书管理系统整合sqlserver2008

package com.duzhexinxiguanli; import java.awt.Toolkit; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.util.ArrayList; import java.util.List; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.table.DefaultTableModel; import com.dao.DuZheDangAnDao; import com.vo.DuZheDangAn; public class DuZheXinXiGuanLiAdd extends JFrame{ private static final long serialVersionUID = 1L; private JTextField xingming,xingbie,yuanxi,dushuleixing,zhengjianleixing, zhengjianhaoma,linxi,banzhengriqi,maxjieshudushuleixing; private JButton btnDel; private JButton btnAdd; //顶一个表格 private JTable table; //定义几个标题文本框 private JLabel lblxingming,lblxingbie,lblyuanxi,lbldushuleixing,lblzhengjianleixing, lblzhengjianhaoma,lbllinxi,lblbanzhengriqi,lblmaxjieshudushuleixing; private DefaultTableModel model; private String[] columns = {"姓名","性别","院系","读者类型","证件类型","证件号码","联系电话","办证日期","允许最多借书册数"}; private List<DuZheDangAnDao> data; public DuZheDangAnDao DuZheDangAn1; public DuZheDangAn tmp; public DuZheXinXiGuanLiAdd(){ data = new ArrayList<DuZheDangAnDao>(); //设置布局.取消布局管理器 getContentPane().setLayout(null); lblxingming = new JLabel("姓名:"); lblxingming.setBounds(10, 10, 420, 13); getContentPane().add(lblxingming); //设置文本框 xingming = new JTextField(); xingming.setBounds(70, 7, 86, 19); getContentPane().add(xingming); xingming.setColumns(10); lblxingbie = new JLabel("性别："); lblxingbie.setBounds(200, 10, 422, 13); getContentPane().add(lblxingbie); //设置文本框 xingbie = new JTextField(); xingbie.setColumns(10); xingbie.setBounds(265, 7, 86, 19); getContentPane().add(xingbie); lblyuanxi = new JLabel("院系"); lblyuanxi.setBounds(398, 10, 422, 13); getContentPane().add(lblyuanxi); //设置文本框 yuanxi = new JTextField(); yuanxi.setColumns(10); yuanxi.setBounds(465, 7, 86, 19); getContentPane().add(yuanxi); // "姓名","性别","院系","读者类型","证件类型","证件号码", lbldushuleixing = new JLabel("读者类型"); lbldushuleixing.setBounds(10, 35, 422, 13); getContentPane().add(lbldushuleixing); //设置文本框 dushuleixing = new JTextField(); dushuleixing.setColumns(10); dushuleixing.setBounds(70, 33, 86, 19); getContentPane().add(dushuleixing); lblzhengjianleixing = new JLabel("证件类型"); lblzhengjianleixing.setBounds(200, 35, 422, 13); getContentPane().add(lblzhengjianleixing); //设置文本框 zhengjianleixing = new JTextField(); zhengjianleixing.setColumns(10); zhengjianleixing.setBounds(265, 33, 86, 19); getContentPane().add(zhengjianleixing); lblzhengjianhaoma = new JLabel(" 证件号码"); lblzhengjianhaoma.setBounds(398, 35, 422, 13); getContentPane().add(lblzhengjianhaoma); //设置文本框 zhengjianhaoma = new JTextField(); zhengjianhaoma.setColumns(10); zhengjianhaoma.setBounds(465, 33, 86, 19); getContentPane().add(zhengjianhaoma); lbllinxi = new JLabel("联系电话"); lbllinxi.setBounds(10, 50, 422, 13); getContentPane().add(lbllinxi); //设置文本框 linxi = new JTextField(); linxi.setColumns(10); linxi.setBounds(70, 48, 86, 19); getContentPane().add(linxi); lblmaxjieshudushuleixing = new JLabel("最多借书册数"); lblmaxjieshudushuleixing.setBounds(200, 50, 422, 13); getContentPane().add(lblmaxjieshudushuleixing); //设置文本框 maxjieshudushuleixing = new JTextField(); maxjieshudushuleixing.setColumns(10); maxjieshudushuleixing.setBounds(265, 48, 86, 19); getContentPane().add(maxjieshudushuleixing); //创建一个删除的按钮 btnDel = new JButton(" 删除 "); //设置按钮的大小 btnDel.setBounds(180, 70, 77, 21); getContentPane().add(btnDel); btnDel.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { del(); } } ); btnAdd = new JButton("添加"); //设置按钮的大小 btnAdd.setBounds(75, 70, 77, 21); getContentPane().add(btnAdd); btnAdd.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { add(); } } ); model = new DefaultTableModel(columns, 0); table = new JTable(model); //添加鼠标监听的事件 table.addMouseListener(new MouseAdapter() { //鼠标单击方法 public void mouseClicked(MouseEvent e) { //返回第一个选定行的索引；如果没有选定的行，则返回 -1。 int row = table.getSelectedRow(); xingming.setText((String) table.getValueAt(row, 0)); xingbie.setText((String) table.getValueAt(row, 1)); yuanxi.setText((String) table.getValueAt(row, 2)); dushuleixing.setText((String) table.getValueAt(row, 3)); zhengjianleixing.setText((String) table.getValueAt(row, 4)); zhengjianhaoma.setText((String) table.getValueAt(row, 5)); zhengjianhaoma.setText((String) table.getValueAt(row, 6)); zhengjianhaoma.setText((String) table.getValueAt(row, 7)); tmp = getInput(); } }); //管理窗口。 JScrollPane scrollPane = new JScrollPane(table); //设置添加框的边界大小 scrollPane.setBounds(12, 100, 571, 248); getContentPane().add(scrollPane); this.setTitle("进货信息维护"); // 给界面的右上角的“叉”键添加了结束程序的功能 this.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE); // 设置此窗口相对于指定组件的位置。如果此组件当前未显示，或者 c 为 null，则此窗口位于屏幕的中央。 setLocationRelativeTo(null); int width = 601; int height = 380; //设置距离屏幕的 位置.定位屏幕居中 int x = (int)(Toolkit.getDefaultToolkit().getScreenSize().getWidth()-width)/2; int y = (int)(Toolkit.getDefaultToolkit().getScreenSize().getHeight()-height)/2; setLocation(x,y); //设置文本框的大小 setSize(601, 380); //设置文本框的大小。参数为TRUE的时候。大小可以任意改变 setResizable(false); //visible设置是否显示文本框。TRUE为显示。默认为FALSE setVisible(true); showTable(); } private DuZheDangAn getInput() { DuZheDangAn DuZheDangAn = new DuZheDangAn(); //获取文本框的值 String code_s = xingming.getText().trim(); if (code_s.equals( "")) { JOptionPane.showMessageDialog(null, "请输入姓名！", "进货信息维护", JOptionPane.ERROR_MESSAGE); return null; } if (!code_s.matches("^[0-9]+$")) { JOptionPane.showMessageDialog(null, "请输入纯数字编号！", "进货信息维护", JOptionPane.ERROR_MESSAGE); return null; } DuZheDangAn.xingming= xingming.getText(); DuZheDangAn.xingbie= xingbie.getText(); DuZheDangAn.yuanxi= yuanxi.getText(); DuZheDangAn.dushuleixing= dushuleixing.getText(); DuZheDangAn.zhengjianleixing= zhengjianleixing.getText(); DuZheDangAn.linxi= linxi.getText(); DuZheDangAn.zhengjianhaoma= zhengjianhaoma.getText(); DuZheDangAn.maxjieshunumber= maxjieshudushuleixing.getText(); return DuZheDangAn; } //删除 private void del() { //获取到id if(this.getInput()!=null){ String id1 = getInput().getXingming(); DuZheDangAn1 = new DuZheDangAnDao(); DuZheDangAn1.delDuZheDangAn(id1); showTable(); } } //添加 private void add() { DuZheDangAnDao s = new DuZheDangAnDao(); if(this.getInput()!=null){ s.addDuZheDangAn(this.getInput()); showTable(); } } private void showTable() { removeRows(); DuZheDangAnDao DuZheDangAnDao = new D