📄 427314.xml
字号:
    rs=null;
    try {
	 conn=DriverManager.getConnection(sConnStr);
	 stmt=conn.createStatement();
	 rs=stmt.executeQuery(sql);
      }
      //处理异常
    catch(SQLException ex){
    System.err.println("aq.executeQuery:"+ex.getMessage());}
    return rs;
  }//end method
  
//执行Insert,Update语句  
public void executeUpdate(String sql) { 
    stmt = null; 
    rs=null; 
    try { 
         conn = DriverManager.getConnection(sConnStr);  
         stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
         stmt.executeQuery(sql); 
         stmt.close(); 
         conn.close(); 
    }  
    catch(SQLException ex) {  
      System.err.println("执行SQL语句出错: " + ex.getMessage()); 
    } 
  }//end method 
//close Stmt  
public void closeStmt(){ 
    try{ 
      stmt.close(); 
    } 
    catch(SQLException e){ 
      e.printStackTrace(); 
    } 
  }//end method 
//close Conn
public void closeConn(){ 
    try{ 
      conn.close(); 
    } 
    catch(SQLException e){ 
      e.printStackTrace(); 
    } 
  }//end method 
}//END CLASS</Content>
<PostDateTime>2001-12-20 11:39:29</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>寻欢</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>2828170</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>77891</PostUserId>
<PostUserName>lxf0088</PostUserName>
<Point>0</Point>
<Content>我有,我还有全部的数据库操作访问的方法。这些方法全部是封装在一起。就象java的类一样可以调用其中的方法。把数据库的访问全部外包起来。</Content>
<PostDateTime>2001-12-20 11:43:02</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞鸟</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<ReplyID>2828620</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>130382</PostUserId>
<PostUserName>liufeng_125</PostUserName>
<Point>0</Point>
<Content>给一个。
lxb7794@sina.com.cn</Content>
<PostDateTime>2001-12-20 12:09:33</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>寻欢</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>2828896</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>77891</PostUserId>
<PostUserName>lxf0088</PostUserName>
<Point>0</Point>
<Content>我的连接是用的Oracle数据库,你可以把其中的Driver改一下就可以了。</Content>
<PostDateTime>2001-12-20 12:28:28</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>寻欢</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>2828998</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>77891</PostUserId>
<PostUserName>lxf0088</PostUserName>
<Point>0</Point>
<Content>我已经给你发了邮件了,程序你还是需要自己慢慢的读。
如果你觉得那个太复杂,我可以再给你一个更简单的。
也能实现基本的对数据库访问的操作。</Content>
<PostDateTime>2001-12-20 12:34:28</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞鸟</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<ReplyID>2829411</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>130382</PostUserId>
<PostUserName>liufeng_125</PostUserName>
<Point>0</Point>
<Content>to lxf0088(寻欢)
    分是没有问题的,因为我是初学者,但是你给的太复杂,能否给个简单的,最好能附带个简单的说明。
   谢谢了先!</Content>
<PostDateTime>2001-12-20 12:55:14</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞翔</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>2835196</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>145210</PostUserId>
<PostUserName>xiaoqianfu</PostUserName>
<Point>0</Point>
<Content>lxf0088(寻欢)
可以也给我发一个吗????
xiaoqianfu2000@yahoo.com.cn</Content>
<PostDateTime>2001-12-20 17:50:25</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>2837744</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>31576</PostUserId>
<PostUserName>hopred</PostUserName>
<Point>0</Point>
<Content>你为什么会出错是不是没有在控制面板里添加ODBC数据源</Content>
<PostDateTime>2001-12-20 21:29:29</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞鸟</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<ReplyID>2840456</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>130382</PostUserId>
<PostUserName>liufeng_125</PostUserName>
<Point>0</Point>
<Content>当然添加了。</Content>
<PostDateTime>2001-12-21 9:03:59</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>猴王</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>2842615</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>93547</PostUserId>
<PostUserName>kmonkey</PostUserName>
<Point>0</Point>
<Content>ok</Content>
<PostDateTime>2001-12-21 11:01:15</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>根宝加油啊</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>2843083</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>89760</PostUserId>
<PostUserName>highest007</PostUserName>
<Point>0</Point>
<Content>SHIT</Content>
<PostDateTime>2001-12-21 11:25:18</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>含羞草</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>2853055</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>66389</PostUserId>
<PostUserName>maidna</PostUserName>
<Point>0</Point>
<Content>我们正用
JDK1。3+COMCA3.2.1+SQLSERVER 2000+win200server开发个项目呢
下次给你方法</Content>
<PostDateTime>2001-12-21 21:13:18</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>天灰</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>2890313</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>154350</PostUserId>
<PostUserName>cxx</PostUserName>
<Point>0</Point>
<Content>to:lxf0088(寻欢)
大哥,也给我发一个吧,wdml@citiz.net。
多谢多谢!</Content>
<PostDateTime>2001-12-25 11:11:29</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>寻欢</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>2896925</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>77891</PostUserId>
<PostUserName>lxf0088</PostUserName>
<Point>0</Point>
<Content>我的信箱是:pclixf@sina.com.cn.
如果有朋友需要请给我发邮件。
liufeng_125(飞鸟):另外一个简单的我已经给你发过去了。
你看看吧。如有什么疑问可以直接发mail给我。
</Content>
<PostDateTime>2001-12-25 16:34:14</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>好心情</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>110</credit>
<ReplyID>3610054</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>111059</PostUserId>
<PostUserName>zxp_net</PostUserName>
<Point>0</Point>
<Content>谢谢了,真要谢谢大家的帮助了!</Content>
<PostDateTime>2002-2-23 13:16:02</PostDateTime>
</Reply>
</Replys>
</Topic>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -