jixiao.zip_blxxop_hibernate_jsp_绩效 网站_考核

// Decompiler options: packimports(3) // Source File Name: jsxxop.java package mypackage; import java.io.PrintStream; import java.sql.ResultSet; import java.util.ArrayList; import java.sql.ResultSet; // Referenced classes of package mypackage: // DB, jsxx public class jxxxop { public jxxxop() { } public void add(String uid, String time, String sp, String tp, String spmoney, String tpmoney) { String sql = ""; System.out.println("-----------------------11111111111111111111---------------------"); try { DB db = new DB(); sql = "insert into jixiao(uid,time,sp,tp,spmoney,tpmoney)"; sql = (new StringBuilder(String.valueOf(sql))).append(" values('").append(uid).append("','").append(time).append("','").append(sp).append("','").append(tp).append("','").append(spmoney).append("','").append(tpmoney).append("')").toString(); db.executeUpdate(sql); db.close(); } catch(Exception e) { System.err.println((new StringBuilder("\u589E\u52A0\u6559\u5E08\u4FE1\u606F\u9519\u8BEF\uFF0C\u9519\u8BEF\u4FE1\u606F\uFF1A")).append(e.getMessage()).toString()); } } public void update(String uid, String time, String sp, String tp, String spmoney, String tpmoney) { DB db = new DB(); System.out.println("-----------------------222222222222222222222222---------------------"); try { String sql = (new StringBuilder("update jixiao set uid='")).append(uid).append("',time='").append(time).append("',sp='").append(sp).append("',tp='").append(tp).append("',spmoney='").append(spmoney).append("',tpmoney='").append(tpmoney).append("' where uid = '").append(uid).append("'").append("and time = '").append(time).append("'").toString(); db.executeUpdate(sql); db.close(); } catch(Exception e) { System.err.println((new StringBuilder("\u6559\u5E08\u4FE1\u606F\u66F4\u65B0\u9519\u8BEF\uFF0C\u9519\u8BEF\u4FE1\u606F\uFF1A")).append(e.getMessage()).toString()); } } public void delete(String uid,String time) { DB db = new DB(); try { String sql = (new StringBuilder("delete from jixiao where uid='")).append(uid).append("'").append("and time = '").append(time).append("'").toString(); db.executeUpdate(sql); db.close(); } catch(Exception e) { System.err.println((new StringBuilder("\u5220\u9664\u6559\u5E08\u4FE1\u606F\u5931\u8D25\uFF0C\u9519\u8BEF\u4FE1\u606F\uFF1A")).append(e.getMessage()).toString()); } } public ArrayList getJxxxall() { ArrayList al = new ArrayList(); String sql = ""; try { DB db = new DB(); sql = "select * from jixiao "; ResultSet rs; jxxx js; for(rs = db.executeQuery(sql); rs.next(); al.add(js)) { js = new jxxx(); js.setUid(rs.getString("uid")); js.setTime(rs.getString("time")); js.setSp(rs.getString("sp")); js.setTp(rs.getString("tp")); js.setSpmoney(rs.getString("spmoney")); js.setTpmoney(rs.getString("tpmoney")); } if(rs != null) { rs.close(); rs = null; } db.close(); } catch(Exception e) { System.err.println((new StringBuilder("\u8BFB\u53D6\u623F\u6559\u5E08\u4FE1\u606F\u5931\u8D25\uFF0C\u9519\u8BEF\u4FE1\u606F\uFF1A")).append(e.getMessage()).toString()); } return al; } ///////////////////////////////////////////////////////////////////////////////////////////////////////// public ArrayList getJxxxall2() { ArrayList al = new ArrayList(); String sql = ""; try { DB db = new DB(); sql = "select * FROM jixiao group by time"; ResultSet rs; jxxx js; for(rs = db.executeQuery(sql); rs.next(); al.add(js)) { js = new jxxx(); js.setTime(rs.getString("time")); } if(rs != null) { rs.close(); rs = null; } db.close(); } catch(Exception e) { System.err.println((new StringBuilder("\u8BFB\u53D6\u623F\u6559\u5E08\u4FE1\u606F\u5931\u8D25\uFF0C\u9519\u8BEF\u4FE1\u606F\uFF1A")).append(e.getMessage()).toString()); } return al; } public ArrayList getJxxxall3(String time) { ArrayList al = new ArrayList(); String sql = ""; try { DB db = new DB(); sql = "select * FROM jixiao where time = "+time+" group by time"; ResultSet rs; jxxx js; for(rs = db.executeQuery(sql); rs.next(); al.add(js)) { js = new jxxx(); js.setTime(rs.getString("time")); } if(rs != null) { rs.close(); rs = null; } db.close(); } catch(Exception e) { System.err.println((new StringBuilder("\u8BFB\u53D6\u623F\u6559\u5E08\u4FE1\u606F\u5931\u8D25\uFF0C\u9519\u8BEF\u4FE1\u606F\uFF1A")).append(e.getMessage()).toString()); } return al; } /////////////////////////////////////////////////////////////////////////////////////////////////////////// public ArrayList getJxxxBytime(String uid,String time) { ArrayList al = new ArrayList(); String sql = ""; try { DB db = new DB(); sql = (new StringBuilder("select * from jixiao where uid='")).append(uid).append("'").append("and time = '").append(time).append("'").toString(); ResultSet rs; jxxx js; for(rs = db.executeQuery(sql); rs.next(); al.add(js)) { js = new jxxx(); js.setUid(rs.getString("uid")); js.setTime(rs.getString("time")); js.setSp(rs.getString("sp")); js.setTp(rs.getString("tp")); js.setSpmoney(rs.getString("spmoney")); js.setTpmoney(rs.getString("tpmoney")); } if(rs != null) { rs.close(); rs = null; } db.close(); } catch(Exception e) { System.err.println((new StringBuilder("\u8BFB\u53D6\u623F\u6559\u5E08\u4FE1\u606F\u5931\u8D25\uFF0C\u9519\u8BEF\u4FE1\u606F\uFF1A")).append(e.getMessage()).toString()); } return al; } /////////////////////////////////////////////////////////////////////////////////////// //public ArrayList getJxxxBytime2(String time){ // ArrayList al = new ArrayList(); // String sql = ""; // String username = ""; // username =(String)session.getAttribute("s_username"); // System.out.println("----------------"); // // try // { // DB db = new DB(); // sql = (new StringBuilder("select * from jixiao where uid='")).append(username).append("'").append("and time = '").append(time).append("'").toString(); // // ResultSet rs; // jxxx js; // for(rs = db.executeQuery(sql); rs.next(); al.add(js)) // { // js = new jxxx(); // js.s