database_sever.java

图书馆的图书管理系统！ 图书查询

package labraryManager;
import java.sql.*;

import javax.swing.JOptionPane;
import javax.swing.SwingUtilities;
import javax.swing.UIManager;
import javax.swing.UnsupportedLookAndFeelException;

import java.util.*;
public class DataBase_Sever {
	
	private Connection con;
	private Statement st;
	public ResultSet rs;
	
	String url =
	    "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:/workspace/LabraryManageSystem/labraryManager/library.mdb";
	
	private void conDB(){
		
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (ClassNotFoundException e) {
			JOptionPane.showMessageDialog(null, "数据库错误");
	    }
		try {
			con=DriverManager.getConnection(url);
			st=con.createStatement();
			
		} catch (SQLException e) {
			JOptionPane.showMessageDialog(null, "数据库连接失败");
		}
		
	}
	public void closeDB() {
		try {
		st.close();
		con.close();
		} catch (SQLException e) {
		JOptionPane.showMessageDialog(null, "数据库关闭失败");
		}
	}
	public void select(String s1,String s2){
		conDB();
		
			String strSQL = "SELECT * FROM "+s1+" "+s2;
			
				try {
					rs=st.executeQuery(strSQL);
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			
		
		
	}
	public void insert(String s1,String s2){
		conDB();
		 
		String strSQL =
			"INSERT INTO "+s1+" VALUES"+s2;
		
			
				
					try {
						st.executeUpdate(strSQL);
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				
			
			
		
	}
	public void update(String s1,String s2){
		conDB();
		String strSQL = "update "+s1+" set " +s2;
		
		
		
			try {
				st.executeUpdate(strSQL);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		
		
	}
	public void delete(String s1,String s2){
		conDB();
		String strSQL = "DELETE FROM "+s1+" "+s2;
		
			
				
					try {
						st.executeUpdate(strSQL);
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
					
			
	       
		
	}
	public Vector getData(ResultSet rs1){
		Vector v=new Vector();
		ResultSetMetaData rsmd;
		try{
			rsmd=rs1.getMetaData();
		    int cC=rsmd.getColumnCount();;
		    Vector vTemp=new Vector();
		    for(int i=0;i<cC;i++)
		    {
		    	vTemp.addElement(rsmd.getColumnLabel(i+1));
		    	}
		    vTemp.trimToSize();
		    v.addElement(vTemp);
		    while(rs1.next())
		    {
		    	vTemp=new Vector();
		    	for(int i=0;i<cC;i++){
		    		String sTemp=rs1.getString(i+1);
		    		vTemp.addElement(sTemp);
		    	}
		    	vTemp.trimToSize();
		    	v.addElement(vTemp);
		    	
		    }
		
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		v.trimToSize();
		return v;
	}
	
	
}