conn1.0.java

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

package mybag;
import java.sql.*;
public class Conn1{
	private String aDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	private String url="jdbc:odbc:fns";
	Connection con=null;
	Statement smt=null;
	ResultSet rst=null;
	public Conn1(){
	try{
	Class.forName(aDriver);}
	catch(java.lang.ClassNotFoundException e){System.err.println("Class.forName 	error"+e.getMessage());}
	}
	public void Insert(String sql){
	try{
	con=DriverManager.getConnection(url);
	smt=con.createStatement();
	smt.executeUpdate(sql);
	}catch(SQLException e)
	{System.out.println("insert error"+e.getMessage());}
	
	}
	public void del(String sql){
	try{
	con=DriverManager.getConnection(url);
	smt=con.createStatement();
	smt.executeUpdate(sql);
	}catch(SQLException e)
	{System.err.println("delete error"+e.getMessage());}
	
	}
	public ResultSet query(String sql){
	try{
	con=DriverManager.getConnection(url);
	smt=con.createStatement();
	rst=smt.executeQuery(sql);
	}catch(SQLException e)
	{System.err.println("delete error"+e.getMessage());}
	return rst;
	}
}