//根据页数+SQL条件查询留言信息
public Collection Select(int page, String sql) {
Collection coll = new ArrayList();
Connection con = null;
ResultSet rs = null;
PreparedStatement ps = null;
int tip = FinalConstants.STEP * (page - 1);
try {
con = Database.getConnection();
ps = con.prepareStatement(FinalConstants.SELECT_GUESTBOARD + sql);
rs = ps.executeQuery();
if (tip <= 0) {
rs.beforeFirst();
} else {
if (!rs.absolute(tip)) {
rs.beforeFirst();
}
} for (int i = 1; rs.next() && i <= FinalConstants.STEP; i++) {
Guestboard gb = new Guestboard();
gb.setGid(rs.getInt("gid"));
gb.setTitle(ParamUtils.getSqlString(rs.getString("title")));
gb.setGuest(ParamUtils.getSqlString(rs.getString("guest")));
gb.setGtime(ParamUtils.getSqlString(rs.getString("gtime")));
gb.setContent(ParamUtils.getSqlString(rs.getString("content")));
gb.setGflag(rs.getInt("gflag"));
gb.setRtime(ParamUtils.getSqlString(rs.getString("rtime")));
gb.setRecontent(ParamUtils.getSqlString(rs.getString("recontent")));
coll.add(gb);
}
} catch (SQLException ex) {
System.out.println(ex.getMessage());
} finally {
System.out.println(ps + " Dbguestboard.Select(int page,String sql) ");
try {
if (ps != null) {
ps.close();
ps = null;
}
} catch (SQLException e) {
ps = null;
}
try {
if (con != null) {
con.close();
con = null;
}
} catch (SQLException e) {
con = null;
}
}
return coll;
}
请问执行完IF语句RS指针指在哪一行,
(!rs.absolute(tip)) 是个条件
它会将指针移动到TIP行吗?
谢谢高手指点,
我想不明白!
public Collection Select(int page, String sql) {
Collection coll = new ArrayList();
Connection con = null;
ResultSet rs = null;
PreparedStatement ps = null;
int tip = FinalConstants.STEP * (page - 1);
try {
con = Database.getConnection();
ps = con.prepareStatement(FinalConstants.SELECT_GUESTBOARD + sql);
rs = ps.executeQuery();
if (tip <= 0) {
rs.beforeFirst();
} else {
if (!rs.absolute(tip)) {
rs.beforeFirst();
}
} for (int i = 1; rs.next() && i <= FinalConstants.STEP; i++) {
Guestboard gb = new Guestboard();
gb.setGid(rs.getInt("gid"));
gb.setTitle(ParamUtils.getSqlString(rs.getString("title")));
gb.setGuest(ParamUtils.getSqlString(rs.getString("guest")));
gb.setGtime(ParamUtils.getSqlString(rs.getString("gtime")));
gb.setContent(ParamUtils.getSqlString(rs.getString("content")));
gb.setGflag(rs.getInt("gflag"));
gb.setRtime(ParamUtils.getSqlString(rs.getString("rtime")));
gb.setRecontent(ParamUtils.getSqlString(rs.getString("recontent")));
coll.add(gb);
}
} catch (SQLException ex) {
System.out.println(ex.getMessage());
} finally {
System.out.println(ps + " Dbguestboard.Select(int page,String sql) ");
try {
if (ps != null) {
ps.close();
ps = null;
}
} catch (SQLException e) {
ps = null;
}
try {
if (con != null) {
con.close();
con = null;
}
} catch (SQLException e) {
con = null;
}
}
return coll;
}
请问执行完IF语句RS指针指在哪一行,
(!rs.absolute(tip)) 是个条件
它会将指针移动到TIP行吗?
谢谢高手指点,
我想不明白!
解决方案 »
- Java调CMD进程 关闭不了该CMD进程,求解决~~~~~~~~~~~~~
- 我在编写程序时用到org.jdesktop.layout.GroupLayout
- Math.cos(double a);方法好慢,如何快起来?
- 一个递归问题
- Runtime.getRuntime().exec(sCmd)问题
- 高手请进:求教servlet中的session和多线程问题
- 求指导,为什么我的程序没有办法实现题目的要求,总是报错呢?
- 请问JBuilder6.0在下,生成Application后,添加组件,如何改变其大小?那条属性?
- java子父类顺序问题
- apache做https代理服务器,可用浏览器上网,却不能用程序发送报文,求助大神啊,一周了都没搞定
- 为什么在main()方法里调用一个类里的static方法总是提示"找不到方法"?
- java 正则问题
con.prepareStatement(FinalConstants.SELECT_GUESTBOARD + sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);