cn.java

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

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