public static List getKhfxInfo(String str, String khbzcode,String curPage) {
List list = new ArrayList();
Connection con = null;
con = configuration.getConnection();
String sqlcount="select count(*) from TBRT6102_KHFX" + "where 标准编号='" + khbzcode + "'" + str + "order by 考核项编号";
//String sqlcount="select count(*) from TBRT6102_KHFX where 0=0"+str;
String sql = "select 考核类别,考核项目,考核内容,标准分,赋分原则,备注,考核项编号 from TBRT6102_KHFX " +
"where 标准编号='" + khbzcode + "'" + str + "order by 考核项编号";
int count=0;
try {
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sqlcount);
while(rs.next())
count = rs.getInt(1);
Pagesplit page = new Pagesplit();
List resultlist = page.getPageResult(curPage, sql, count);
rs = (ResultSet)resultlist.get(0);
while (rs.next()) {
KhfxBean khfx = new KhfxBean();
khfx.setKhleibie(rs.getString(1));
khfx.setKhxiangmu(rs.getString(2));
khfx.setKhneirong(rs.getString(3));
khfx.setBiaozhunfen(rs.getInt(4));
khfx.setFfyz(rs.getString(5));
khfx.setBeizhu(rs.getString(6));
khfx.setKhxcode(rs.getString(7));
list.add(khfx); }
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public static int TotalRecKhfx(String str,String khbzcode)
{
int intpagecount=0;
//下面两句用于建立数据库的连接
Connection con = null;
con = configuration.getConnection();
String sqlCount="select count(*) from TBRT6102_KHFX" + "where 标准编号='" + khbzcode + "'" + str + "order by 考核项编号";
//String sqlCount="select count(*) from TBRT6102_KHFX where 0=0"+str;
try{
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sqlCount);
if(rs.next())
intpagecount=rs.getInt(1);
}
catch(Exception e)
{
e.printStackTrace();
}
return intpagecount;
}
解决方案 »
- 是否可以推荐一个和fck可以整合的批量上传插件
- Servelt带参跳转丢了参数是怎么情况?
- 高分求解 ajax实现下拉列表的动态双组合功能
- java文字编辑插件
- 线程死锁问题
- 读取数据库得到的结果由java生成xml格式发送到客户端。[主要是研究写一个通用的函数实现]
- 在servlet中怎么获得应用程序所在的目录?
- JAVASCRIPT与JSP一起使用的问题!
- learning jsp
- 安装jakarta-tomcat-4.0.2.exe后,访问http://localhost:8080/无反应?
- jsp上如何设置multibox的选择框变灰而文字不变灰?
- ibatis的sqlmap不太会写,帮忙看一下这个错误. 写order by 子句用变量处理出错
String sqlcount="select count(*) from TBRT6102_KHFX" + "where 标准编号='" + khbzcode + "'" + str + "order by 考核项编号";
String sql = "select 考核类别,考核项目,考核内容,标准分,赋分原则,备注,考核项编号 from TBRT6102_KHFX " +
"where 标准编号='" + khbzcode + "'" + str + "order by 考核项编号";