?? 復件 forumbbs.java
字號:
package chapter10;
import java.util.Vector;
import java.sql.*;
import chapter10.DateItem;
import chapter10.ConnPool;
public class ForumBbs
{
private String sql="";
private Connection con = null;
private ConnPool pool=new ConnPool();
private DateItem item;
public Vector getDateItem(){
Vector forumVector=new Vector();
try{
if (pool.getDriver()==null){
pool.setDriver("COM.ibm.db2.jdbc.net.DB2Driver");
pool.setURL("jdbc:db2://192.168.1.129/BBS");
pool.setUsername("ycg");
pool.setPassword("sntasve");
pool.setSize(55);
pool.initializePool();
}
con = pool.getConnection();
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=null;
sql="SELECT * FROM Board WHERE pareid=0";
rs=stmt.executeQuery(sql);
while (rs.next())
{
item=new DateItem();
item.setForum_id(rs.getString("Boardid"));
item.setBoardType(rs.getString("BoardType"));
forumVector.add(item);
item=null;
}
rs.close();
pool.releaseConnection(con);
return forumVector;
}catch (Exception e){
System.out.println(e.getMessage());
return null;
}
}
public Vector getDateItem2(String Forum_id1){
Vector forumVector2=new Vector();
try{
if (pool.getDriver()==null){
pool.setDriver("COM.ibm.db2.jdbc.net.DB2Driver");
pool.setURL("jdbc:db2://192.168.1.129/BBS");
pool.setUsername("ycg");
pool.setPassword("sntasve");
pool.setSize(55);
pool.initializePool();
}
con = pool.getConnection();
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=null;
sql="SELECT * FROM Board WHERE pareid="+Forum_id1;
rs=stmt.executeQuery(sql);
while (rs.next())
{
item=new DateItem();
item.setForum_id(rs.getString("Boardid"));
item.setBoardType(rs.getString("BoardType"));
forumVector2.add(item);
}
rs.close();
pool.releaseConnection(con);
return forumVector2;
}catch (Exception e){
System.out.println(e.getMessage());
return null;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -