db.java

来自「《jsp编程起步》里面的所有源代码」· Java 代码 · 共 45 行

package Db;

import java.sql.*;
import Bk.*;
import java.util.*;

public class Db{
	Connection Conn=null;
	Statement stmt=null;
	String sDBDriver = "com.jnetdirect.jsql.JSQLDriver";
	String sConnStr = "jdbc:JSQLConnect://localhost/mydb";
	
	public Db(){
		try{
			Class.forName("com.jnetdirect.jsql.JSQLDriver");
			Conn=DriverManager.getConnection(sConnStr,"sa","eren&candle");
			stmt=Conn.createStatement();
		}catch(Exception e){
			System.err.println(e);			
		}
	}
	
	public ResultSet execQ(String SQL){
		
		try{
			ResultSet rs=null;
			rs=stmt.executeQuery(SQL);
			
			return rs;
		}catch(Exception e){
			System.err.println(e);			
			return null;
		}
		
	}
	public boolean destroy(){
		try{
			Conn.close();
		}catch(Exception e){
			return false;	
		}
		return true;
	}
	
}