java 数据库操作报错?报错

代码比较多。贴一些关键的出来。

DBcon db = new DBcon(); Connection con=null; Statement stmt=null; PreparedStatement pstmt = null; ResultSet rs=null; try { con = db.getConnection(); stmt = con.createStatement();

sql = "select c_id,c_sid,c_jid,c_dtype,c_fee,c_text,c_userid,c_ip,c_appdate,c_retext,c_redate,c_enable,c_adm,c_check from t_dianping where c_appdate>='"
+stime+"' and c_appdate<='"+etime+" 23:59:00' "+whereSql+" order by c_id desc";

//System.out.println(sql);

DataTurnPage tp = new DataTurnPage();
//		@return n*m 1 sql语句 2 本页显示条数 3 第几页
tp.selectTurnPage(sql,shownum,pagenow);

List s = new ArrayList();
s = tp.getRes();			//获得结果集
pagenum = tp.getPagenum();	//获得总页数
count = tp.getCount();		//获得总记录数

//获得结果集字段
Object[] obj = null;
    for (int i = 0; i < s.size(); i++) {
	obj = (Object[]) s.get(i);
            //...这里省略一部分代码，就是从结果集数据中取数据的代码
            //查
	sql = "select c_sname,c_id from t_shops where c_id="
				+ c_sname + " ";
	rs = stmt.executeQuery(sql);
	if (rs.next()) {
		c_sname = rs.getString(1);
		if (c_sname.length() > 8)
		c_sname = c_sname.substring(0, 8) + ".";
             }
	rs.close();
            if (Tools.isNumber(c_area) > 0) {
                    //查劵
		sql = "select c_titles from t_juan where  c_id="+ c_area + " ";
		rs = stmt.executeQuery(sql);
		if (rs.next()) {
			c_sname = rs.getString(1);
			if (c_sname.length() > 8)
				c_sname =   c_sname.substring(0, 8) + ".";

} rs.close(); } } } catch (Exception e) { System.out.println("Exception :" + e); e.printStackTrace();

} finally {
	if (stmt != null) {
		stmt.close();
	}
	if (pstmt != null) {
		pstmt.close();
	}
	if (con != null) {
		con.close();
	}