图书管理系统连接SQLSERVER

import javax.swing.*; import java.awt.*; import java.awt.event.*; import javax.swing.table.*; import java.util.Vector; import java.sql.*; public class Reader extends JFrame implements ActionListener{ LoginFrame login=new LoginFrame(); Book bookMsg; Student studentMsg; Borrow borrowMsg; JPanelDemo jpd; Guanyu gy; JMenuBar Jbar=new JMenuBar(); JMenu JMenuFind=new JMenu("查询"); JMenu JMenuHelp=new JMenu("帮助"); JMenuItem JItembook=new JMenuItem("图书信息查询"); JMenuItem JItemstudent=new JMenuItem("个人信息查询"); JMenuItem JItemborrow=new JMenuItem("借阅信息查询"); JMenuItem JItemQuit=new JMenuItem("退出登录"); JMenuItem JItemabout=new JMenuItem("关于"); JMenuItem JItemhelp=new JMenuItem("帮助内容"); Reader(){ super("借阅者登录"); setSize(950,600); setLocation(45,45); jpd=new JPanelDemo(); getContentPane().add(jpd); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setJMenuBar(Jbar); Jbar.add(JMenuFind); Jbar.add(JMenuHelp); JMenuFind.add(JItembook); JMenuFind.add(JItemstudent); JMenuFind.add(JItemborrow); JMenuFind.addSeparator(); JMenuFind.add(JItemQuit); JMenuHelp.add(JItemabout); JMenuHelp.add(JItemhelp); JMenuFind.setFont(new Font("隶书",Font.BOLD,30)); JMenuHelp.setFont(new Font("隶书",Font.BOLD,30)); JItembook.setFont(new Font("宋体",Font.TRUETYPE_FONT,25)); JItemstudent.setFont(new Font("宋体",Font.TRUETYPE_FONT,25)); JItemborrow.setFont(new Font("宋体",Font.TRUETYPE_FONT,25)); JItemQuit.setFont(new Font("宋体",Font.TRUETYPE_FONT,25)); JItemabout.setFont(new Font("宋体",Font.TRUETYPE_FONT,25)); JItemhelp.setFont(new Font("宋体",Font.TRUETYPE_FONT,25)); JItembook.addActionListener(this); JItemstudent.addActionListener(this); JItemborrow.addActionListener(this); JItemQuit.addActionListener(this); JItemabout.addActionListener(this); JItemhelp.addActionListener(this); setVisible(true); setResizable(false); } public static void main(String[] args) { new Reader(); } public void actionPerformed(ActionEvent e) { if(e.getSource()==JItembook){ bookMsg=new Book(this,"图书信息查询",true); bookMsg.setVisible(true); }else if(e.getSource()==JItemstudent){ studentMsg=new Student(this,"个人信息查询",true); studentMsg.setVisible(true); }else if(e.getSource()==JItemborrow){ borrowMsg=new Borrow(this,"借阅信息查询",true); borrowMsg.setVisible(true); }else if(e.getSource()==JItemQuit){ //System.exit(0); setVisible(false); login.setVisible(true); }else if(e.getSource()==JItemabout){ JOptionPane.showMessageDialog(this,"这是皖江学院图书馆借阅者系统!\n由孙致建、张仁贵、马海波、夏兵、翟霆共同开发!\n Version 1.0\nALL Rights Reserved,2009-2010","关于",JOptionPane.INFORMATION_MESSAGE); }else if(e.getSource()==JItemhelp){ gy=new Guanyu(this,"关于图书馆的事项",true); } } } class JPanelDemo extends JPanel implements Runnable{ private int x=100; private int y=100; private String str="欢迎进入借阅者管理系统"; Image img; Toolkit tool; public JPanelDemo(){ setSize(1000,800); tool=getToolkit(); img=tool.getImage("c.jpg"); new Thread(this).start(); } public void run() { while(true){ try{ x=x+10; if(x>950){ x=-600; } Thread.sleep(250); repaint(); }catch(Exception e){} } } public void paint(Graphics g){ g.drawImage(img,0,0,this); g.setColor(Color.BLUE); g.setFont(new Font("隶书",Font.BOLD,55)); g.drawString(str,x,y); } } class Book extends JDialog implements ActionListener{ JTextField Jname=new JTextField(15); JTextField Jnum=new JTextField(15); JTextField Jauthor=new JTextField(15); JTextField Jpress=new JTextField(15); //JLabel Jlabnum=new JLabel("图书编码:"); JLabel Jlabnam=new JLabel("书名:"); JLabel Jlabaut=new JLabel("作者:"); JLabel Jlabpre=new JLabel("出版社:"); String[] name={"图书编码","书名","作者","出版社","价格(元)","状态"}; String[][] data=new String[0][0]; DefaultTableModel defaultModel=new DefaultTableModel(data,name); JTable Jshow=new JTable(defaultModel); JScrollPane s=new JScrollPane(Jshow); JButton Jok=new JButton("确定"); JButton Jcancel=new JButton("取消"); JPanel Jpan1=new JPanel(); JPanel Jpan2=new JPanel(); Book(JFrame Jf,String title,boolean b){ super(Jf,title,b); setSize(950,600); setLocation(45,45); setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); //Jpan1.add(Jlabnum); //Jpan1.add(Jnum); Jpan1.add(Jlabnam); Jpan1.add(Jname); Jpan1.add(Jlabaut); Jpan1.add(Jauthor); Jpan1.add(Jlabpre); Jpan1.add(Jpress); Jpan1.add(Jok); Jpan1.add(Jcancel); getContentPane().add("North",Jpan1); getContentPane().add("Center",Jpan2); // Jlabnum.setFont(new Font("隶书",Font.BOLD,20)); Jlabnam.setFont(new Font("隶书",Font.BOLD,20)); Jlabaut.setFont(new Font("隶书",Font.BOLD,20)); Jlabpre.setFont(new Font("隶书",Font.BOLD,20)); Jok.setFont(new Font("隶书",Font.BOLD,20)); Jcancel.setFont(new Font("隶书",Font.BOLD,20)); Jshow.setPreferredScrollableViewportSize(new Dimension(950,580)); Jpan2.add(s); setResizable(false); Jok.addActionListener(this); Jcancel.addActionListener(this); } public void actionPerformed(ActionEvent e) { Connection conn; Statement stmt; ResultSet rs; int i=0,j=0; if(e.getSource()==Jok){ String strSQL="select * from 图书信息"; String strSql=null; if(Jname.getText().trim().equals("")&&Jauthor.getText().trim().equals("")&& Jpress.getText().trim().equals("")){ JOptionPane.showMessageDialog(this,"查询信息不能为空！","出错",JOptionPane.INFORMATION_MESSAGE); }else if(Jname.getText().trim().equals("")&&Jauthor.getText().trim().equals("")){ strSql=strSQL+" where 出版社='"+Jpress.getText().trim()+"'"; }else if(Jname.getText().trim().equals("")&&Jpress.getText().trim().equals("")){ strSql=strSQL+" where 作者='"+Jauthor.getText().trim()+"'"; }else if(Jauthor.getText().trim().equals("")&&Jpress.getText().trim().equals("")){ strSql=strSQL+" where 书名='"+Jname.getText().trim()+"'"; }else if(Jname.getText().trim().equals("")){ strSql=strSQL+" where 作者='"+Jauthor.getText().trim()+"'and 出版社='"+Jpress.getText().trim()+"'"; }else if(Jauthor.getText().trim().equals("")){ strSql=strSQL+" where 书名='"+Jname.getText().trim()+ "'and 出版社='"+Jpress.getText().trim()+"'"; }else if(Jpress.getText().trim().equals("")){ strSql=strSQL+" where 书名='"+Jname.getText().trim()+"'and 作者='"+Jauthor.getText().trim()+"'"; }else{ strSql=strSQL+" where 书名='"+Jname.getText().trim()+ "'and 作者='"+Jauthor.getText().trim()+"'and 出版社='"+ Jpress.getText().trim()+"'"; } try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn=DriverManager.get