jdbcbean.java

jsp数据库编程入门

package test;
import java.sql.*;
public class JdbcBean
{
    Connection con=null;
    ResultSet rs=null;
    //实例化，装载JDBC驱动程序
	public JdbcBean()
	{
		try{
		     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		    }
		    catch(ClassNotFoundException e) {}
	}
	//返回查询后的数据集
	public ResultSet executeQuery(String sql)
	{
	    String url="jdbc:odbc:TestData";
        String username="";
        String password="";
        try{
		     con=DriverManager.getConnection(url,username,password);
		     Statement stmt=con.createStatement();
		     rs=stmt.executeQuery(sql);
		   }
		   catch(SQLException e) {}
		return rs;
	}
	//关闭数据库
	public void closeDB()
	{
		try{
		    rs.close();
		    con.close();
		  }catch(SQLException e) {}
	}
}