菜鸟请教一个jsp数据库简单问题__String_public_query_statement_conn1_Connection_

当前位置: 技术问答>java相关

菜鸟请教一个jsp数据库简单问题

来源: 互联网发布时间：2015-01-23

本文导语: 1。如何把Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:test","sa",""); Statement statement=con.createStatement() ;这些连接数据库的东西写个简单的javabean? 2。java.sql里的resultset，如果执行完一条sq...

1。如何把Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","");
Statement statement=con.createStatement() ;这些连接数据库的东西写个简单的javabean?

2。java.sql里的resultset，如果执行完一条sql语句，还要执行一个，是不是要重建一个resultset？要不要重建connection和Statement等对象

1:
     public Connection conn;

       public void setConnection(String driverName,String jdbcURL,String username,String passwd) throws Exception
    {
        Connection conn1;
        Class.forName(driverName);
        conn1=DriverManager.getConnection(jdbcURL,username,passwd);
        conn1.setAutoCommit(false);
        this.conn = conn1;
    }

1.给你一个对数据库增删改的bean:里面包含又和数据库的连接。

QueryBean.java:

/*
*writed by lci21
*/
import java.sql.*;
public class QueryBean
{
    public String query_statement;
    public String param[];  //查询条件,或者是新的记录
    public ResultSet result=null;
    public Connection conn;

    public void setParam(String[] param)
    {
        this.param=param;
    }
    public void setQuerystatement(String query_statement)
    {
        this.query_statement=query_statement;
    }
    public void setConnection(String driverName,String jdbcURL,String username,String passwd) throws Exception
    {
        Connection conn1;
        Class.forName(driverName);
        conn1=DriverManager.getConnection(jdbcURL,username,passwd);
        conn1.setAutoCommit(false);
        this.conn = conn1;
    }

    public ResultSet getResult()
    {
        try
        {
            PreparedStatement select_stm=conn.prepareStatement(query_statement,java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
            if (param!=null)
                    for(int i=0;i