package com.vci.server.framework.systemConfig.stafforgmanage.passwordStrategy;
|
|
import java.sql.Connection;
|
import java.sql.PreparedStatement;
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import org.hibernate.HibernateException;
|
import org.hibernate.type.Type;
|
|
import com.vci.server.base.persistence.dao.BaseService;
|
import com.vci.server.base.persistence.dao.HibernateCallback;
|
import com.vci.server.base.persistence.dao.HibernateCallbackExt;
|
import com.vci.server.base.persistence.dao.HibernateTemplate;
|
import com.vci.server.base.persistence.dao.JDBCCallback;
|
import com.vci.server.base.persistence.dao.JDBCRunType;
|
import com.vci.server.base.persistence.dao.JDBCTemplate;
|
|
public class PasswordStrategyService extends BaseService{
|
|
public boolean savePasswordStrategy(final PasswordStrategy entity ) {
|
return (Boolean)new HibernateTemplate().runExt(new HibernateCallbackExt() {
|
public Object execute(Connection conn) throws HibernateException,
|
SQLException{
|
PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
|
String sql = "from PasswordStrategy ";
|
boolean isDefault = entity.getIsDefault();
|
List<PasswordStrategy> list = impl.findEntites(sql, new String[]{});
|
if(!isDefault) {
|
boolean isDef = false;
|
for(PasswordStrategy obj : list) {
|
if(obj.getIsDefault()) {
|
isDef = true;
|
break;
|
}
|
}
|
entity.setUserEntity(userEntity);
|
if(isDef) {
|
impl.saveOrUpdate(entity);
|
}else {
|
entity.setIsDefault(true);
|
impl.saveOrUpdate(entity);
|
}
|
|
}else {
|
for(PasswordStrategy obj : list) {
|
if(obj.getIsDefault()) {
|
String hsql = "update PasswordStrategy p set p.isDefault = 0 where p.id in ?";
|
impl.deleteQueryObject(hsql, new String[]{obj.getId()}, userEntity);
|
}
|
}
|
impl.saveOrUpdate(entity);
|
}
|
saveCombinationPasswordstrategy(conn,entity);
|
|
return true;
|
}
|
});
|
}
|
|
public boolean updatePasswordStrategy(final PasswordStrategy entity) {
|
return (Boolean)new HibernateTemplate().runExt(new HibernateCallbackExt() {
|
public Object execute(Connection conn) throws HibernateException,
|
SQLException{
|
PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
|
String sql = "from PasswordStrategy ";
|
PasswordStrategy info = impl.getById(entity.getId());
|
boolean isDefault = entity.getIsDefault();
|
List<PasswordStrategy> list = impl.findEntites(sql, new String[]{});
|
if(!isDefault) {
|
boolean isDef = false;
|
for(PasswordStrategy obj : list) {
|
if(obj.getIsDefault() && !(obj.getId().equals(entity.getId()))) {
|
isDef = true;
|
break;
|
}
|
}
|
if(isDef) {
|
}else {
|
info.setIsDefault(true);
|
}
|
|
}else {
|
for(PasswordStrategy obj : list) {
|
if(obj.getIsDefault() && !obj.getId().equals(entity.getId())) {
|
String hsql = "update PasswordStrategy p set p.isDefault = 0 where p.id in ?";
|
impl.deleteQueryObject(hsql, new String[]{obj.getId()}, userEntity);
|
}
|
}
|
info.setIsDefault(true);
|
}
|
info.setId(entity.getId());
|
info.setName(entity.getName());
|
info.setPasswordLen(entity.getPasswordLen());
|
info.setPasswordMaxLen(entity.getPasswordMaxLen());
|
info.setCharTypes(entity.getCharTypes());
|
info.setRequiredType(entity.getRequiredType());
|
info.setOverdueDay(entity.getOverdueDay());
|
info.setRemideDay(entity.getRemideDay());
|
info.setLockTime(entity.getLockTime());
|
info.setRetryTime(entity.getRetryTime());
|
info.setDesc(entity.getDesc());
|
info.setUserEntity(userEntity);
|
impl.saveOrUpdate(info);
|
|
//saveCombinationPasswordstrategy(conn,entity,combinationIds);
|
return true;
|
}
|
});
|
}
|
/**
|
* 创建密码策略和密码组合方式的关系
|
* <p>Description: </p>
|
*
|
* @author wangxl
|
* @time 2013-1-4
|
* @param conn
|
* @param entity
|
* @param combinationIds
|
*/
|
private void saveCombinationPasswordstrategy(Connection conn , PasswordStrategy entity){
|
String sql1 = "delete PLCOMBINATIONPASSWORDSTRATEGY ud where ud.PLPASSWORDSTRATEGYUID = ?";
|
PreparedStatement pstmt = null;
|
PreparedStatement pstmt1 = null;
|
try {
|
pstmt = conn.prepareStatement(sql1);
|
pstmt.setString(1, entity.getId());
|
pstmt.execute();
|
} catch (SQLException e1) {
|
e1.printStackTrace();
|
} finally {
|
if (pstmt != null){
|
try {
|
pstmt.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
// for (String combinationId : combinationIds){
|
// try {
|
// String hql = "insert into PLCOMBINATIONPASSWORDSTRATEGY values (? , ?)";
|
// pstmt1 = conn.prepareStatement(hql);
|
// pstmt1.setString(1, entity.getId());
|
// pstmt1.setString(2, combinationId);
|
|
// pstmt1.execute();
|
// }catch (SQLException e1) {
|
// e1.printStackTrace();
|
// } finally {
|
// if (pstmt1 != null){
|
// try {
|
// pstmt1.close();
|
// } catch (SQLException e) {
|
// e.printStackTrace();
|
// }
|
// }
|
// }
|
// }
|
}
|
|
public PasswordStrategy getPasswordStrBysecrtId(final String secretId) {
|
return (PasswordStrategy)new HibernateTemplate().run(new HibernateCallback() {
|
public Object execute() throws HibernateException {
|
PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
|
String hql = "select {u.*} from PPASSWORDSTRATEGY u where u.puid in(select o.PPWSTATEGYID from PSECRETSTATEGY o where o.PSECRETID=?) order by u.pname ";
|
Object[] values = new Object[1];
|
values[0] = secretId;
|
List<PasswordStrategy> list = impl.findEntites(hql, values, "u", PasswordStrategy.class);
|
if(list.size() > 0) {
|
return list.get(0);
|
}
|
return new PasswordStrategy();
|
}
|
});
|
}
|
public PasswordStrategy getPasswordObjByName(final String name) {
|
return (PasswordStrategy)new HibernateTemplate().run(new HibernateCallback() {
|
public Object execute() throws HibernateException {
|
PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
|
String hql = "select {u.*} from PLPASSWORDSTRATEGY u where u.pname=?";
|
Object[] values = new Object[1];
|
values[0] = name;
|
List<PasswordStrategy> list = impl.findEntites(hql, values, "u", PasswordStrategy.class);
|
if(list.size() > 0) {
|
return list.get(0);
|
}else {
|
return null;
|
}
|
}
|
});
|
}
|
public PasswordStrategy getPasswordObjByUserId(final String userId) {
|
return (PasswordStrategy)new HibernateTemplate().run(new HibernateCallback() {
|
public Object execute() throws HibernateException {
|
PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
|
String hql = "select {u.*} from PLPASSWORDSTRATEGY u where u.PLUID in(select o.PLPASSWORDSTRATEGYUID from PLUSERPASSWORDSTRATEGY o where o.pluseruid = ?) order by u.PNAME ";
|
Object[] values = new Object[1];
|
values[0] = userId;
|
List<PasswordStrategy> list = impl.findEntites(hql, values, "u", PasswordStrategy.class);
|
if(list.size() > 0) {
|
return list.get(0);
|
}else {
|
String sql = "from PasswordStrategy u where u.isDefault =1";
|
return impl.findEntity(sql);
|
}
|
}
|
});
|
}
|
public List getPasswordObjById(final String id) {
|
return (List)new HibernateTemplate().run(new HibernateCallback() {
|
public Object execute() throws HibernateException {
|
PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
|
String hsql = " from PasswordStrategy u where u.id = '"+id+"'";
|
return impl.findEntities(hsql);
|
}
|
});
|
}
|
@SuppressWarnings("unchecked")
|
public List<PasswordStrategy> getPasswordStrategyList() {
|
return (List)new HibernateTemplate().run(new HibernateCallback() {
|
public Object execute() throws HibernateException {
|
PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
|
String sql = "from PasswordStrategy p order by p.name";
|
return impl.findEntities(sql);
|
|
}
|
});
|
}
|
|
@SuppressWarnings("unchecked")
|
public List<PasswordStrategy> getPasswordStrategyList(final int pageNo,final int pageSize) {
|
return (List)new HibernateTemplate().run(new HibernateCallback() {
|
public Object execute() throws HibernateException {
|
PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
|
|
int V_PAGE_ROWNUM_START = (pageNo - 1) * pageSize;
|
int V_PAGE_ROWNUM_END = (pageNo ) * pageSize;
|
|
StringBuffer sb = new StringBuffer();
|
sb.append(" SELECT * ");
|
sb.append(" FROM (SELECT ROW_.*, ROWNUM RN ");
|
sb.append(" FROM (SELECT * from PLPASSWORDSTRATEGY R ");
|
sb.append(" ORDER BY R.PNAME )");
|
sb.append(" ROW_)");
|
sb.append(" WHERE RN <= ");
|
sb.append( V_PAGE_ROWNUM_END);
|
sb.append(" AND RN > ");
|
sb.append(V_PAGE_ROWNUM_START);
|
|
Object[] values = new Object[0];
|
List<PasswordStrategy> list = impl.findEntites(sb.toString(), values, "R", PasswordStrategy.class);
|
return list;
|
|
}
|
});
|
}
|
|
/***查询密码策略总数*/
|
public int getPasswordStrategyTotal() {
|
int res = 0;
|
String sql = "SELECT COUNT(*) FROM PLPASSWORDSTRATEGY ";
|
res = (Integer)new JDBCTemplate().run(new JDBCCallback(
|
new HibernateTemplate().getSessionConnection(),
|
sql, JDBCRunType.SQL, 0, false, false,new Object[]{}) {
|
@Override
|
public Object execute(ResultSet rst) throws SQLException {
|
int ress = 0;
|
while(rst.next()){
|
ress = rst.getInt(1);
|
|
}
|
return ress;
|
}
|
});
|
return res;
|
}
|
|
public boolean deletePasswordStrategyById(final String id) {
|
return (Boolean)new HibernateTemplate().run(new HibernateCallback() {
|
public Object execute() throws HibernateException {
|
PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
|
PasswordStrategy entity = impl.getById(id);
|
entity.setUserEntity(userEntity);
|
impl.delete(entity);
|
return true;
|
}
|
});
|
}
|
|
public int checkPasswordStrategyIsquotedCount(final String id ){
|
return (Integer)new HibernateTemplate().run(new HibernateCallback() {
|
public Object execute() throws HibernateException {
|
int count = 0;
|
PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
|
String hsql = "select count(*) from PLUSERPASSWORDSTRATEGY ps where ps.PLPASSWORDSTRATEGYUID = '"+id+"'";
|
List list = new ArrayList();
|
Object[] values = new Object[0];
|
Map<String,Type> map = new HashMap<String,Type>();
|
list = impl.findEntitesBySQL(hsql, values,map);
|
for (int i = 0 ; i < list.size(); i ++){
|
count += Integer.valueOf(String.valueOf(list.get(i))).intValue();
|
}
|
return count;
|
}
|
});
|
}
|
|
}
|
