conn.java

基于JAVAJSP的网上书店系统需要的下载 希望对大家有用

package mybag;
import java.sql.*;
public class Conn{
	private String aDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	private String url="jdbc:odbc:fns";
	Connection con=null;
	Statement smt=null;
	ResultSet rst=null;
	public Conn(){
	try{
	Class.forName(aDriver);}
	catch(Exception e){System.out.println("Class.forName error");}
	}
	public ResultSet query(String str){
	System.out.println("song :\n"+str);
	try{
	con=DriverManager.getConnection(url,"","");
	smt=con.createStatement();
	rst=smt.executeQuery(str);
	}catch(SQLException e){System.out.println("DriverManger or Statement error");}
	return rst;
	}
	public void close(){
	try{
	smt.close();
	con.close();
	}
	catch(SQLException e){System.out.println("close error");}
	}
}