public boolean update(T entity) { Connection connection = null; try { Integer result = 0; List<Object> sList = DBUtils.getInstance().createUpdateParam(getTableName(), entity, getTablePK()); String sql = sList.get(sList.size() - 1).toString(); System.out.println(sql); connection = DBManager.getConnection(); final PreparedStatement pst = connection.prepareStatement(sql); for (int i = 0; i < sList.size() - 1; i++) { setParam(pst, sList.get(i), i); } result = pst.executeUpdate(); pst.close(); if (result > 0) { return true; } } catch (Exception e) { // TODO: handle exception } finally { DBManager.freeConnection(connection); } return false; }
/** * 插入实体类返回自增长id * * @param entity * @return */ public Integer insertBackID(T entity) { Integer auto_id = -1; ResultSet rs = null; PreparedStatement pst = null; Connection connection = null; try { List<Object> sList = DBUtils.getInstance().createInsertParms(getTableName(), entity, getTablePK()); String sql = sList.get(sList.size() - 1).toString(); System.out.println(sql); connection = DBManager.getConnection(); pst = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS); for (int i = 0; i < sList.size() - 1; i++) { setParam(pst, sList.get(i), i); } pst.executeUpdate(); rs = pst.getGeneratedKeys(); if (rs.next()) { auto_id = rs.getInt(1); } rs.close(); pst.close(); } catch (Exception e) { e.printStackTrace(); // TODO: handle exception } finally { DBManager.freeConnection(connection); } return auto_id; }
public boolean delete(Integer id) { Connection connection = null; try { Integer result = 0; String sql = DBUtils.getInstance().createDelete(getTableName(), id, getTablePK()); connection = DBManager.getConnection(); final PreparedStatement pst = connection.prepareStatement(sql); result = pst.executeUpdate(); pst.close(); if (result > 0) { return true; } } catch (Exception e) { // TODO: handle exception } finally { DBManager.freeConnection(connection); } return false; }
/** * 插入数据 * * @param entity 实体类 * @return */ public boolean insert(T entity) { Connection connection = null; try { Integer result = 0; String sql = DBUtils.getInstance().createInsert(getTableName(), entity, getTablePK()); System.out.println("sql:" + sql); connection = DBManager.getConnection(); final PreparedStatement pst = connection.prepareStatement(sql); result = pst.executeUpdate(); if (result > 0) { return true; } pst.close(); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } finally { DBManager.freeConnection(connection); } return false; }
/** * 插入实体类返回自增长id * * @param entity * @return */ public Integer insertBackIDParms(T entity) { Integer auto_id = -1; ResultSet rs = null; PreparedStatement pst = null; Connection connection = null; try { String sql = DBUtils.getInstance().createInsert(getTableName(), entity, getTablePK()); System.out.println(sql); connection = DBManager.getConnection(); pst = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS); pst.executeUpdate(); rs = pst.getGeneratedKeys(); if (rs.next()) { auto_id = rs.getInt(1); } rs.close(); pst.close(); } catch (Exception e) { // TODO: handle exception } finally { DBManager.freeConnection(connection); } return auto_id; }
public void updateTran(T entity, Connection connection, Statement statement) throws SQLException { String sql = DBUtils.getInstance().createUpdate(getTableName(), entity, getTablePK()); statement.addBatch(sql); }