library.java

这个程序是用JAVA和MYSQL进行连接

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

public class library
{
	public static void main(String [] args)
	{
		simpleFrame leah=new simpleFrame();
		leah.show();
	}
	
	static class simpleFrame extends JFrame implements ActionListener
	{
		private Connection con=null;
		private Statement stmt=null;
		private ResultSet rs=null;		
		private JLabel conditionlabel=new JLabel("请填写下列查询条件",SwingConstants.CENTER);
		private JLabel bookname1=new JLabel("书名",SwingConstants.RIGHT);
		private JTextField bookname2=new JTextField(8);		
		private JLabel writer1=new JLabel("作者",SwingConstants.RIGHT);
		private JTextField writer2=new JTextField(8);		
		private JLabel isbn1=new JLabel("ISBN",SwingConstants.RIGHT);
		private JTextField isbn2=new JTextField(20);
        private JButton inquire=new JButton("查询");       
        private JLabel resultlabel=new JLabel("查询结果",SwingConstants.CENTER);       
        private JTextArea resultarea=new JTextArea(10,35);        
        private String command=null;       
        public simpleFrame()//构造函数
        {
        	setTitle("查询");
        	setSize(600,300);       	
        	addWindowListener
        	(
        		new WindowAdapter()
        		{
        		public void windowClosing(WindowEvent e)
        		{
        			System.exit(0);
        		}
        	}
        	);        	
            setup();//排版            	
        	inquire.addActionListener(this);//监听
        	inquire.setNextFocusableComponent(bookname1);   	
        	try
        	{
        		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
        		System.out.println("成功加载JDBC-ODBC驱动程序！");
        		con=DriverManager.getConnection("jdbc:odbc:book","admin","abc");//连接数据库
        		System.out.println("连接数据库成功！");
        	}
        	catch(Exception e)
        	{
        		resultarea.append(e.getMessage()+"\n");
        		return;
        	}
        	pack();
        	show();
        }      
        private void setup()//面板
        {
        	JPanel p1=new JPanel();
        	p1.setLayout(new FlowLayout());
        	p1.add(conditionlabel);       	
        	JPanel p2=new JPanel();
        	p2.setLayout(new FlowLayout());
        	p2.add(bookname1);
        	p2.add(bookname2);
        	p2.add(writer1);
        	p2.add(writer2);
        	p2.add(isbn1);
        	p2.add(isbn2);       	
        	JPanel p3=new JPanel();
        	p3.setLayout(new FlowLayout());
        	p3.add(inquire);       	
        	JPanel p6=new JPanel();
        	p6.setLayout(new BorderLayout());
        	p6.add("North",p1);
        	p6.add("Center",p2);
        	p6.add("South",p3);       	
        	JPanel p4=new JPanel();
        	p4.setLayout(new FlowLayout());
        	p4.add(resultarea);        	
        	JPanel p7=new JPanel();
        	p7.setLayout(new BorderLayout());
        	p7.add("North",resultlabel);
        	p7.add("South",resultarea);      	
        	setLayout(new BorderLayout());
        	add("North",p6);
        	add("South",p7);
        }      
        public void actionPerformed(ActionEvent evt)//事件响应
        {
        	try{
        		String bookname1v=bookname2.getText().trim();
        		String writer1v=writer2.getText().trim();
        		String isbn1v=isbn2.getText().trim();
        		//支持模糊搜索，并且当查询条件中某项输入为空时，认为此项取值不受限制	
        		String sbookname,swriter,sisbn;
        		sbookname="LIKE '%"+bookname1v+"%'";
        		swriter="LIKE '%"+writer1v+"%'";
        		sisbn="LIKE'%"+isbn1v+"%'";       		
        		command="select *from bookInfo where 书名 "+sbookname+" and 作者 "+swriter+" and ISBN "+sisbn;
        		stmt = con.createStatement();
        		rs=stmt.executeQuery(command);        		
        		resultarea.setText("");       		
        		if(!rs.next()) 
        		    resultarea.setText("找不到符合此条件的记录");
        		else
        		{
        			do
        			{
        				String one=rs.getString(1).trim();
        				String two=rs.getString(2).trim();
        				String three=rs.getString(3).trim();
        				resultarea.append(one+"  ");
        				resultarea.append(two+"  ");
        				resultarea.append(three+"  ");
        				resultarea.append(rs.getString(4)+" ");
        				resultarea.append(rs.getString(5)+" ");
        				resultarea.append(rs.getString(6)+" ");
        				resultarea.append(rs.getString(7)+"\n");
        			}
        			while(rs.next());
        		}
        	}
	       	catch(Exception ex){
	       		resultarea.append(ex.getMessage()+"\n");
	       	}
	    }
	}
}