database.java

来自「网上书店网站源代码」· Java 代码 · 共 58 行

package bookshop.bean;
import java.sql.*;
import java.io.*;
import java.util.*;
public class DataBase{
	Connection conn;
	Statement stmt;
	ResultSet rs=null;
	String sql="";
	public DataBase(){
		conn=null;
		stmt=null;
		}
    public void connect(){
	try{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		conn=DriverManager.getConnection("jdbc:odbc:book");
		stmt=conn.createStatement();
		conn.close();
		stmt.close();
	}
	catch(Exception e)
	{
		System.out.println(e.getMessage());
    }
    }
    public ResultSet executeQuery(String sql){
    	try{
    		rs=stmt.executeQuery(sql);
    	}catch(Exception e)
    	{
    		System.out.print(e.getMessage());
    	}
    	return rs;
    }
    public void executeUpdate(String command){
    	try{
    		stmt.executeUpdate(command);
    	}
    	catch(Exception e)
    	{
    		System.out.print(e.getMessage());
    	}
    }
    public void closeConnection(){
    	try{
    		conn.close();
    	}
    	catch(Exception e)
    	{
    		System.out.print(e.getMessage());
    	}
		}
		public static void main(String args[])
		{
			DataBase db=new DataBase();
		}
}