标题:连接数据库的javabean这样写有不妥吗
取消只看楼主
guixiaolan
Rank: 3Rank: 3
等 级:新手上路
威 望:6
帖 子:356
专家分:0
注 册:2006-4-20
 问题点数:0 回复次数:0 
连接数据库的javabean这样写有不妥吗

package Data;
import java.sql.*;

public class database{
private Connection conn=null;
ResultSet rs=null;
private Statement stmt=null;
PreparedStatement pstmt=null;

public database(){}

public void OpenConn(String dsn,String uid,String pwd) throws Exception{
try{
dsn="jdbc:odbc:"+dsn;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(dsn,uid,pwd);
}catch(Exception ex)
{System.err.println("aq.executeQuery:"+ex.getMessage());}
}

public ResultSet executeQuery(String sql){
try{
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}catch(SQLException ex){System.err.println(ex.getMessage());}
return rs;
}

public PreparedStatement executeUpdate(String sql){
try{
pstmt=conn.prepareStatement(sql);
pstmt.executeUpdate();
}catch(SQLException ex){System.err.println(ex.getMessage());}
return pstmt;
}

public void closePstmt(){
try{pstmt.close();}
catch(SQLException ex){System.err.println(ex.getMessage());}
}

public void closeStmt(){
try{stmt.close();}
catch(SQLException ex){System.err.println(ex.getMessage());}
}

public void closeConn(){
try{conn.close();}
catch(SQLException ex){System.err.println("aq.executeQuery:"+ex.getMessage());}
}
}

感觉有冗余代码!或者在多次查询和多次更新的时候会出现错误?
请教了!

搜索更多相关主题的帖子: javabean 数据库 
2007-05-30 21:02



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-143639-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.436031 second(s), 8 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved