📄 766009.xml
字号:
<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>无知</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<TopicId>766009</TopicId>
<TopicName>高分求数据库连接池javabean（最好是针对postgreSQL的）</TopicName>
<PostUserId>238214</PostUserId>
<PostUserName>javafool</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>8</ReplyNum>
<PostDateTime>2002-5-30 18:02:43</PostDateTime>
<Point>100</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>各位大侠
帮帮忙吧
最好多写点注释！
本想跟200分的，可是系统竟然提示我不能给这么多分......
注：最好的将获得80分，剩下20分给所有提供bean者！</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>我有一个梦...</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>97</credit>
<ReplyID>4989418</ReplyID>
<TopicID>766009</TopicID>
<PostUserId>214210</PostUserId>
<PostUserName>AreDreaming</PostUserName>
<Point>0</Point>
<Content>你查找一下以往的帖子，很多的</Content>
<PostDateTime>2002-5-30 18:42:41</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>希偌</PostUserNickName>
<rank>两星(中级)</rank>
<ranknum>star2</ranknum>
<credit>135</credit>
<ReplyID>4989622</ReplyID>
<TopicID>766009</TopicID>
<PostUserId>133413</PostUserId>
<PostUserName>beyond_xiruo</PostUserName>
<Point>10</Point>
<Content>package bbs;
import java.sql.*;
public class conn{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:bbs";
Connection conn = null;
ResultSet rs = null;
public conn(){
try {
Class.forName(sDBDriver); 
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("bbsreg(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr); 
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} 
catch(SQLException ex) { 
System.err.println("aq.executeQuery: " + ex.getMessage());
System.err.println("aq.executeQuerystrSQL: " + sql);
}
return rs;
}
public void executeUpdate(String sql) {
try {
conn = DriverManager.getConnection(sConnStr); 
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
} 
catch(SQLException ex) { 
System.err.println("aq.executeUpdate: " + ex.getMessage());
System.err.println("aq.executeUpadatestrSQL: " + sql);
}
}
}</Content>
<PostDateTime>2002-5-30 18:56:00</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>weidegong</PostUserNickName>
<rank>两星(中级)</rank>
<ranknum>star2</ranknum>
<credit>118</credit>
<ReplyID>4989779</ReplyID>
<TopicID>766009</TopicID>
<PostUserId>128268</PostUserId>
<PostUserName>weidegong</PostUserName>
<Point>10</Point>
<Content>希诺兄真的学开JSP了，很高兴有了个伙伴：）
增加几个方法：
//----------将存储在数据库中的文件、图片输出
  public void WriteToFileByOdbc(String sql,String FileName,String Zd){
    countInt=0;
    try{
      drpRst = drpStmt.executeQuery(sql);
      if (drpRst.next()){
         InputStream ins=drpRst.getBinaryStream(Zd);
         FileOutputStream fos=new FileOutputStream(FileName);
        int readbyte=0;
        while (true)
         {
           readbyte=ins.read();
          if (readbyte==-1)
               break;
           fos.write(readbyte);
         }
          ins.close();
          }
        countInt=1;//写入成功
        }catch(FileNotFoundException aa){
          countInt=-1;
          System.out.println("File error");
        }catch(SQLException sqly){
          countInt=-1;
          System.out.println("Sql error");
        }catch(IOException io){
          countInt=-1;
          System.out.println("IO error");
        }
   }
//-------------------------------------------------------------------
</Content>
<PostDateTime>2002-5-30 19:07:07</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>weidegong</PostUserNickName>
<rank>两星(中级)</rank>
<ranknum>star2</ranknum>
<credit>118</credit>
<ReplyID>4989862</ReplyID>
<TopicID>766009</TopicID>
<PostUserId>128268</PostUserId>
<PostUserName>weidegong</PostUserName>
<Point>0</Point>
<Content>//-------------------------------------------------------------
//事务处理的几个方法
public void beginTrans() throws SQLException
{ try
{
autoCommit=conn.getAutoCommit();
conn.setAutoCommit(false);
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.print("beginTrans Errors");
throw ex;
}
}
public void commit() throws SQLException
{
try
{
conn.commit();
conn.setAutoCommit(autoCommit);
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.print("Commit Errors");
throw ex;
}
}
public void rollback()
{
try
{
conn.rollback();
conn.setAutoCommit(autoCommit);
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.print("Rollback Errors");
//throw ex;
}
}
public boolean getAutoCommit() throws SQLException
{
boolean result=false;
try
{
result=conn.getAutoCommit();
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.println("getAutoCommit fail"+ex.getMessage());
throw ex;
}
return result;
}
//-------------------------------------------------------------
</Content>
<PostDateTime>2002-5-30 19:12:05</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>无知</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>4996147</ReplyID>
<TopicID>766009</TopicID>
<PostUserId>238214</PostUserId>
<PostUserName>javafool</PostUserName>
<Point>0</Point>
<Content>没有for  postgreSQl的javabea吗？</Content>
<PostDateTime>2002-5-31 9:06:32</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>无知</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>4996452</ReplyID>
<TopicID>766009</TopicID>
<PostUserId>238214</PostUserId>
<PostUserName>javafool</PostUserName>
<Point>0</Point>
<Content>(希偌)大侠：
你的bean怎么不全阿？
怎么没有insert和delete？
能帮解释一下
String sConnStr = "jdbc:odbc:bbs";
......
conn = DriverManager.getConnection(sConnStr); 
上面的bbs到底是什么含义？
</Content>
<PostDateTime>2002-5-31 9:18:34</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>无知</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>4997531</ReplyID>
<TopicID>766009</TopicID>
<PostUserId>238214</PostUserId>
<PostUserName>javafool</PostUserName>
<Point>0</Point>
<Content>如果数据库有密码怎么办？
上面的BEAN好像没有输入用户名和密码的位置</Content>
<PostDateTime>2002-5-31 10:02:40</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>回车</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>4998680</ReplyID>
<TopicID>766009</TopicID>
<PostUserId>214735</PostUserId>
<PostUserName>Times2001</PostUserName>
<Point>80</Point>
<Content>import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
/**
* 管理类DBConnectionManager支持对一个或多个由属性文件定义的数据库连接
* 池的访问.客户程序可以调用getInstance()方法访问本类的唯一实例.
*/
public class DBConnectionManager {
static private DBConnectionManager instance; // 唯一实例
static private int clients;
private Vector drivers = new Vector();
private PrintWriter log;
private Hashtable pools = new Hashtable();
/**
* 返回唯一实例.如果是第一次调用此方法,则创建实例
*
* @return DBConnectionManager 唯一实例
**/
static synchronized public DBConnectionManager getInstance() {
if (instance == null) {
instance = new DBConnectionManager();
}
clients++;
return instance;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -