相关的maven的 pom.xml
1 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 2 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> 3 <modelVersion>4.0.0</modelVersion> 4 <groupId>cn.com.cisec.vcs</groupId> 5 <artifactId>VCS</artifactId> 6 <packaging>war</packaging> 7 <version>0.0.1-SNAPSHOT</version> 8 <name>VCS Maven Webapp</name> 9 <url>http://maven.apache.org</url> 10 <dependencies> 11 <dependency> 12 <groupId>org.apache.maven.plugins</groupId> 13 <artifactId>maven-resources-plugin</artifactId> 14 <version>2.6</version> 15 </dependency> 16 <dependency> 17 <groupId>junit</groupId> 18 <artifactId>junit</artifactId> 19 <version>3.8.1</version> 20 <scope>test</scope> 21 </dependency> 22 <!-- SpringMVC核心jar --> 23 <dependency> 24 <groupId>org.springframework</groupId> 25 <artifactId>spring-context</artifactId> 26 <version>4.0.2.RELEASE</version> 27 </dependency> 28 <dependency> 29 <groupId>org.springframework</groupId> 30 <artifactId>spring-tx</artifactId> 31 <version>4.0.2.RELEASE</version> 32 </dependency> 33 <dependency> 34 <groupId>org.springframework</groupId> 35 <artifactId>spring-webmvc</artifactId> 36 <version>4.0.2.RELEASE</version> 37 </dependency> 38 <dependency> 39 <groupId>org.springframework</groupId> 40 <artifactId>spring-core</artifactId> 41 <version>4.0.2.RELEASE</version> 42 </dependency> 43 <dependency> 44 <groupId>org.springframework</groupId> 45 <artifactId>spring-web</artifactId> 46 <version>4.0.2.RELEASE</version> 47 </dependency> 48 <dependency> 49 <groupId>org.springframework</groupId> 50 <artifactId>spring-orm</artifactId> 51 <version>4.0.2.RELEASE</version> 52 </dependency> 53 <dependency> 54 <groupId>org.springframework.security</groupId> 55 <artifactId>spring-security-core</artifactId> 56 <version>3.2.1.RELEASE</version> 57 </dependency> 58 <dependency> 59 <groupId>org.springframework.security</groupId> 60 <artifactId>spring-security-web</artifactId> 61 <version>3.2.1.RELEASE</version> 62 </dependency> 63 <dependency> 64 <groupId>org.springframework.security</groupId> 65 <artifactId>spring-security-config</artifactId> 66 <version>3.2.1.RELEASE</version> 67 </dependency> 68 <dependency> 69 <groupId>org.springframework.security</groupId> 70 <artifactId>spring-security-taglibs</artifactId> 71 <version>3.2.1.RELEASE</version> 72 </dependency> 73 <dependency> 74 <groupId>org.springframework</groupId> 75 <artifactId>spring-aspects</artifactId> 76 <version>4.0.2.RELEASE</version> 77 </dependency> 78 <dependency> 79 <groupId>org.springframework</groupId> 80 <artifactId>spring-beans</artifactId> 81 <version>4.0.2.RELEASE</version> 82 </dependency> 83 <dependency> 84 <groupId>org.springframework</groupId> 85 <artifactId>spring-context-support</artifactId> 86 <version>4.0.2.RELEASE</version> 87 </dependency> 88 <dependency> 89 <groupId>org.springframework</groupId> 90 <artifactId>spring-expression</artifactId> 91 <version>4.0.2.RELEASE</version> 92 </dependency> 93 <dependency> 94 <groupId>org.springframework</groupId> 95 <artifactId>spring-jdbc</artifactId> 96 <version>4.0.2.RELEASE</version> 97 </dependency> 98 <dependency> 99 <groupId>org.springframework</groupId> 100 <artifactId>spring-test</artifactId> 101 <version>4.0.2.RELEASE</version> 102 <scope>test</scope> 103 </dependency> 104 <!-- ************************************ --> 105 <dependency> 106 <groupId>org.codehaus.jackson</groupId> 107 <artifactId>jackson-mapper-asl</artifactId> 108 <version>1.9.13</version> 109 </dependency> 110 <dependency> 111 <groupId>org.aspectj</groupId> 112 <artifactId>aspectjrt</artifactId> 113 <version>1.7.4</version> 114 </dependency> 115 <dependency> 116 <groupId>org.aspectj</groupId> 117 <artifactId>aspectjtools</artifactId> 118 <version>1.7.4</version> 119 </dependency> 120 <!-- Hibernate相关jar --> 121 <dependency> 122 <groupId>fr.inria.powerapi.sensor</groupId> 123 <artifactId>sensor-sigar</artifactId> 124 <version>1.5</version> 125 </dependency> 126 <dependency> 127 <groupId>net.sf.ehcache</groupId> 128 <artifactId>ehcache</artifactId> 129 <version>2.7.2</version> 130 </dependency> 131 <dependency> 132 <groupId>commons-dbcp</groupId> 133 <artifactId>commons-dbcp</artifactId> 134 <version>1.4</version> 135 </dependency> 136 <dependency> 137 <groupId>mysql</groupId> 138 <artifactId>mysql-connector-java</artifactId> 139 <version>5.1.26</version> 140 </dependency> 141 <!-- javax提供的annotation --> 142 <dependency> 143 <groupId>javax.inject</groupId> 144 <artifactId>javax.inject</artifactId> 145 <version>1</version> 146 </dependency> 147 <!-- **************************** --> 148 149 <!-- hibernate验证 --> 150 <dependency> 151 <groupId>org.hibernate</groupId> 152 <artifactId>hibernate-core</artifactId> 153 <version>4.3.6.Final</version> 154 </dependency> 155 <dependency> 156 <groupId>org.hibernate.common</groupId> 157 <artifactId>hibernate-commons-annotations</artifactId> 158 <version>4.0.5.Final</version> 159 </dependency> 160 <dependency> 161 <groupId>org.hibernate</groupId> 162 <artifactId>hibernate-entitymanager</artifactId> 163 <version>4.3.6.Final</version> 164 </dependency> 165 <dependency> 166 <groupId>org.hibernate.javax.persistence</groupId> 167 <artifactId>hibernate-jpa-2.1-api</artifactId> 168 <version>1.0.0.Final</version> 169 </dependency> 170 <dependency> 171 <groupId>org.hibernate</groupId> 172 <artifactId>hibernate-ehcache</artifactId> 173 <version>4.3.6.Final</version> 174 </dependency> 175 <dependency> 176 <groupId>org.hibernate</groupId> 177 <artifactId>hibernate-validator</artifactId> 178 <version>5.1.2.Final</version> 179 </dependency> 180 <dependency> 181 <groupId>com.mchange</groupId> 182 <artifactId>c3p0</artifactId> 183 <version>0.9.5-pre8</version> 184 </dependency> 185 <!-- 提供对c标签的支持 --> 186 <dependency> 187 <groupId>javax.servlet</groupId> 188 <artifactId>jstl</artifactId> 189 <version>1.2</version> 190 </dependency> 191 <!-- servlet api --> 192 <dependency> 193 <groupId>javax.servlet</groupId> 194 <artifactId>servlet-api</artifactId> 195 <version>2.5</version> 196 <scope>provided</scope> 197 </dependency> 198 <dependency> 199 <groupId>org.apache.httpcomponents</groupId> 200 <artifactId>httpclient</artifactId> 201 <version>4.3.6</version> 202 </dependency> 203 <dependency> 204 <groupId>javax.servlet.jsp</groupId> 205 <artifactId>jsp-api</artifactId> 206 <version>2.1</version> 207 <scope>provided</scope> 208 </dependency> 209 <!-- json字符串的包 --> 210 <dependency> 211 <groupId>commons-collections</groupId> 212 <artifactId>commons-collections</artifactId> 213 <version>3.2.1</version> 214 </dependency> 215 <dependency> 216 <groupId>net.sf.ezmorph</groupId> 217 <artifactId>ezmorph</artifactId> 218 <version>1.0.6</version> 219 </dependency> 220 <dependency> 221 <groupId>net.sf.json-lib</groupId> 222 <artifactId>json-lib</artifactId> 223 <version>2.4</version> 224 </dependency> 225 <!--Apache Shiro所需的jar包--> 226 <dependency> 227 <groupId>org.apache.shiro</groupId> 228 <artifactId>shiro-core</artifactId> 229 <version>1.2.3</version> 230 </dependency> 231 <dependency> 232 <groupId>org.apache.shiro</groupId> 233 <artifactId>shiro-web</artifactId> 234 <version>1.2.3</version> 235 </dependency> 236 <dependency> 237 <groupId>org.apache.shiro</groupId> 238 <artifactId>shiro-spring</artifactId> 239 <version>1.2.3</version> 240 </dependency> 241 <dependency> 242 <groupId>org.apache.shiro</groupId> 243 <artifactId>shiro-ehcache</artifactId> 244 <version>1.2.3</version> 245 </dependency> 246 <dependency> 247 <groupId>commons-io</groupId> 248 <artifactId>commons-io</artifactId> 249 <version>2.4</version> 250 </dependency> 251 <dependency> 252 <groupId>commons-beanutils</groupId> 253 <artifactId>commons-beanutils</artifactId> 254 <version>1.8.3</version> 255 </dependency> 256 <dependency> 257 <groupId>commons-fileupload</groupId> 258 <artifactId>commons-fileupload</artifactId> 259 <version>1.3.1</version> 260 </dependency> 261 <dependency> 262 <groupId>commons-lang</groupId> 263 <artifactId>commons-lang</artifactId> 264 <version>2.6</version> 265 </dependency> 266 <dependency> 267 <groupId>commons-logging</groupId> 268 <artifactId>commons-logging</artifactId> 269 <version>1.1.2</version> 270 </dependency> 271 <dependency> 272 <groupId>org.slf4j</groupId> 273 <artifactId>slf4j-log4j12</artifactId> 274 <version>1.7.5</version> 275 </dependency> 276 <dependency> 277 <groupId>asm</groupId> 278 <artifactId>asm</artifactId> 279 <version>3.3.1</version> 280 </dependency> 281 <dependency> 282 <groupId>org.aspectj</groupId > 283 <artifactId>aspectjweaver</artifactId > 284 <version> 1.6.11</version > 285 </dependency> 286 <dependency> 287 <groupId>com.google.code.gson</groupId> 288 <artifactId>gson</artifactId> 289 <version>2.2.4</version> 290 </dependency> 291 </dependencies> 292 <build> 293 <finalName>VCS</finalName> 294 <plugins> 295 <plugin> 296 <groupId>org.apache.maven.plugins</groupId> 297 <artifactId>maven-compiler-plugin</artifactId> 298 <version>2.3</version> 299 <configuration> 300 <source>1.6</source> 301 <target>1.6</target> 302 </configuration> 303 </plugin> 304 <plugin> 305 <artifactId>maven-war-plugin</artifactId> 306 <configuration> 307 <version>2.2</version> 308 </configuration> 309 </plugin> 310 <plugin> 311 <groupId>org.eclipse.jetty</groupId> 312 <artifactId>jetty-maven-plugin</artifactId> 313 <version>9.3.0.M1</version> 314 <configuration> 315 <scanIntervalSeconds>10</scanIntervalSeconds> 316 <webApp> 317 <contextPath>/VCS</contextPath> 318 </webApp> 319 </configuration> 320 </plugin> 321 <!-- <plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> 322 <version>2.0-SNAPSHOT</version> <configuration> <url>http://localhost:8080/controlserver</url> 323 <server>Tomcat 7.x</server> </configuration> </plugin> --> 324 </plugins> 325 </build> 326 </project>
基础的java代码：
1 package com.etop.basic.controller; 2 3 import com.etop.utils.DateUtils; 4 5 import org.apache.log4j.Logger; 6 import org.springframework.stereotype.Controller; 7 import org.springframework.ui.Model; 8 import org.springframework.web.bind.WebDataBinder; 9 import org.springframework.web.bind.annotation.ExceptionHandler; 10 import org.springframework.web.bind.annotation.InitBinder; 11 import org.springframework.web.servlet.mvc.support.RedirectAttributes; 12 13 import javax.servlet.http.HttpServletRequest; 14 15 import java.beans.PropertyEditorSupport; 16 import java.util.Date; 17 18 /** 19 * @类名: BaseController 20 * @描述: TODO(这里用一句话描述这个类的作用) 21 * @作者 liuren-mail@163.com 22 * @日期 2015年5月20日 下午3:11:32 23 */ 24 @Controller 25 public abstract class BaseController { 26 27 public final static String ERROR = "error"; 28 public final static String SUCCESS = "success"; 29 30 protected Logger log = Logger.getLogger(this.getClass()); 31 32 /** 33 * 添加Model消息 34 * 35 * @param messages 36 */ 37 protected void addMessage(Model model, String messages) { 38 model.addAttribute("message", messages); 39 } 40 41 /** 42 * 添加Model消息 43 * 44 * @param type 45 * 消息类型 46 * @param messages 47 */ 48 protected void addMessage(Model model, String type, String messages) { 49 model.addAttribute("message", messages); 50 model.addAttribute("type", type); 51 } 52 53 /** 54 * 添加Flash消息 55 * 56 * @param messages 57 */ 58 protected void addMessage(RedirectAttributes redirectAttributes, 59 String messages) { 60 redirectAttributes.addFlashAttribute("message", messages); 61 } 62 63 /** 64 * 添加Flash消息 65 * 66 * @param type 67 * 消息类型 68 * @param messages 69 */ 70 protected void addMessage(RedirectAttributes redirectAttributes, 71 String type, String messages) { 72 redirectAttributes.addFlashAttribute("message", messages); 73 redirectAttributes.addFlashAttribute("type", type); 74 } 75 76 /** 77 * 初始化数据绑定 1. 将所有传递进来的String进行HTML编码，防止XSS攻击 2. 将字段中Date类型转换为String类型 78 */ 79 @InitBinder 80 protected void initBinder(WebDataBinder binder) { 81 // String类型转换，将所有传递进来的String进行HTML编码，防止XSS攻击 82 binder.registerCustomEditor(String.class, new PropertyEditorSupport() { 83 @Override 84 public void setAsText(String text) { 85 // setValue(text == null ? null : 86 // StringEscapeUtils.escapeHtml(text.trim())); 87 setValue(text == null ? null : text.trim()); 88 } 89 90 @Override 91 public String getAsText() { 92 Object value = getValue(); 93 return value != null ? value.toString() : ""; 94 } 95 }); 96 // Date 类型转换 97 binder.registerCustomEditor(Date.class, new PropertyEditorSupport() { 98 @Override 99 public void setAsText(String text) { 100 setValue(DateUtils.parseDate(text)); 101 } 102 }); 103 } 104 105 @ExceptionHandler(Exception.class) 106 public String handleException(Exception ex, HttpServletRequest request) { 107 log.error("系统发生异常", ex); 108 ex.printStackTrace(); 109 request.setAttribute("exMsg", ex.getMessage()); 110 return "errors/exception"; 111 } 112 }
1 package com.etop.basic.dao; 2 3 import org.apache.log4j.Logger; 4 import org.hibernate.Query; 5 import org.hibernate.SQLQuery; 6 import org.hibernate.Session; 7 import org.hibernate.SessionFactory; 8 import org.hibernate.StatelessSession; 9 import org.hibernate.transform.Transformers; 10 import org.springframework.beans.factory.annotation.Autowired; 11 import org.springframework.dao.DataAccessException; 12 import com.etop.utils.PageUtil; 13 import com.etop.utils.ThreadLocalUtils; 14 15 import java.io.Serializable; 16 import java.lang.reflect.ParameterizedType; 17 import java.math.BigInteger; 18 import java.util.Collection; 19 import java.util.List; 20 import java.util.Map; 21 import java.util.Set; 22 23 /** 24 * @类名: BaseDAO 25 * @描述: TODO(这里用一句话描述这个类的作用) 26 * @作者 liuren-mail@163.com 27 * @日期 2015年5月20日 下午3:12:00 28 * @param <T> 29 */ 30 public class BaseDAO<T> implements Serializable { 31 32 protected transient Logger log = Logger.getLogger(this.getClass()); 33 @Autowired 34 private SessionFactory sessionFactory; 35 private Class<T> persistentClass; 36 37 protected Class<T> getCurClass() { 38 if (persistentClass == null) { 39 this.persistentClass = (Class<T>) ((ParameterizedType) getClass() 40 .getGenericSuperclass()).getActualTypeArguments()[0]; 41 } 42 return persistentClass; 43 } 44 45 protected Session getSession() { 46 return sessionFactory.getCurrentSession(); 47 } 48 49 protected StatelessSession getStatelessSession() { 50 return sessionFactory.openStatelessSession(); 51 } 52 53 public void flush() { 54 getSession().flush(); 55 } 56 57 public void evict(T entity) { 58 getSession().evict(entity); 59 } 60 61 public T get(long id) throws DataAccessException { 62 log.debug("DAO:Get entity " + getCurClass().getSimpleName() + ":Id=" 63 + id); 64 return (T) getSession().get(getCurClass(), id); 65 } 66 67 public void save(T entity) throws DataAccessException { 68 log.debug("DAO:Save entity " + entity.getClass().getSimpleName()); 69 getSession().save(entity); 70 } 71 72 public void update(T entity) throws DataAccessException { 73 log.debug("DAO:Update entity " + entity.getClass().getSimpleName()); 74 getSession().clear(); 75 getSession().update(entity); 76 } 77 78 public void saveOrUpdate(T entity) throws DataAccessException { 79 log.debug("DAO:Sava or Update entity " 80 + entity.getClass().getSimpleName()); 81 getSession().clear(); 82 getSession().saveOrUpdate(entity); 83 } 84 85 public void delete(T entity) throws DataAccessException { 86 log.debug("DAO:delete entity " + getCurClass().getSimpleName()); 87 getSession().delete(entity); 88 } 89 90 public void deleteById(long id) throws DataAccessException { 91 log.debug("DAO:delete entity " + getCurClass().getSimpleName() + ":Id=" 92 + id); 93 String queryString = "delete from " + getCurClass().getSimpleName() 94 + " where id=" + id; 95 this.excute(queryString); 96 } 97 98 public int excute(String queryString) throws DataAccessException { 99 log.debug("DAO:Excute HQL update :" + queryString); 100 Query query = getSession().createQuery(queryString); 101 return query.executeUpdate(); 102 } 103 104 public List<T> find(String queryString) throws DataAccessException { 105 log.debug("DAO:Running HQL query :" + queryString); 106 Query query = getSession().createQuery(queryString); 107 query.setCacheable(true); 108 return query.list(); 109 } 110 111 private Query createQuery(String queryString, Map<String, Object> params, 112 int startRow, int pageSize) { 113 Query query = getSession().createQuery(queryString); 114 if (params != null) { 115 for (Map.Entry<String, Object> entry : params.entrySet()) { 116 String paramName = entry.getKey(); 117 Object obj = entry.getValue(); 118 log.info("DAO:set param:" + paramName + " with value:" + obj); 119 if (obj instanceof List) { 120 query.setParameterList(paramName, (Collection) obj); 121 } else if (obj instanceof Object[]) { 122 query.setParameterList(paramName, (Object[]) obj); 123 } else { 124 query.setParameter(paramName, obj); 125 } 126 } 127 } 128 query.setCacheable(true); 129 if (pageSize != -1) { 130 query.setFirstResult(startRow).setMaxResults(pageSize); 131 } 132 return query; 133 } 134 135 private Query createQuery(String queryString) { 136 return createQuery(queryString, null, 0, -1); 137 } 138 139 private Query createQuery(String queryString, Map<String, Object> params) { 140 return createQuery(queryString, params, 0, -1); 141 } 142 143 public List<T> find(String queryString, int startRow, int pageSize) 144 throws DataAccessException { 145 log.debug("DAO:Running HQL query by page:" + queryString); 146 Query query = createQuery(queryString, null, startRow, pageSize); 147 return query.list(); 148 } 149 150 public int getTotalCount(String queryString) throws DataAccessException { 151 return getTotalCount(queryString, null); 152 } 153 154 public int getTotalCount(String queryString, Map<String, Object> params) 155 throws DataAccessException { 156 log.debug("DAO:Running HQL query for total count of records :" 157 + queryString); 158 queryString = "select count(t.id) " + queryString; 159 Query query; 160 if (params != null) { 161 query = createQuery(queryString, params); 162 } else { 163 query = createQuery(queryString); 164 } 165 return ((Long) query.uniqueResult()).intValue(); 166 } 167 168 public List findWithSelect(String queryString) throws DataAccessException { 169 log.debug("DAO:Running HQL query with selections :" + queryString); 170 Query query = createQuery(queryString); 171 return query.list(); 172 } 173 174 public List findWithSelect(String queryString, Map<String, Object> params) 175 throws DataAccessException { 176 log.debug("DAO:Running HQL query with parameters:" + queryString); 177 Query query = createQuery(queryString, params); 178 return query.list(); 179 } 180 181 public List findWithSelect(String queryString, Map<String, Object> params, 182 int startRow, int pageSize) throws DataAccessException { 183 log.debug("DAO:Running HQL query by page :" + queryString); 184 Query query = createQuery(queryString, params, startRow, pageSize); 185 return query.list(); 186 } 187 188 public List<T> find(String queryString, Map<String, Object> params) 189 throws DataAccessException { 190 log.debug("DAO:Running HQL query with parameters: " + queryString); 191 Query query = createQuery(queryString, params); 192 return query.list(); 193 } 194 195 public List<T> find(String queryString, Map<String, Object> params, 196 int startRow, int pageSize) throws DataAccessException { 197 log.debug("DAO:Running HQL query with params by page :" + queryString); 198 Query query = createQuery(queryString, params, startRow, pageSize); 199 return query.list(); 200 } 201 202 public T findUniqueResult(String queryString, Map<String, Object> params) 203 throws DataAccessException { 204 log.debug("DAO:Running HQL query with parameters:" + queryString); 205 Query query = createQuery(queryString, params); 206 return (T) query.uniqueResult(); 207 } 208 209 public int excute(String queryString, Map<String, Object> params) 210 throws DataAccessException { 211 log.debug("DAO:Excute HQL update :" + queryString); 212 Query query = createQuery(queryString, params); 213 return query.executeUpdate(); 214 } 215 216 /** 217 * pagefind 218 */ 219 private String initSort(String hql) { 220 log.debug("DAO:Excute HQL update :" + hql); 221 String order = ThreadLocalUtils.getOrder(); 222 String sort = ThreadLocalUtils.getSort(); 223 if (sort != null && !"".equals(sort.trim())) { 224 hql += " order by " + sort; 225 if (!"desc".equals(order)) 226 hql += " asc"; 227 else 228 hql += " desc"; 229 } 230 return hql; 231 } 232 233 @SuppressWarnings("rawtypes") 234 private void setAliasParameter(Query query, Map<String, Object> alias) { 235 if (alias != null) { 236 Set<String> keys = alias.keySet(); 237 for (String key : keys) { 238 Object val = alias.get(key); 239 if (val instanceof Collection) { 240 // 查询条件是列表 241 query.setParameterList(key, (Collection) val); 242 } else { 243 query.setParameter(key, val); 244 } 245 } 246 } 247 } 248 249 private void setParameter(Query query, Object[] args) { 250 if (args != null && args.length > 0) { 251 int index = 0; 252 for (Object arg : args) { 253 query.setParameter(index++, arg); 254 } 255 } 256 } 257 258 private String getCountHql(String hql, boolean isHql) { 259 log.debug("DAO:Excute HQL update :" + hql); 260 String e = hql.substring(hql.indexOf("from")); 261 String c = "select count(*) " + e; 262 if (isHql) 263 c = c.replaceAll("fetch", ""); 264 return c; 265 } 266 267 public PageUtil<T> pagefind(String hql, Object[] args, 268 Map<String, Object> alias) { 269 log.debug("DAO:Excute HQL update :" + hql); 270 hql = initSort(hql); 271 String cq = getCountHql(hql, true); 272 Query cquery = getSession().createQuery(cq); 273 Query query = getSession().createQuery(hql); 274 // 设置别名参数 275 setAliasParameter(query, alias); 276 setAliasParameter(cquery, alias); 277 // 设置参数 278 setParameter(query, args); 279 setParameter(cquery, args); 280 PageUtil<T> pages = new PageUtil<T>(); 281 setPagers(query, pages); 282 List<T> datas = query.list(); 283 pages.setRows(datas); 284 long total = (Long) cquery.uniqueResult(); 285 pages.setTotal(total); 286 return pages; 287 } 288 289 public PageUtil<T> pagefind(String hql, Object[] args) { 290 log.debug("DAO:Excute HQL update :" + hql); 291 return this.pagefind(hql, args, null); 292 } 293 294 public PageUtil<T> pagefind(String hql, Object arg) { 295 log.debug("DAO:Excute HQL update :" + hql); 296 return this.pagefind(hql, new Object[] { arg }); 297 } 298 299 public PageUtil<T> pagefind(String hql) { 300 log.debug("DAO:Excute HQL update :" + hql); 301 return this.pagefind(hql, null); 302 } 303 304 @SuppressWarnings("rawtypes") 305 private void setPagers(Query query, PageUtil pages) { 306 Integer pageSize = ThreadLocalUtils.getPageSize(); 307 Integer pageOffset = ThreadLocalUtils.getPageOffset(); 308 if (pageOffset == null || pageOffset < 0) 309 pageOffset = 0; 310 if (pageSize == null || pageSize < 0) 311 pageSize = 15; 312 // pages.setOffset(pageOffset); 313 // pages.setSize(pageSize); 314 query.setFirstResult(pageOffset).setMaxResults(pageSize); 315 } 316 317 public <N extends Object> PageUtil<N> findBySql(String sql, Object[] args, 318 Map<String, Object> alias, Class<?> clz, boolean hasEntity) { 319 sql = initSort(sql); 320 String cq = getCountHql(sql, false); 321 SQLQuery sq = getSession().createSQLQuery(sql); 322 SQLQuery cquery = getSession().createSQLQuery(cq); 323 setAliasParameter(sq, alias); 324 setAliasParameter(cquery, alias); 325 setParameter(sq, args); 326 setParameter(cquery, args); 327 PageUtil<N> pages = new PageUtil<N>(); 328 // setPagers(sq, pages); 329 if (hasEntity) { 330 sq.addEntity(clz); 331 } else { 332 sq.setResultTransformer(Transformers.aliasToBean(clz)); 333 } 334 List<N> datas = sq.list(); 335 pages.setRows(datas); 336 long total = ((BigInteger) cquery.uniqueResult()).longValue(); 337 pages.setTotal(total); 338 return pages; 339 } 340 341 public <N extends Object> PageUtil<N> findBySql(String sql, Object[] args, 342 Class<?> clz, boolean hasEntity) { 343 return this.findBySql(sql, args, null, clz, hasEntity); 344 } 345 346 public <N extends Object> PageUtil<N> findBySql(String sql, Object arg, 347 Class<?> clz, boolean hasEntity) { 348 return this.findBySql(sql, new Object[] { arg }, clz, hasEntity); 349 } 350 351 public <N extends Object> PageUtil<N> findBySql(String sql, Class<?> clz, 352 boolean hasEntity) { 353 return this.findBySql(sql, null, clz, hasEntity); 354 } 355 }
1 package com.etop.controller; 2 3 import java.util.HashMap; 4 import java.util.Map; 5 import java.util.Set; 6 7 import org.apache.log4j.Logger; 8 import org.springframework.beans.factory.annotation.Autowired; 9 import org.springframework.stereotype.Controller; 10 import org.springframework.web.bind.annotation.RequestMapping; 11 import org.springframework.web.bind.annotation.ResponseBody; 12 13 import com.etop.basic.controller.BaseController; 14 import com.etop.dto.FunctionDto; 15 import com.etop.pojo.Function; 16 import com.etop.pojo.Permission; 17 import com.etop.pojo.Role; 18 import com.etop.service.FunctionService; 19 import com.etop.service.PermissionService; 20 import com.etop.service.RoleService; 21 import com.etop.utils.PageUtil; 22 23 /** 24 * @类名: FunctionController 25 * @描述: 处理过滤网址出的控制器 26 * @作者 liuren-mail@163.com 27 * @日期 2015年5月27日 下午3:31:54 28 */ 29 @Controller 30 @RequestMapping("/function") 31 public class FunctionController extends BaseController { 32 Map<String,Object> map = new HashMap<String,Object>(); 33 private final static Logger log = Logger 34 .getLogger(FunctionController.class); 35 @Autowired 36 private FunctionService functionService; 37 @Autowired 38 private PermissionService permissionService; 39 @Autowired 40 private RoleService roleService; 41 @RequestMapping("/functionList.html") 42 public String getFunctions() { 43 log.info("/functionList.html"); 44 return "/functionList.jsp"; 45 } 46 47 /** 48 * @标题: getFunctionList 49 * @描述: 返回分页的json数据 50 * @参数 @return 设定文件 51 * @返回 Object 返回类型 52 * @throws 53 * @作者 liuren-mail@163.com 54 * @日期 2015年5月27日 下午3:55:12 55 */ 56 @RequestMapping("/get_functions.html") 57 @ResponseBody 58 public Object getFunctionList() { 59 log.info("/get_functions.html"); 60 PageUtil<FunctionDto> functionList = functionService.findAllFunction(); 61 return functionList; 62 } 63 64 @RequestMapping("/add.html") 65 @ResponseBody 66 public Object addFunction(String value,int permission_id,int role_id,String type) { 67 log.info("/add.html"); 68 Function function = new Function(); 69 function.setPermission_id(permission_id); 70 function.setRole_id(role_id); 71 function.setValue(value); 72 function.setType(type); 73 functionService.saveFunction(function); 74 map.put(SUCCESS, true); 75 return map; 76 } 77 78 @RequestMapping("/edit.html") 79 @ResponseBody 80 public Object updateFunction(int id,String value,String type) { 81 log.info("/edit.html"); 82 Function function = functionService.findFunctionById(id); 83 if (function==null||"".equals(function)) { 84 map.put(SUCCESS, false); 85 return map; 86 } 87 function.setValue(value); 88 function.setType(type); 89 functionService.updateFunction(function); 90 map.put(SUCCESS, true); 91 return map; 92 } 93 94 @RequestMapping("/del.html") 95 @ResponseBody 96 public Object deleteFunction(int id) { 97 log.info("/del.html"); 98 functionService.deleteFunction(id); 99 map.put(SUCCESS, true); 100 return map; 101 } 102 }
1 package com.etop.controller; 2 3 import javax.imageio.ImageIO; 4 import javax.servlet.ServletOutputStream; 5 import javax.servlet.http.HttpServletRequest; 6 import javax.servlet.http.HttpServletResponse; 7 import javax.servlet.http.HttpSession; 8 import javax.validation.Valid; 9 10 import com.etop.basic.controller.BaseController; 11 import com.etop.service.UserService; 12 import com.etop.utils.VerifyCode; 13 14 import org.apache.commons.lang.StringUtils; 15 import org.apache.log4j.Logger; 16 import org.apache.shiro.SecurityUtils; 17 import org.apache.shiro.authc.AuthenticationException; 18 import org.apache.shiro.authc.UsernamePasswordToken; 19 import org.apache.shiro.web.util.WebUtils; 20 import org.springframework.beans.factory.annotation.Autowired; 21 import org.springframework.stereotype.Controller; 22 import org.springframework.ui.Model; 23 import org.springframework.validation.BindingResult; 24 import org.springframework.web.bind.annotation.RequestMapping; 25 import org.springframework.web.bind.annotation.RequestMethod; 26 27 import com.etop.pojo.User; 28 29 import org.springframework.web.servlet.mvc.support.RedirectAttributes; 30 31 import java.awt.Color; 32 import java.awt.image.BufferedImage; 33 import java.io.IOException; 34 import java.util.List; 35 36 /** 37 * @类名: HomeController 38 * @描述: 处理用户登录登出的控制器 39 * @作者 liuren-mail@163.com 40 * @日期 2015年5月20日 下午3:11:00 41 */ 42 @Controller 43 public class HomeController extends BaseController { 44 private final static Logger log = Logger.getLogger(HomeController.class); 45 @Autowired 46 private UserService userService; 47 48 @RequestMapping(value = "/login.html", method = RequestMethod.GET, produces = "text/html; charset=utf-8") 49 public String loginForm(Model model, String message) { 50 if (!StringUtils.isEmpty(message)) 51 model.addAttribute(message); 52 model.addAttribute("user", new User()); 53 System.out.println("login_1"); 54 System.out.println("model:" + model); 55 System.out.println("message:" + message); 56 log.info("login.html"); 57 return "/login.jsp"; 58 } 59 60 @RequestMapping(value = "/login.html", method = RequestMethod.POST, produces = "text/html; charset=utf-8") 61 public String login(@Valid User user, BindingResult bindingResult, 62 Model model, RedirectAttributes attr, HttpServletRequest request) { 63 HttpSession session = request.getSession(); 64 // session为空时跳转到登录界面 65 if (session.getAttribute(VerifyCode.VERIFY_TYPE_COMMENT) == null 66 || session.getAttribute(VerifyCode.VERIFY_TYPE_COMMENT) == "") { 67 addMessage(attr, "session为空"); 68 log.info("session为空"); 69 return "redirect:/"; 70 } 71 String code = ((String) request.getSession().getAttribute( 72 VerifyCode.VERIFY_TYPE_COMMENT)).toLowerCase(); 73 String submitCode = WebUtils.getCleanParam(request, "checkcode"); 74 if (StringUtils.isEmpty(code) || StringUtils.isEmpty(submitCode) 75 || !StringUtils.equals(code, submitCode.toLowerCase())) { 76 addMessage(attr, "验证码错误"); 77 log.info("验证码错误"); 78 return "redirect:/"; 79 } 80 try { 81 if (bindingResult.hasErrors() || user.getUsername().isEmpty() 82 || user.getPassword().isEmpty()) { 83 addMessage(attr, "用户名或密码错误"); 84 log.info("用户名或密码错误"); 85 return "redirect:/login.html"; 86 } 87 System.out.println("管理用户登录"); 88 // 使用shiro管理登录 89 SecurityUtils.getSubject().login( 90 new UsernamePasswordToken(user.getUsername(), user 91 .getPassword())); 92 // 获取所有用户信息，权限由前端shiro标签控制 93 List<User> userList = userService.getAllUser(); 94 System.out.println(userList); 95 model.addAttribute("userList", userList); 96 System.out.println("管理用户登录success"); 97 log.info("成功登录"); 98 System.out.println("密码:======================"+user.getPassword()); 99 return "/user.jsp"; 100 } catch (AuthenticationException e) { 101 addMessage(attr, "用户名或密码错误"); 102 log.info("用户名或密码错误"); 103 return "redirect:/login.html"; 104 } 105 } 106 107 @RequestMapping(value = "/logout.html", method = RequestMethod.GET) 108 public String logout(RedirectAttributes attr) { 109 // 使用权限管理工具进行用户的退出，注销登录 110 SecurityUtils.getSubject().logout(); 111 addMessage(attr, "您已安全退出"); 112 log.info("安全退出"); 113 return "redirect:/login.html"; 114 } 115 116 @RequestMapping("/403.html") 117 public String unauthorizedRole() { 118 log.info("跳转到403页面"); 119 return "/403.jsp"; 120 } 121 122 @RequestMapping("/verifyCode.html") 123 public void verifyCode(HttpServletRequest request, 124 HttpServletResponse response) throws IOException { 125 response.setHeader("Pragma", "no-cache"); 126 response.setHeader("Cache-Control", "no-cache"); 127 response.setDateHeader("Expires", 0); 128 // 生成验证码，写入用户session 129 String verifyCode = VerifyCode.generateTextCode( 130 VerifyCode.TYPE_NUM_UPPER, 4, "null"); 131 request.getSession().setAttribute(VerifyCode.VERIFY_TYPE_COMMENT, 132 verifyCode); 133 System.out.println("verifyCode=" + verifyCode); 134 // 输出验证码给客户端 135 response.setContentType("image/jpeg"); 136 /* 137 * textCode 文本验证码 width 图片宽度 height 图片高度 interLine 图片中干扰线的条数 138 * randomLocation 每个字符的高低位置是否随机 backColor 图片颜色，若为null，则采用随机颜色 f 139 * oreColor字体颜色，若为null，则采用随机颜色 lineColor 干扰线颜色，若为null，则采用随机颜色 140 */ 141 BufferedImage bim = VerifyCode.generateImageCode(verifyCode, 65, 22, 8, 142 true, Color.WHITE, Color.BLACK, null); 143 ServletOutputStream out = response.getOutputStream(); 144 ImageIO.write(bim, "JPEG", out); 145 log.info("验证码已经生成并存入session中"); 146 try { 147 out.flush(); 148 log.info("刷新验证码图片"); 149 } finally { 150 out.close(); 151 log.info("关闭验证码流"); 152 } 153 } 154 }
1 package com.etop.controller; 2 3 import java.util.HashMap; 4 import java.util.Map; 5 6 import org.apache.log4j.Logger; 7 import org.springframework.beans.factory.annotation.Autowired; 8 import org.springframework.stereotype.Controller; 9 import org.springframework.web.bind.annotation.RequestMapping; 10 import org.springframework.web.bind.annotation.ResponseBody; 11 12 13 14 import com.etop.basic.controller.BaseController; 15 import com.etop.dto.PermissionDto; 16 import com.etop.pojo.Permission; 17 import com.etop.service.PermissionService; 18 import com.etop.utils.PageUtil; 19 20 /** 21 * @类名: PermissionController 22 * @描述: 处理用户权限的控制器 23 * @作者 liuren-mail@163.com 24 * @日期 2015年5月27日 下午3:28:09 25 */ 26 @Controller 27 @RequestMapping("/permission") 28 public class PermissionController extends BaseController { 29 Map<String,Object> map = new HashMap<String,Object>(); 30 private final static Logger log = Logger 31 .getLogger(PermissionController.class); 32 @Autowired 33 private PermissionService permissionService; 34 35 @RequestMapping("/permissonList.html") 36 public String getPermissons() { 37 log.info("/permissionList.html"); 38 return "/permissonList.jsp"; 39 } 40 41 /** 42 * @标题: getPermissionList 43 * @描述: 返回分页的json数据 44 * @参数 @return 设定文件 45 * @返回 Object 返回类型 46 * @throws 47 * @作者 liuren-mail@163.com 48 * @日期 2015年5月27日 下午3:33:27 49 */ 50 @RequestMapping("/get_permissions.html") 51 @ResponseBody 52 public Object getPermissionList() { 53 log.info("/get_permission.html"); 54 PageUtil<PermissionDto> permissionList = permissionService 55 .findAllPermisson(); 56 return permissionList; 57 } 58 59 @RequestMapping("/add.html") 60 @ResponseBody 61 public Object addPermission(String permissionname) { 62 log.info("/add.html"); 63 if (permissionname==null||"".equals(permissionname)) { 64 map.put("success", false); 65 return map; 66 } 67 Permission permission = new Permission(); 68 permission.setPermissionname(permissionname); 69 permissionService.savePermission(permission); 70 map.put("success", true); 71 return map; 72 } 73 74 @RequestMapping("/edit.html") 75 @ResponseBody 76 public Object updatePermission(int id,String permissionname) { 77 log.info("/edit.html"); 78 Permission permission =permissionService.findPermissionById(id); 79 if (permission==null||"".equals(permission)) { 80 map.put("success", false); 81 } 82 permission.setPermissionname(permissionname); 83 permissionService.updatePermission(permission); 84 map.put("success", true); 85 return map; 86 } 87 88 @RequestMapping("/del.html") 89 @ResponseBody 90 public Object deletePermission(int id) { 91 log.info("/del.html"); 92 Permission permission = permissionService.findPermissionById(id); 93 if (permission==null||"".equals(permission)) { 94 map.put("success", false); 95 return map; 96 } 97 permissionService.deletePermission(id); 98 map.put("success", true); 99 return map; 100 } 101 }
1 package com.etop.controller; 2 3 import java.util.HashMap; 4 import java.util.Map; 5 6 import org.apache.log4j.Logger; 7 import org.springframework.beans.factory.annotation.Autowired; 8 import org.springframework.stereotype.Controller; 9 import org.springframework.web.bind.annotation.RequestMapping; 10 import org.springframework.web.bind.annotation.ResponseBody; 11 12 import com.etop.basic.controller.BaseController; 13 import com.etop.dto.RoleDto; 14 import com.etop.pojo.Role; 15 import com.etop.service.RoleService; 16 import com.etop.utils.PageUtil; 17 18 /** 19 * @类名: RoleController 20 * @描述: 处理角色操作的控制器 21 * @作者 liuren-mail@163.com 22 * @日期 2015年5月26日 下午6:09:03 23 */ 24 @Controller 25 @RequestMapping("/role") 26 public class RoleController extends BaseController { 27 Map<String,Object> map = new HashMap<String,Object>(); 28 private final static Logger log = Logger.getLogger(RoleController.class); 29 @Autowired 30 private RoleService roleService; 31 32 @RequestMapping("/roleList.html") 33 public String getRoles() { 34 log.info("/roleList.html"); 35 return "/roleList.jsp"; 36 } 37 38 /** 39 * @标题: getRoleList 40 * @描述: 返回json数据 41 * @参数 @return 设定文件 42 * @返回 Object 返回类型 43 * @throws 44 * @作者 liuren-mail@163.com 45 * @日期 2015年5月27日 下午3:56:39 46 */ 47 @RequestMapping("/get_roles.html") 48 @ResponseBody 49 public Object getRoleList() { 50 log.info("/get_roles.html"); 51 PageUtil<RoleDto> roleList = roleService.findAllRole(); 52 return roleList; 53 } 54 55 @RequestMapping("/add.html") 56 @ResponseBody 57 public Object addRole(String rolename,String description) { 58 log.info("/add.html"); 59 Role role = new Role(); 60 if (rolename==null||description==null||"".equals(rolename)||"".equals(description)) { 61 map.put("success", false); 62 return map; 63 } 64 role.setRolename(rolename); 65 role.setDescription(description); 66 roleService.saveRole(role); 67 map.put("success", true); 68 return map; 69 } 70 71 @RequestMapping("/edit.html") 72 @ResponseBody 73 public Object updateRole(int id,String rolename,String description) { 74 log.info("/edit.html"); 75 Role role = roleService.findById(id); 76 if (role==null||"".equals(role)) { 77 map.put("success", false); 78 } 79 role.setRolename(rolename); 80 role.setDescription(description); 81 roleService.updateRole(role); 82 map.put("success", true); 83 return map; 84 } 85 86 @RequestMapping("/del.html") 87 @ResponseBody 88 public Object deleteRole(int id) { 89 log.info("/del.html"); 90 roleService.deleteRole(id); 91 map.put("success", true); 92 return map; 93 } 94 95 @RequestMapping("/roleTest.html") 96 public String testRole() { 97 log.info("roleTest.html"); 98 return "/success.jsp"; 99 } 100 }
1 package com.etop.controller; 2 3 import java.util.HashMap; 4 import java.util.Map; 5 6 import org.apache.log4j.Logger; 7 import org.springframework.beans.factory.annotation.Autowired; 8 import org.springframework.stereotype.Controller; 9 import org.springframework.web.bind.annotation.RequestMapping; 10 import org.springframework.web.bind.annotation.ResponseBody; 11 12 import com.etop.basic.controller.BaseController; 13 import com.etop.dto.UserDto; 14 import com.etop.pojo.User; 15 import com.etop.service.UserService; 16 import com.etop.utils.MD5Utils; 17 import com.etop.utils.PageUtil; 18 19 /** 20 * @类名: UserController 21 * @描述: 处理用户操作的控制器 22 * @作者 liuren-mail@163.com 23 * @日期 2015年5月20日 下午3:10:19 24 */ 25 @Controller 26 @RequestMapping("/user") 27 public class UserController extends BaseController { 28 Map<String, Object> map = new HashMap<String, Object>(); 29 private final static Logger log = Logger.getLogger(UserController.class); 30 private UserService userService; 31 32 @Autowired 33 public void setUserService(UserService userService) { 34 this.userService = userService; 35 } 36 37 // add,edit,del页面并没有写具体逻辑，要验证是否成功，需要观察控制台输出。 38 @RequestMapping(value = "/get_users.html") 39 @ResponseBody 40 public Object getUsers() { 41 log.info("/get_users.html"); 42 PageUtil<UserDto> pageList = userService.findAllUser(); 43 return pageList; 44 } 45 46 @RequestMapping("/userList.html") 47 public String userList() { 48 log.info("/userList.html"); 49 return "/userList.jsp"; 50 } 51 52 @RequestMapping("/add.html") 53 @ResponseBody 54 public Object addUser(String username, String password) { 55 log.info("/add.html"); 56 MD5Utils MD5 = new MD5Utils(); 57 User user = new User(); 58 if (username == null || password == null || "".equals(username) 59 || "".equals(password)) { 60 map.put("success", false); 61 } 62 String md5_password = MD5.GetMD5Code(password); 63 user.setUsername(username); 64 user.setPassword(md5_password); 65 userService.saveUser(user); 66 map.put("success", true); 67 return map; 68 } 69 70 @RequestMapping("/edit.html") 71 @ResponseBody 72 public Object updateUser(int id, String username, String password) { 73 log.info("/edit.html"); 74 MD5Utils MD5 = new MD5Utils(); 75 User user = userService.findById(id); 76 if (user == null || "".equals(user)) { 77 map.put("success", false); 78 return map; 79 } 80 String md5_password = MD5.GetMD5Code(password); 81 user.setUsername(username); 82 user.setPassword(md5_password); 83 userService.updateUser(user); 84 map.put("success", true); 85 System.out.println("=========================================>要修改的id为:" 86 + id); 87 return map; 88 } 89 90 @ResponseBody 91 @RequestMapping(value = "/del.html") 92 public Object deleteUser(int id) { 93 log.info("/del.html"); 94 userService.deleteUser(id); 95 map.put("success", true); 96 System.out.println("=========================================>要删除的id为:" 97 + id); 98 return map; 99 } 100 }
项目的dao层：
1 package com.etop.dao; 2 3 import com.etop.basic.dao.BaseDAO; 4 import com.etop.pojo.Function; 5 6 import org.springframework.stereotype.Repository; 7 8 /** 9 * @类名: FunctionDAO 10 * @描述: TODO(这里用一句话描述这个类的作用) 11 * @作者 liuren-mail@163.com 12 * @日期 2015年5月20日 下午3:01:38 13 */ 14 @SuppressWarnings("serial") 15 @Repository("FunctionDAO") 16 public class FunctionDAO extends BaseDAO<Function> { 17 }
1 package com.etop.dao; 2 3 import com.etop.basic.dao.BaseDAO; 4 import com.etop.pojo.Permission; 5 6 import org.springframework.stereotype.Repository; 7 8 /** 9 * @类名: PermissionDAO 10 * @描述: TODO(这里用一句话描述这个类的作用) 11 * @作者 liuren-mail@163.com 12 * @日期 2015年5月20日 下午3:04:50 13 */ 14 @SuppressWarnings("serial") 15 @Repository("PermissionDAO") 16 public class PermissionDAO extends BaseDAO<Permission> { 17 }
1 package com.etop.dao; 2 3 import com.etop.basic.dao.BaseDAO; 4 import com.etop.pojo.Role; 5 6 import org.springframework.stereotype.Repository; 7 8 /** 9 * @类名: RoleDAO 10 * @描述: TODO(这里用一句话描述这个类的作用) 11 * @作者 liuren-mail@163.com 12 * @日期 2015年5月20日 下午3:05:28 13 */ 14 @SuppressWarnings("serial") 15 @Repository("RoleDAO") 16 public class RoleDAO extends BaseDAO<Role> { 17 }
1 package com.etop.dao; 2 3 import com.etop.basic.dao.BaseDAO; 4 import com.etop.pojo.User; 5 6 import org.springframework.stereotype.Repository; 7 8 /** 9 * @类名: UserDAO 10 * @描述: TODO(这里用一句话描述这个类的作用) 11 * @作者 liuren-mail@163.com 12 * @日期 2015年5月20日 下午3:05:41 13 */ 14 @SuppressWarnings("serial") 15 @Repository("UserDAO") 16 public class UserDAO extends BaseDAO<User> { 17 }
项目的DTO层：
1 package com.etop.dto; 2 3 public class FunctionDto { 4 5 private Integer id; 6 private String value; 7 private Integer permission_id; 8 private Integer role_id; 9 private String type; 10 11 public Integer getId() { 12 return id; 13 } 14 15 public void setId(Integer id) { 16 this.id = id; 17 } 18 19 public String getValue() { 20 return value; 21 } 22 23 public void setValue(String value) { 24 this.value = value; 25 } 26 27 public Integer getPermission_id() { 28 return permission_id; 29 } 30 31 public void setPermission_id(Integer permission_id) { 32 this.permission_id = permission_id; 33 } 34 35 public Integer getRole_id() { 36 return role_id; 37 } 38 39 public void setRole_id(Integer role_id) { 40 this.role_id = role_id; 41 } 42 43 public String getType() { 44 return type; 45 } 46 47 public void setType(String type) { 48 this.type = type; 49 } 50 51 }
1 package com.etop.dto; 2 3 public class PermissionDto { 4 5 private Integer id; 6 private String permissionname; 7 private String role; 8 public Integer getId() { 9 return id; 10 } 11 public void setId(Integer id) { 12 this.id = id; 13 } 14 public String getPermissionname() { 15 return permissionname; 16 } 17 public void setPermissionname(String permissionname) { 18 this.permissionname = permissionname; 19 } 20 public String getRole() { 21 return role; 22 } 23 public void setRole(String role) { 24 this.role = role; 25 } 26 27 28 }
1 package com.etop.dto; 2 3 public class RoleDto { 4 5 private Integer id; 6 private String rolename; 7 private String description; 8 private String permissionList; 9 private String userList; 10 11 public Integer getId() { 12 return id; 13 } 14 15 public void setId(Integer id) { 16 this.id = id; 17 } 18 19 public String getRolename() { 20 return rolename; 21 } 22 23 public void setRolename(String rolename) { 24 this.rolename = rolename; 25 } 26 27 public String getDescription() { 28 return description; 29 } 30 31 public void setDescription(String description) { 32 this.description = description; 33 } 34 35 public String getPermissionList() { 36 return permissionList; 37 } 38 39 public void setPermissionList(String permissionList) { 40 this.permissionList = permissionList; 41 } 42 43 public String getUserList() { 44 return userList; 45 } 46 47 public void setUserList(String userList) { 48 this.userList = userList; 49 } 50 51 }
1 package com.etop.dto; 2 3 public class UserDto { 4 5 private Integer id; 6 private String username; 7 private String password; 8 private String roleList; 9 10 public Integer getId() { 11 return id; 12 } 13 14 public void setId(Integer id) { 15 this.id = id; 16 } 17 18 public String getUsername() { 19 return username; 20 } 21 22 public void setUsername(String username) { 23 this.username = username; 24 } 25 26 public String getPassword() { 27 return password; 28 } 29 30 public void setPassword(String password) { 31 this.password = password; 32 } 33 34 public String getRoleList() { 35 return roleList; 36 } 37 38 public void setRoleList(String roleList) { 39 this.roleList = roleList; 40 } 41 42 }
项目的model层
1 package com.etop.pojo; 2 3 import javax.persistence.*; 4 5 import java.io.Serializable; 6 7 /** 8 * @类名: Function 9 * @描述: 网页过滤信息类，保存网页过滤信息，以及对应的权限(一对一)或角色(一对一) 10 * @作者 liuren-mail@163.com 11 * @日期 2015年5月20日 下午3:07:03 12 */ 13 @SuppressWarnings("serial") 14 @Entity 15 @Table(name = "t_function") 16 public class Function implements Serializable { 17 /** 18 * 这个是id 19 */ 20 private Integer id; 21 /** 22 * 这个是过滤的url 23 */ 24 private String value; 25 // private Permission permission; 26 // private Role role; 27 private int permission_id; 28 private int role_id; 29 private String type; 30 31 public Function() { 32 super(); 33 } 34 35 // public Function(Integer id, String value, Permission permission, Role role, 36 // String type) { 37 // super(); 38 // this.id = id; 39 // this.value = value; 40 // this.permission = permission; 41 // this.role = role; 42 // this.type = type; 43 // } 44 public Function(Integer id, String value, int permission_id, int role_id, 45 String type) { 46 super(); 47 this.id = id; 48 this.value = value; 49 this.permission_id = permission_id; 50 this.role_id = role_id; 51 this.type = type; 52 } 53 54 @Id 55 @GeneratedValue(strategy = GenerationType.IDENTITY) 56 public Integer getId() { 57 return id; 58 } 59 60 public void setId(Integer id) { 61 this.id = id; 62 } 63 64 public String getValue() { 65 return value; 66 } 67 68 public void setValue(String value) { 69 this.value = value; 70 } 71 72 // @OneToOne 73 // @JoinColumn(name = "permission_id") 74 // public Permission getPermission() { 75 // return permission; 76 // } 77 // 78 // public void setPermission(Permission permission) { 79 // this.permission = permission; 80 // } 81 // 82 // @OneToOne 83 // @JoinColumn(name = "role_id") 84 // public Role getRole() { 85 // return role; 86 // } 87 // 88 // public void setRole(Role role) { 89 // this.role = role; 90 // } 91 public int getPermission_id() { 92 return permission_id; 93 } 94 95 public void setPermission_id(int permission_id) { 96 this.permission_id = permission_id; 97 } 98 99 public int getRole_id() { 100 return role_id; 101 } 102 103 public void setRole_id(int role_id) { 104 this.role_id = role_id; 105 } 106 107 108 public String getType() { 109 return type; 110 } 111 112 public void setType(String type) { 113 this.type = type; 114 } 115 }
1 package com.etop.pojo; 2 3 import java.io.Serializable; 4 5 import javax.persistence.Entity; 6 import javax.persistence.GeneratedValue; 7 import javax.persistence.GenerationType; 8 import javax.persistence.Id; 9 import javax.persistence.JoinColumn; 10 import javax.persistence.JoinTable; 11 import javax.persistence.ManyToOne; 12 import javax.persistence.Table; 13 14 /** 15 * @类名: Permission 16 * @描述: 权限类，保存权限信息与对应的角色（多对一） 17 * @作者 liuren-mail@163.com 18 * @日期 2015年5月20日 上午11:26:31 19 */ 20 @SuppressWarnings("serial") 21 @Entity 22 @Table(name = "t_permission") 23 public class Permission implements Serializable { 24 25 private Integer id; 26 private String permissionname; 27 private Role role; 28 public Permission() { 29 super(); 30 } 31 32 public Permission(Integer id, String permissionname, Role role) { 33 super(); 34 this.id = id; 35 this.permissionname = permissionname; 36 this.role = role; 37 } 38 39 @Id 40 @GeneratedValue(strategy = GenerationType.IDENTITY) 41 public Integer getId() { 42 return id; 43 } 44 45 public void setId(Integer id) { 46 this.id = id; 47 } 48 49 public String getPermissionname() { 50 return permissionname; 51 } 52 53 public void setPermissionname(String permissionname) { 54 this.permissionname = permissionname; 55 } 56 57 @ManyToOne(targetEntity = Role.class) 58 @JoinTable(name = "t_role_permission", joinColumns = { @JoinColumn(name = "permission_id") }, inverseJoinColumns = { @JoinColumn(name = "role_id") }) 59 public Role getRole() { 60 return role; 61 } 62 63 public void setRole(Role role) { 64 this.role = role; 65 } 66 }
1 package com.etop.pojo; 2 3 import javax.persistence.*; 4 5 import org.codehaus.jackson.annotate.JsonIgnore; 6 7 import java.io.Serializable; 8 import java.util.HashSet; 9 import java.util.Set; 10 11 /** 12 * @类名: Role 13 * @描述: 角色类，用于保存角色信息、用户列表（多对多）与角色（一对多）对应的权限 14 * @作者 liuren-mail@163.com 15 * @日期 2015年5月20日 下午3:07:42 16 */ 17 @SuppressWarnings("serial") 18 @Entity 19 @Table(name = "t_role") 20 public class Role implements Serializable { 21 22 private Integer id; 23 private String rolename; 24 private String description; 25 private Set<Permission> permissionList; 26 private Set<User> userList; 27 28 public Role() { 29 super(); 30 } 31 32 public Role(Integer id, String rolename, Set<Permission> permissionList, 33 Set<User> userList) { 34 super(); 35 this.id = id; 36 this.rolename = rolename; 37 this.permissionList = permissionList; 38 this.userList = userList; 39 } 40 41 @Id 42 @GeneratedValue(strategy = GenerationType.IDENTITY) 43 public Integer getId() { 44 return id; 45 } 46 47 public void setId(Integer id) { 48 this.id = id; 49 } 50 51 public String getRolename() { 52 return rolename; 53 } 54 55 public void setRolename(String rolename) { 56 this.rolename = rolename; 57 } 58 59 public String getDescription() { 60 return description; 61 } 62 63 public void setDescription(String description) { 64 this.description = description; 65 } 66 67 @OneToMany(targetEntity = Permission.class, cascade = { 68 CascadeType.PERSIST, CascadeType.MERGE }) 69 @JsonIgnore 70 // 防止无限循环 71 @JoinTable(name = "t_role_permission", joinColumns = { @JoinColumn(name = "role_id") }, inverseJoinColumns = { @JoinColumn(name = "permission_id") }) 72 public Set<Permission> getPermissionList() { 73 return permissionList; 74 } 75 76 public void setPermissionList(Set<Permission> permissionList) { 77 this.permissionList = permissionList; 78 } 79 80 @ManyToMany(targetEntity = com.etop.pojo.User.class, cascade = { 81 CascadeType.PERSIST, CascadeType.MERGE }) 82 @JsonIgnore 83 // 防止无限循环 84 @JoinTable(name = "t_user_role", joinColumns = { @JoinColumn(name = "role_id") }, inverseJoinColumns = { @JoinColumn(name = "user_id") }) 85 public Set<User> getUserList() { 86 return userList; 87 } 88 89 public void setUserList(Set<User> userList) { 90 this.userList = userList; 91 } 92 93 @Transient 94 public Set<String> getPermissionsName() { 95 Set<String> list = new HashSet<>(); 96 Set<Permission> perlist = getPermissionList(); 97 for (Permission per : perlist) { 98 list.add(per.getPermissionname()); 99 } 100 return list; 101 } 102 103 private class User { 104 } 105 106 }
1 package com.etop.pojo; 2 3 import org.codehaus.jackson.annotate.JsonIgnore; 4 import org.hibernate.validator.constraints.NotEmpty; 5 6 import javax.persistence.*; 7 8 import java.io.Serializable; 9 import java.util.HashSet; 10 import java.util.Set; 11 12 /** 13 * @类名: User 14 * @描述: 用户类，保存用户信息与角色（多对多） 15 * @作者 liuren-mail@163.com 16 * @日期 2015年5月20日 下午3:08:11 17 */ 18 @SuppressWarnings("serial") 19 @Entity 20 @Table(name = "t_user") 21 public class User implements Serializable { 22 23 private Integer id; 24 @NotEmpty(message = "用户名不能为空") 25 private String username; 26 @NotEmpty(message = "密码不能为空") 27 private String password; 28 private Set<Role> roleList; 29 30 @Id 31 @GeneratedValue(strategy = GenerationType.IDENTITY) 32 public Integer getId() { 33 return id; 34 } 35 36 public void setId(Integer id) { 37 this.id = id; 38 } 39 40 public String getUsername() { 41 return username; 42 } 43 44 public void setUsername(String username) { 45 this.username = username; 46 } 47 48 public String getPassword() { 49 return password; 50 } 51 52 public void setPassword(String password) { 53 this.password = password; 54 } 55 56 @ManyToMany(fetch = FetchType.EAGER) 57 @JsonIgnore 58 // 防止无限循环 59 @JoinTable(name = "t_user_role", joinColumns = { @JoinColumn(name = "user_id") }, inverseJoinColumns = { @JoinColumn(name = "role_id") }) 60 public Set<Role> getRoleList() { 61 return roleList; 62 } 63 64 public void setRoleList(Set<Role> roleList) { 65 this.roleList = roleList; 66 } 67 68 @Transient 69 public Set<String> getRolesName() { 70 Set<Role> roles = getRoleList(); 71 Set<String> set = new HashSet<String>(); 72 for (Role role : roles) { 73 set.add(role.getRolename()); 74 } 75 return set; 76 } 77 78 public User() { 79 super(); 80 } 81 82 public User(Integer id, String username, String password, Set<Role> roleList) { 83 super(); 84 this.id = id; 85 this.username = username; 86 this.password = password; 87 this.roleList = roleList; 88 } 89 }
项目的service层：
1 package com.etop.service; 2 3 import com.etop.dao.FunctionDAO; 4 import com.etop.dto.FunctionDto; 5 import com.etop.pojo.Function; 6 import com.etop.utils.PageUtil; 7 8 import org.springframework.beans.factory.annotation.Autowired; 9 import org.springframework.stereotype.Service; 10 import org.springframework.transaction.annotation.Transactional; 11 12 import java.io.Serializable; 13 import java.util.HashMap; 14 import java.util.List; 15 import java.util.Map; 16 17 /** 18 * @类名: FunctionService 19 * @描述: 网页过滤服务，与dao进行对接 20 * @作者 liuren-mail@163.com 21 * @日期 2015年5月20日 上午11:46:22 22 */ 23 @SuppressWarnings("serial") 24 @Service("FunctionService") 25 public class FunctionService implements Serializable { 26 27 @Autowired 28 private FunctionDAO functionDAO; 29 30 /** 31 * 查找所有权限过滤信息 32 * 33 * @return 34 */ 35 public List<Function> findAll() { 36 return functionDAO.find("from Function f"); 37 } 38 39 @Transactional 40 public PageUtil<FunctionDto> findAllFunction() { 41 return functionDAO.findBySql("select * from t_function", 42 FunctionDto.class, false); 43 } 44 45 public void saveFunction(Function function) { 46 functionDAO.save(function); 47 } 48 49 public Function findFunctionById(int id) { 50 Map<String,Object> params = new HashMap<String,Object>(); 51 params.put("id", id); 52 return functionDAO.findUniqueResult("from Function f where f.id= :id", params); 53 } 54 55 public void updateFunction(Function function) { 56 functionDAO.saveOrUpdate(function); 57 } 58 59 public void deleteFunction(int id) { 60 functionDAO.deleteById(id); 61 } 62 }
1 package com.etop.service; 2 3 import java.io.Serializable; 4 import java.util.HashMap; 5 import java.util.List; 6 import java.util.Map; 7 8 import org.springframework.beans.factory.annotation.Autowired; 9 import org.springframework.stereotype.Service; 10 import org.springframework.transaction.annotation.Transactional; 11 12 import com.etop.dao.PermissionDAO; 13 import com.etop.dto.PermissionDto; 14 import com.etop.pojo.Permission; 15 import com.etop.utils.PageUtil; 16 17 /** 18 * @类名: PermissionService 19 * @描述: 权限服务和DAO对接 20 * @作者 liuren-mail@163.com 21 * @日期 2015年5月27日 下午3:58:27 22 */ 23 @SuppressWarnings("serial") 24 @Service 25 public class PermissionService implements Serializable { 26 27 @Autowired 28 private PermissionDAO permissionDAO; 29 30 public List<Permission> findAll(){ 31 return permissionDAO.find("from Permission p"); 32 } 33 @Transactional 34 public PageUtil<PermissionDto> findAllPermisson() { 35 return permissionDAO.findBySql("select * from t_permission", 36 PermissionDto.class, false); 37 } 38 39 public void savePermission(Permission permission) { 40 permissionDAO.save(permission); 41 } 42 43 public Permission findPermissionById(int id) { 44 Map<String,Object> params = new HashMap<String,Object>(); 45 params.put("id", id); 46 return permissionDAO.findUniqueResult("from Permission p where p.id= :id", params); 47 } 48 49 public void updatePermission(Permission permission) { 50 permissionDAO.saveOrUpdate(permission); 51 } 52 53 public void deletePermission(int id) { 54 permissionDAO.deleteById(id); 55 } 56 public String getNameById(int permission_id) { 57 Map<String,Object> params = new HashMap<String,Object>(); 58 params.put("id", permission_id); 59 Permission permission = permissionDAO.findUniqueResult("from Permission p where p.id= :id", params); 60 String name =permission.getPermissionname(); 61 return name; 62 } 63 64 }
1 package com.etop.service; 2 3 import java.io.Serializable; 4 import java.util.HashMap; 5 import java.util.List; 6 import java.util.Map; 7 8 import org.springframework.beans.factory.annotation.Autowired; 9 import org.springframework.stereotype.Service; 10 import org.springframework.transaction.annotation.Transactional; 11 12 import com.etop.dao.RoleDAO; 13 import com.etop.dto.RoleDto; 14 import com.etop.pojo.Role; 15 import com.etop.utils.PageUtil; 16 /** 17 * @类名: RoleService 18 * @描述: 角色服务和DAO对接 19 * @作者 liuren-mail@163.com 20 * @日期 2015年5月26日 下午5:20:03 21 */ 22 @SuppressWarnings("serial") 23 @Service 24 public class RoleService implements Serializable{ 25 26 @Autowired 27 private RoleDAO roleDAO; 28 29 @Transactional 30 public List<Role> getAllRole() { 31 return roleDAO.find("from Role r"); 32 } 33 34 @Transactional 35 public PageUtil<RoleDto> findAllRole() { 36 return roleDAO.findBySql("select * from t_role", RoleDto.class, false); 37 } 38 39 public Role findById(int id) { 40 Map<String,Object> params = new HashMap<String,Object>(); 41 params.put("id", id); 42 return roleDAO.findUniqueResult("from Role r where r.id= :id", params); 43 } 44 45 public void updateRole(Role role) { 46 roleDAO.saveOrUpdate(role); 47 } 48 49 public void saveRole(Role role) { 50 roleDAO.save(role); 51 } 52 53 public void deleteRole(int id) { 54 roleDAO.deleteById(id); 55 } 56 57 public String getNameById(int role_id) { 58 Map<String,Object> params = new HashMap<String,Object>(); 59 params.put("id", role_id); 60 Role role =roleDAO.findUniqueResult("from Role r where r.id= :id", params); 61 String rolename = role.getRolename(); 62 return rolename; 63 } 64 }
1 package com.etop.service; 2 3 import com.etop.dao.UserDAO; 4 import com.etop.dto.UserDto; 5 import com.etop.pojo.User; 6 import com.etop.utils.PageUtil; 7 8 import org.springframework.beans.factory.annotation.Autowired; 9 import org.springframework.stereotype.Service; 10 11 import java.io.Serializable; 12 import java.util.HashMap; 13 import java.util.List; 14 import java.util.Map; 15 16 /** 17 * @类名: UserService 18 * @描述: 用户服务，与dao进行对接 19 * @作者 liuren-mail@163.com 20 * @日期 2015年5月20日 下午3:03:20 21 */ 22 @SuppressWarnings("serial") 23 @Service("UserService") 24 public class UserService implements Serializable { 25 26 @Autowired 27 private UserDAO userDAO; 28 29 /** 30 * 通过用户名查找用户信息 31 * 32 * @param username 33 * @return 34 */ 35 public User findByName(String username) { 36 Map<String, Object> params = new HashMap<>(); 37 params.put("name", username); 38 return userDAO.findUniqueResult("from User u where u.username = :name", 39 params); 40 } 41 42 public List<User> getAllUser() { 43 return userDAO.find("from User u"); 44 } 45 46 public PageUtil<UserDto> findAllUser() { 47 return userDAO.findBySql("select * from t_user", UserDto.class, false); 48 } 49 50 public void saveUser(User user) { 51 userDAO.save(user); 52 } 53 54 public User findById(int id) { 55 Map<String, Object> params = new HashMap<String, Object>(); 56 params.put("id", id); 57 return userDAO.findUniqueResult("from User u where u.id = :id", params); 58 } 59 60 public void updateUser(User user) { 61 userDAO.saveOrUpdate(user); 62 } 63 64 public void deleteUser(int id) { 65 userDAO.deleteById(id); 66 } 67 }
项目的shiro层代码：
1 package com.etop.shiro; 2 3 import com.etop.pojo.Function; 4 import com.etop.service.FunctionService; 5 import com.etop.service.PermissionService; 6 import com.etop.service.RoleService; 7 8 import org.apache.commons.lang.StringUtils; 9 import org.apache.shiro.config.Ini; 10 import org.springframework.beans.factory.FactoryBean; 11 import org.springframework.beans.factory.annotation.Autowired; 12 13 import java.util.Iterator; 14 import java.util.List; 15 16 /** 17 * @类名: ChainDefinitionSectionMetaSource 18 * @描述: 产生责任链，确定每个url的访问权限 19 * @作者 liuren-mail@163.com 20 * @日期 2015年5月20日 下午3:12:53 21 */ 22 public class ChainDefinitionSectionMetaSource implements 23 FactoryBean<Ini.Section> { 24 25 @Autowired 26 private FunctionService functionService; 27 @Autowired 28 private RoleService roleService; 29 @Autowired 30 private PermissionService permissionService; 31 // 静态资源访问权限 32 private String filterChainDefinitions = "/static/**=anon"; 33 34 @Override 35 public Ini.Section getObject() throws Exception { 36 List<Function> list = functionService.findAll(); 37 Ini ini = new Ini(); 38 // 加载默认的url 39 ini.load(filterChainDefinitions); 40 Ini.Section section = ini.getSection(Ini.DEFAULT_SECTION_NAME); 41 // 循环Resource的url,逐个添加到section中。section就是filterChainDefinitionMap, 42 // 里面的键就是链接URL,值就是存在什么条件才能访问该链接 43 for (Iterator<Function> it = list.iterator(); it.hasNext();) { 44 Function function = it.next(); 45 int permission_id = function.getPermission_id(); 46 int role_id = function.getRole_id(); 47 // 构成permission字符串 48 if (StringUtils.isNotEmpty(function.getValue()) 49 && StringUtils.isNotEmpty(function.getType())) { 50 String permission = ""; 51 switch (function.getType()) { 52 case "anon": 53 permission = "anon"; 54 break; 55 case "perms": 56 permission = "perms[" 57 + permissionService.getNameById(permission_id)//function.getPermission().getPermissionname() 58 + "]"; 59 break; 60 case "roles": 61 permission = "roles[" 62 + roleService.getNameById(role_id)//function.getRole().getRolename() 63 + "]"; 64 break; 65 default: 66 break; 67 } 68 section.put(function.getValue(), permission); 69 } 70 71 } 72 // 所有资源的访问权限，必须放在最后 73 section.put("/**", "authc"); 74 return section; 75 } 76 77 @Override 78 public Class<?> getObjectType() { 79 return this.getClass(); 80 } 81 82 @Override 83 public boolean isSingleton() { 84 return false; 85 } 86 }
1 package com.etop.shiro; 2 3 import java.util.Collection; 4 5 import javax.inject.Inject; 6 7 import org.apache.shiro.authc.AuthenticationException; 8 import org.apache.shiro.authc.AuthenticationInfo; 9 import org.apache.shiro.authc.AuthenticationToken; 10 import org.apache.shiro.authc.SimpleAuthenticationInfo; 11 import org.apache.shiro.authc.UsernamePasswordToken; 12 import org.apache.shiro.authz.AuthorizationInfo; 13 import org.apache.shiro.authz.SimpleAuthorizationInfo; 14 import org.apache.shiro.realm.AuthorizingRealm; 15 import org.apache.shiro.subject.PrincipalCollection; 16 import org.springframework.stereotype.Service; 17 import org.springframework.transaction.annotation.Transactional; 18 19 import com.etop.pojo.Role; 20 import com.etop.pojo.User; 21 import com.etop.service.UserService; 22 23 /** 24 * @类名: MyRealm 25 * @描述: 自定义Realm,进行数据源配置 26 * @作者 liuren-mail@163.com 27 * @日期 2015年5月20日 上午11:50:21 28 */ 29 30 @Service 31 @Transactional 32 public class MyRealm extends AuthorizingRealm { 33 34 @Inject 35 private UserService userService; 36 37 /** 38 * 获取授权信息 39 */ 40 @Override 41 protected AuthorizationInfo doGetAuthorizationInfo( 42 PrincipalCollection principalCollection) { 43 // 获取登录时输入的用户名 44 String loginName = (String) principalCollection.fromRealm(getName()) 45 .iterator().next(); 46 // 到数据库获取此用户 47 User user = userService.findByName(loginName); 48 if (user != null) { 49 // 权限信息对象info,用来存放查出的用户的所有的角色（role）及权限（permission） 50 SimpleAuthorizationInfo info = new SimpleAuthorizationInfo(); 51 // 用户的角色集合 52 info.setRoles(user.getRolesName()); 53 // 用户的角色对应的所有权限，如果只使用角色定义访问权限 54 Collection<Role> roleList = user.getRoleList(); 55 for (Role role : roleList) { 56 info.addStringPermissions(role.getPermissionsName()); 57 } 58 return info; 59 } 60 return null; 61 } 62 63 /** 64 * 获取身份验证相关信息 65 */ 66 @Override 67 protected AuthenticationInfo doGetAuthenticationInfo( 68 AuthenticationToken authenticationToken) 69 throws AuthenticationException { 70 // UsernamePasswordToken对象用来存放提交的登录信息 71 UsernamePasswordToken token = (UsernamePasswordToken) authenticationToken; 72 // 查出是否有此用户 73 User user = userService.findByName(token.getUsername()); 74 if (user != null) { 75 // 若存在，将此用户存放到登录认证info中 76 return new SimpleAuthenticationInfo(user.getUsername(), 77 user.getPassword(), getName()); 78 } 79 return null; 80 } 81 82 }
项目的工具类：
1 package com.etop.utils; 2 3 import org.apache.commons.lang.time.DateFormatUtils; 4 5 import java.sql.Timestamp; 6 import java.text.ParseException; 7 import java.text.SimpleDateFormat; 8 import java.util.Calendar; 9 import java.util.Date; 10 11 /** 12 * @类名: DateUtils 13 * @描述: 比较两个日期相差的月份数 14 * @作者 liuren-mail@163.com 15 * @日期 2015年5月20日 下午2:47:06 16 */ 17 public class DateUtils extends org.apache.commons.lang.time.DateUtils { 18 19 public static SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); 20 private static String[] parsePatterns = { "yyyy-MM-dd", 21 "yyyy-MM-dd HH:mm:ss", "yyyy-MM-dd HH:mm", "yyyy/MM/dd", 22 "yyyy/MM/dd HH:mm:ss", "yyyy/MM/dd HH:mm" }; 23 24 /** 25 * 得到当前日期字符串 格式（yyyy-MM-dd） 26 */ 27 public static String getDate() { 28 return getDate("yyyy-MM-dd"); 29 } 30 31 /** 32 * 得到当前日期字符串 格式（yyyy-MM-dd） pattern可以为："yyyy-MM-dd" "HH:mm:ss" "E" 33 */ 34 public static String getDate(String pattern) { 35 return DateFormatUtils.format(new Date(), pattern); 36 } 37 38 /** 39 * 得到日期字符串 默认格式（yyyy-MM-dd） pattern可以为："yyyy-MM-dd" "HH:mm:ss" "E" 40 */ 41 public static String formatDate(Date date, Object... pattern) { 42 String formatDate = null; 43 if (pattern != null && pattern.length > 0) { 44 formatDate = DateFormatUtils.format(date, pattern[0].toString()); 45 } else { 46 formatDate = DateFormatUtils.format(date, "yyyy-MM-dd"); 47 } 48 return formatDate; 49 } 50 51 /** 52 * 得到当前时间字符串 格式（HH:mm:ss） 53 */ 54 public static String getTime() { 55 return formatDate(new Date(), "HH:mm:ss"); 56 } 57 58 /** 59 * 得到当前日期和时间字符串 格式（yyyy-MM-dd HH:mm:ss） 60 */ 61 public static String getDateTime() { 62 return formatDate(new Date(), "yyyy-MM-dd HH:mm:ss"); 63 } 64 65 /** 66 * 得到当前年份字符串 格式（yyyy） 67 */ 68 public static String getYear() { 69 return formatDate(new Date(), "yyyy"); 70 } 71 72 /** 73 * 得到当前月份字符串 格式（MM） 74 */ 75 public static String getMonth() { 76 return formatDate(new Date(), "MM"); 77 } 78 79 /** 80 * 得到当天字符串 格式（dd） 81 */ 82 public static String getDay() { 83 return formatDate(new Date(), "dd"); 84 } 85 86 /** 87 * 得到当前星期字符串 格式（E）星期几 88 */ 89 public static String getWeek() { 90 return formatDate(new Date(), "E"); 91 } 92 93 /** 94 * 日期型字符串转化为日期 格式 { "yyyy-MM-dd", "yyyy-MM-dd HH:mm:ss", "yyyy-MM-dd HH:mm", 95 * "yyyy/MM/dd", "yyyy/MM/dd HH:mm:ss", "yyyy/MM/dd HH:mm" } 96 */ 97 public static Date parseDate(Object str) { 98 if (str == null) { 99 return null; 100 } 101 try { 102 return parseDate(str.toString(), parsePatterns); 103 } catch (ParseException e) { 104 return null; 105 } 106 } 107 108 /** 109 * 获取过去的天数 110 * 111 * @param date 112 * @return 113 */ 114 public static long pastDays(Date date) { 115 long t = new Date().getTime() - date.getTime(); 116 return t / (24 * 60 * 60 * 1000); 117 } 118 119 public static int getMonthSpace(Timestamp source, Timestamp target) { 120 int result = 0; 121 122 Calendar c1 = Calendar.getInstance(); 123 Calendar c2 = Calendar.getInstance(); 124 125 c1.setTime(new Date(source.getTime())); 126 c2.setTime(new Date(target.getTime())); 127 128 result = c2.get(Calendar.MONDAY) - c1.get(Calendar.MONTH); 129 130 return result == 0 ? 0 : result; 131 } 132 133 public static Timestamp addDay(Timestamp source, int amount) { 134 Calendar c = Calendar.getInstance(); 135 c.setTimeInMillis(source.getTime()); 136 c.add(Calendar.DAY_OF_MONTH, amount); 137 return new Timestamp(c.getTimeInMillis()); 138 } 139 }
1 package com.etop.utils; 2 3 import net.sf.json.JSONObject; 4 5 public class JsonTools { 6 /** 7 * 得到一个json类型的字符串对象 8 * 9 * @param key 10 * @param value 11 * @return 12 */ 13 public static String getJsonString(String key, Object value) { 14 JSONObject jsonObject = new JSONObject(); 15 // put和element都是往JSONObject对象中放入 key/value 对 16 // jsonObject.put(key, value); 17 jsonObject.element(key, value); 18 return jsonObject.toString(); 19 } 20 21 /** 22 * 得到一个json对象 23 * 24 * @param key 25 * @param value 26 * @return 27 */ 28 public static JSONObject getJsonObject(String key, Object value) { 29 JSONObject jsonObject = new JSONObject(); 30 jsonObject.put(key, value); 31 return jsonObject; 32 } 33 34 }
package com.etop.utils; import java.security.MessageDigest; import java.security.NoSuchAlgorithmException; /** * @类名: MD5Utils * @描述: 32位的md5加密方法 * @作者 liuren-mail@163.com * @日期 2015年5月30日 上午10:29:57 */ public class MD5Utils { // 全局数组 private final static String[] strDigits = { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "a", "b", "c", "d", "e", "f" }; public MD5Utils() { } // 返回形式为数字跟字符串 private static String byteToArrayString(byte bByte) { int iRet = bByte; // System.out.println("iRet="+iRet); if (iRet < 0) { iRet += 256; } int iD1 = iRet / 16; int iD2 = iRet % 16; return strDigits[iD1] + strDigits[iD2]; } // 返回形式只为数字 @SuppressWarnings("unused") private static String byteToNum(byte bByte) { int iRet = bByte; System.out.println("iRet1=" + iRet); if (iRet < 0) { iRet += 256; } return String.valueOf(iRet); } // 转换字节数组为16进制字串 private static String byteToString(byte[] bByte) { StringBuffer sBuffer = new StringBuffer(); for (int i = 0; i < bByte.length; i++) { sBuffer.append(byteToArrayString(bByte[i])); } return sBuffer.toString(); } public String GetMD5Code(String strObj) { String resultString = null; try { resultString = new String(strObj); MessageDigest md = MessageDigest.getInstance("MD5"); // md.digest() 该函数返回值为存放哈希值结果的byte数组 resultString = byteToString(md.digest(strObj.getBytes())); } catch (NoSuchAlgorithmException ex) { ex.printStackTrace(); } return resultString; } public static void main(String[] args) { MD5Utils getMD5 = new MD5Utils(); System.out.println(getMD5.GetMD5Code("000000")); } }
1 package com.etop.utils; 2 3 import java.util.List; 4 5 public class PageUtil<T> { 6 7 // /** 8 // * 分页的大小 9 // */ 10 // private int size;//page*limit 11 // /** 12 // * 分页的起始页 13 // */ 14 // private int offset;//start 15 // /** 16 // * 总记录数 17 // */ 18 private long total; 19 /** 20 * 分页的数据 21 */ 22 private List<T> rows; 23 24 // public int getSize() { 25 // return size; 26 // } 27 // public void setSize(int size) { 28 // this.size = size; 29 // } 30 // public int getOffset() { 31 // return offset; 32 // } 33 // public void setOffset(int offset) { 34 // this.offset = offset; 35 // } 36 public long getTotal() { 37 return total; 38 } 39 40 public void setTotal(long total) { 41 this.total = total; 42 } 43 44 public List<T> getRows() { 45 return rows; 46 } 47 48 public void setRows(List<T> rows) { 49 this.rows = rows; 50 } 51 52 }
1 package com.etop.utils; 2 3 import org.apache.commons.lang.Validate; 4 import org.apache.log4j.Logger; 5 import org.springframework.beans.factory.DisposableBean; 6 import org.springframework.context.ApplicationContext; 7 import org.springframework.context.ApplicationContextAware; 8 9 /** 10 * @类名: SpringContextHolder 11 * @描述: 以静态变量保存Spring ApplicationContext, 可在任何代码任何地方任何时候取出ApplicaitonContext. 12 * @作者 liuren-mail@163.com 13 * @日期 2015年5月20日 上午11:49:42 14 */ 15 public class SpringContextHolder implements ApplicationContextAware, 16 DisposableBean { 17 18 private static ApplicationContext applicationContext = null; 19 private static Logger logger = Logger.getLogger(SpringContextHolder.class); 20 21 /** 22 * 取得存储在静态变量中的ApplicationContext. 23 */ 24 public static ApplicationContext getApplicationContext() { 25 assertContextInjected(); 26 return applicationContext; 27 } 28 29 /** 30 * 从静态变量applicationContext中取得Bean, 自动转型为所赋值对象的类型. 31 */ 32 @SuppressWarnings("unchecked") 33 public static <T> T getBean(String name) { 34 assertContextInjected(); 35 return (T) applicationContext.getBean(name); 36 } 37 38 /** 39 * 从静态变量applicationContext中取得Bean, 自动转型为所赋值对象的类型. 40 */ 41 public static <T> T getBean(Class<T> requiredType) { 42 assertContextInjected(); 43 return applicationContext.getBean(requiredType); 44 } 45 46 /** 47 * 清除SpringContextHolder中的ApplicationContext为Null. 48 */ 49 public static void clearHolder() { 50 logger.debug("清除SpringContextHolder中的ApplicationContext:" 51 + applicationContext); 52 applicationContext = null; 53 } 54 55 /** 56 * 实现ApplicationContextAware接口, 注入Context到静态变量中. 57 */ 58 @Override 59 public void setApplicationContext(ApplicationContext applicationContext) { 60 if (SpringContextHolder.applicationContext != null) { 61 logger.warn("SpringContextHolder中的ApplicationContext被覆盖, 原有ApplicationContext为:" 62 + SpringContextHolder.applicationContext); 63 } 64 SpringContextHolder.applicationContext = applicationContext; // NOSONAR 65 } 66 67 /** 68 * 实现DisposableBean接口, 在Context关闭时清理静态变量. 69 */ 70 @Override 71 public void destroy() throws Exception { 72 SpringContextHolder.clearHolder(); 73 } 74 75 /** 76 * 检查ApplicationContext不为空. 77 */ 78 private static void assertContextInjected() { 79 Validate.isTrue(applicationContext != null, 80 "applicaitonContext属性未注入, 请在applicationContext.xml中定义SpringContextHolder."); 81 } 82 }
1 package com.etop.utils; 2 /** 3 * 用来传递列表对象的ThreadLocal数据 4 * @author Administrator 5 * 6 */ 7 public class ThreadLocalUtils { 8 /** 9 * 分页大小 10 */ 11 private static ThreadLocal<Integer> pageSize = new ThreadLocal<Integer>(); 12 /** 13 * 分页的起始页 14 */ 15 private static ThreadLocal<Integer> pageOffset = new ThreadLocal<Integer>(); 16 /** 17 * 列表的排序字段 18 */ 19 private static ThreadLocal<String> sort = new ThreadLocal<String>(); 20 /** 21 * 列表的排序方式 22 */ 23 private static ThreadLocal<String> order = new ThreadLocal<String>(); 24 25 private static ThreadLocal<String> realPath = new ThreadLocal<String>(); 26 /* 27 private static ThreadLocal<String> query = new ThreadLocal<String>(); 28 29 public static String getQuery() { 30 return query.get(); 31 } 32 public static void setQuery(String _query) { 33 SystemContext.query.set(_query); 34 }*/ 35 public static String getRealPath() { 36 return realPath.get(); 37 } 38 public static void setRealPath(String _realPath) { 39 ThreadLocalUtils.realPath.set(_realPath); 40 } 41 public static Integer getPageSize() { 42 return pageSize.get(); 43 } 44 public static void setPageSize(Integer _pageSize) { 45 pageSize.set(_pageSize); 46 } 47 public static Integer getPageOffset() { 48 return pageOffset.get(); 49 } 50 public static void setPageOffset(Integer _pageOffset) { 51 pageOffset.set(_pageOffset); 52 } 53 public static String getSort() { 54 return sort.get(); 55 } 56 public static void setSort(String _sort) { 57 ThreadLocalUtils.sort.set(_sort); 58 } 59 public static String getOrder() { 60 return order.get(); 61 } 62 public static void setOrder(String _order) { 63 ThreadLocalUtils.order.set(_order); 64 } 65 66 public static void removePageSize() { 67 pageSize.remove(); 68 } 69 70 public static void removePageOffset() { 71 pageOffset.remove(); 72 } 73 74 public static void removeSort() { 75 sort.remove(); 76 } 77 78 public static void removeOrder() { 79 order.remove(); 80 } 81 82 public static void removeRealPath() { 83 realPath.remove(); 84 } 85 86 /*public static void removeQuery(){ 87 query.remove(); 88 }*/ 89 }
1 package com.etop.utils; 2 3 import java.io.*; 4 import java.text.SimpleDateFormat; 5 import java.util.*; 6 7 import org.apache.commons.fileupload.*; 8 import org.apache.commons.fileupload.FileUploadBase.InvalidContentTypeException; 9 import org.apache.commons.fileupload.FileUploadBase.SizeLimitExceededException; 10 import org.apache.commons.fileupload.util.*; 11 import org.apache.commons.fileupload.servlet.*; 12 import org.apache.commons.fileupload.FileItemIterator; 13 import org.apache.commons.fileupload.disk.DiskFileItemFactory; 14 15 import sun.misc.BASE64Decoder; 16 17 import javax.servlet.http.HttpServletRequest; 18 19 /** 20 * UEditor文件上传辅助类 21 * 22 */ 23 @SuppressWarnings("restriction") 24 public class Uploader { 25 // 输出文件地址 26 private String url = ""; 27 // 上传文件名 28 private String fileName = ""; 29 // 状态 30 private String state = ""; 31 // 文件类型 32 private String type = ""; 33 // 原始文件名 34 private String originalName = ""; 35 // 文件大小 36 private String size = ""; 37 38 private HttpServletRequest request = null; 39 private String title = ""; 40 41 // 保存路径 42 private String savePath = "upload"; 43 // 文件允许格式 44 private String[] allowFiles = { ".rar", ".doc", ".docx", ".zip", ".pdf", 45 ".txt", ".swf", ".wmv", ".gif", ".png", ".jpg", ".jpeg", ".bmp" }; 46 // 文件大小限制，单位KB 47 private int maxSize = 10000; 48 49 private HashMap<String, String> errorInfo = new HashMap<String, String>(); 50 51 public Uploader(HttpServletRequest request) { 52 this.request = request; 53 HashMap<String, String> tmp = this.errorInfo; 54 tmp.put("SUCCESS", "SUCCESS"); // 默认成功 55 tmp.put("NOFILE", "未包含文件上传域"); 56 tmp.put("TYPE", "不允许的文件格式"); 57 tmp.put("SIZE", "文件大小超出限制"); 58 tmp.put("ENTYPE", "请求类型ENTYPE错误"); 59 tmp.put("REQUEST", "上传请求异常"); 60 tmp.put("IO", "IO异常"); 61 tmp.put("DIR", "目录创建失败"); 62 tmp.put("UNKNOWN", "未知错误"); 63 64 } 65 66 public void upload() throws Exception { 67 boolean isMultipart = ServletFileUpload 68 .isMultipartContent(this.request); 69 if (!isMultipart) { 70 this.state = this.errorInfo.get("NOFILE"); 71 return; 72 } 73 DiskFileItemFactory dff = new DiskFileItemFactory(); 74 String savePath = this.getFolder(this.savePath); 75 dff.setRepository(new File(savePath)); 76 try { 77 ServletFileUpload sfu = new ServletFileUpload(dff); 78 sfu.setSizeMax(this.maxSize * 1024); 79 sfu.setHeaderEncoding("utf-8"); 80 FileItemIterator fii = sfu.getItemIterator(this.request); 81 while (fii.hasNext()) { 82 FileItemStream fis = fii.next(); 83 if (!fis.isFormField()) { 84 this.originalName = fis.getName().substring( 85 fis.getName().lastIndexOf( 86 System.getProperty("file.separator")) + 1); 87 if (!this.checkFileType(this.originalName)) { 88 this.state = this.errorInfo.get("TYPE"); 89 continue; 90 } 91 this.fileName = this.getName(this.originalName); 92 this.type = this.getFileExt(this.fileName); 93 this.url = savePath + "/" + this.fileName; 94 BufferedInputStream in = new BufferedInputStream( 95 fis.openStream()); 96 FileOutputStream out = new FileOutputStream(new File( 97 this.getPhysicalPath(this.url))); 98 BufferedOutputStream output = new BufferedOutputStream(out); 99 Streams.copy(in, output, true); 100 this.state = this.errorInfo.get("SUCCESS"); 101 // UE中只会处理单张上传，完成后即退出 102 break; 103 } else { 104 String fname = fis.getFieldName(); 105 // 只处理title，其余表单请自行处理 106 if (!fname.equals("pictitle")) { 107 continue; 108 } 109 BufferedInputStream in = new BufferedInputStream( 110 fis.openStream()); 111 BufferedReader reader = new BufferedReader( 112 new InputStreamReader(in)); 113 StringBuffer result = new StringBuffer(); 114 while (reader.ready()) { 115 result.append((char) reader.read()); 116 } 117 this.title = new String(result.toString().getBytes(), 118 "utf-8"); 119 reader.close(); 120 121 } 122 } 123 } catch (SizeLimitExceededException e) { 124 this.state = this.errorInfo.get("SIZE"); 125 } catch (InvalidContentTypeException e) { 126 this.state = this.errorInfo.get("ENTYPE"); 127 } catch (FileUploadException e) { 128 this.state = this.errorInfo.get("REQUEST"); 129 } catch (Exception e) { 130 this.state = this.errorInfo.get("UNKNOWN"); 131 } 132 } 133 134 /** 135 * 接受并保存以base64格式上传的文件 136 * 137 * @param fieldName 138 */ 139 public void uploadBase64(String fieldName) { 140 String savePath = this.getFolder(this.savePath); 141 String base64Data = this.request.getParameter(fieldName); 142 this.fileName = this.getName("test.png"); 143 this.url = savePath + "/" + this.fileName; 144 BASE64Decoder decoder = new BASE64Decoder(); 145 try { 146 File outFile = new File(this.getPhysicalPath(this.url)); 147 OutputStream ro = new FileOutputStream(outFile); 148 byte[] b = decoder.decodeBuffer(base64Data); 149 for (int i = 0; i < b.length; ++i) { 150 if (b[i] < 0) { 151 b[i] += 256; 152 } 153 } 154 ro.write(b); 155 ro.flush(); 156 ro.close(); 157 this.state = this.errorInfo.get("SUCCESS"); 158 } catch (Exception e) { 159 this.state = this.errorInfo.get("IO"); 160 } 161 } 162 163 /** 164 * 文件类型判断 165 * 166 * @param fileName 167 * @return 168 */ 169 private boolean checkFileType(String fileName) { 170 Iterator<String> type = Arrays.asList(this.allowFiles).iterator(); 171 while (type.hasNext()) { 172 String ext = type.next(); 173 if (fileName.toLowerCase().endsWith(ext)) { 174 return true; 175 } 176 } 177 return false; 178 } 179 180 /** 181 * 获取文件扩展名 182 * 183 * @return string 184 */ 185 private String getFileExt(String fileName) { 186 return fileName.substring(fileName.lastIndexOf(".")); 187 } 188 189 /** 190 * 依据原始文件名生成新文件名 191 * 192 * @return 193 */ 194 private String getName(String fileName) { 195 Random random = new Random(); 196 return this.fileName = "" + random.nextInt(10000) 197 + System.currentTimeMillis() + this.getFileExt(fileName); 198 } 199 200 /** 201 * 根据字符串创建本地目录 并按照日期建立子目录返回 202 * 203 * @param path 204 * @return 205 */ 206 private String getFolder(String path) { 207 SimpleDateFormat formater = new SimpleDateFormat("yyyyMMdd"); 208 path += "/" + formater.format(new Date()); 209 File dir = new File(this.getPhysicalPath(path)); 210 if (!dir.exists()) { 211 try { 212 dir.mkdirs(); 213 } catch (Exception e) { 214 this.state = this.errorInfo.get("DIR"); 215 return ""; 216 } 217 } 218 return path; 219 } 220 221 /** 222 * 根据传入的虚拟路径获取物理路径 223 * 224 * @param path 225 * @return 226 */ 227 private String getPhysicalPath(String path) { 228 String servletPath = this.request.getServletPath(); 229 String realPath = this.request.getSession().getServletContext() 230 .getRealPath(servletPath); 231 return new File(realPath).getParent() + "/" + path; 232 } 233 234 public void setSavePath(String savePath) { 235 this.savePath = savePath; 236 } 237 238 public void setAllowFiles(String[] allowFiles) { 239 this.allowFiles = allowFiles; 240 } 241 242 public void setMaxSize(int size) { 243 this.maxSize = size; 244 } 245 246 public String getSize() { 247 return this.size; 248 } 249 250 public String getUrl() { 251 return this.url; 252 } 253 254 public String getFileName() { 255 return this.fileName; 256 } 257 258 public String getState() { 259 return this.state; 260 } 261 262 public String getTitle() { 263 return this.title; 264 } 265 266 public String getType() { 267 return this.type; 268 } 269 270 public String getOriginalName() { 271 return this.originalName; 272 } 273 }
1 package com.etop.utils; 2 3 import java.awt.Color; 4 import java.awt.Font; 5 import java.awt.Graphics; 6 import java.awt.image.BufferedImage; 7 import java.util.Random; 8 9 /** 10 * 验证码生成器类，可生成数字、大写、小写字母及三者混合类型的验证码。 支持自定义验证码字符数量； 支持自定义验证码图片的大小； 支持自定义需排除的特殊字符； 11 * 支持自定义干扰线的数量； 支持自定义验证码图文颜色 12 * 13 * @author org.javachina 14 * @version 1.01 15 */ 16 public class VerifyCode { 17 18 // 验证码类型，评论 19 public static final String VERIFY_TYPE_COMMENT = "VERIFY_TYPE_COMMENT"; 20 21 /** 22 * 验证码类型为仅数字 0~9 23 */ 24 public static final int TYPE_NUM_ONLY = 0; 25 26 /** 27 * 验证码类型为仅字母，即大写、小写字母混合 28 */ 29 public static final int TYPE_LETTER_ONLY = 1; 30 31 /** 32 * 验证码类型为数字、大写字母、小写字母混合 33 */ 34 public static final int TYPE_ALL_MIXED = 2; 35 36 /** 37 * 验证码类型为数字、大写字母混合 38 */ 39 public static final int TYPE_NUM_UPPER = 3; 40 41 /** 42 * 验证码类型为数字、小写字母混合 43 */ 44 public static final int TYPE_NUM_LOWER = 4; 45 46 /** 47 * 验证码类型为仅大写字母 48 */ 49 public static final int TYPE_UPPER_ONLY = 5; 50 51 /** 52 * 验证码类型为仅小写字母 53 */ 54 public static final int TYPE_LOWER_ONLY = 6; 55 56 private VerifyCode() { 57 } 58 59 /** 60 * 生成验证码字符串 61 * 62 * @param type 63 * 验证码类型，参见本类的静态属性 64 * @param length 65 * 验证码长度，大于0的整数 66 * @param exChars 67 * 需排除的特殊字符（仅对数字、字母混合型验证码有效，无需排除则为null） 68 * @return 验证码字符串 69 */ 70 public static String generateTextCode(int type, int length, String exChars) { 71 72 if (length <= 0) 73 return ""; 74 75 StringBuffer code = new StringBuffer(); 76 int i = 0; 77 Random r = new Random(); 78 79 switch (type) { 80 81 // 仅数字 82 case TYPE_NUM_ONLY: 83 while (i < length) { 84 int t = r.nextInt(10); 85 if (exChars == null || exChars.indexOf(t + "") < 0) {// 排除特殊字符 86 code.append(t); 87 i++; 88 } 89 } 90 break; 91 92 // 仅字母（即大写字母、小写字母混合） 93 case TYPE_LETTER_ONLY: 94 while (i < length) { 95 int t = r.nextInt(123); 96 if ((t >= 97 || (t >= 65 && t <= 90)) 97 && (exChars == null || exChars.indexOf((char) t) < 0)) { 98 code.append((char) t); 99 i++; 100 } 101 } 102 break; 103 104 // 数字、大写字母、小写字母混合 105 case TYPE_ALL_MIXED: 106 while (i < length) { 107 int t = r.nextInt(123); 108 if ((t >= 97 || (t >= 65 && t <= 90) || (t >= 48 && t <= 57)) 109 && (exChars == null || exChars.indexOf((char) t) < 0)) { 110 code.append((char) t); 111 i++; 112 } 113 } 114 break; 115 116 // 数字、大写字母混合 117 case TYPE_NUM_UPPER: 118 while (i < length) { 119 int t = r.nextInt(91); 120 if ((t >= 65 || (t >= 48 && t <= 57)) 121 && (exChars == null || exChars.indexOf((char) t) < 0)) { 122 code.append((char) t); 123 i++; 124 } 125 } 126 break; 127 128 // 数字、小写字母混合 129 case TYPE_NUM_LOWER: 130 while (i < length) { 131 int t = r.nextInt(123); 132 if ((t >= 97 || (t >= 48 && t <= 57)) 133 && (exChars == null || exChars.indexOf((char) t) < 0)) { 134 code.append((char) t); 135 i++; 136 } 137 } 138 break; 139 140 // 仅大写字母 141 case TYPE_UPPER_ONLY: 142 while (i < length) { 143 int t = r.nextInt(91); 144 if ((t >= 65) 145 && (exChars == null || exChars.indexOf((char) t) < 0)) { 146 code.append((char) t); 147 i++; 148 } 149 } 150 break; 151 152 // 仅小写字母 153 case TYPE_LOWER_ONLY: 154 while (i < length) { 155 int t = r.nextInt(123); 156 if ((t >= 97) 157 && (exChars == null || exChars.indexOf((char) t) < 0)) { 158 code.append((char) t); 159 i++; 160 } 161 } 162 break; 163 164 } 165 166 return code.toString(); 167 } 168 169 /** 170 * 已有验证码，生成验证码图片 171 * 172 * @param textCode 173 * 文本验证码 174 * @param width 175 * 图片宽度 176 * @param height 177 * 图片高度 178 * @param interLine 179 * 图片中干扰线的条数 180 * @param randomLocation 181 * 每个字符的高低位置是否随机 182 * @param backColor 183 * 图片颜色，若为null，则采用随机颜色 184 * @param foreColor 185 * 字体颜色，若为null，则采用随机颜色 186 * @param lineColor 187 * 干扰线颜色，若为null，则采用随机颜色 188 * @return 图片缓存对象 189 */ 190 public static BufferedImage generateImageCode(String textCode, int width, 191 int height, int interLine, boolean randomLocation, Color backColor, 192 Color foreColor, Color lineColor) { 193 194 BufferedImage bim = new BufferedImage(width, height, 195 BufferedImage.TYPE_INT_RGB); 196 Graphics g = bim.getGraphics(); 197 // 画背景图 198 g.setColor(backColor == null ? getRandomColor() : backColor); 199 g.fillRect(0, 0, width, height); 200 201 // 画干扰线 202 Random r = new Random(); 203 if (interLine > 0) { 204 205 int x = 0, y = 0, x1 = width, y1 = 0; 206 for (int i = 0; i < interLine; i++) { 207 g.setColor(lineColor == null ? getRandomColor() : lineColor); 208 y = r.nextInt(height); 209 y1 = r.nextInt(height); 210 211 g.drawLine(x, y, x1, y1); 212 } 213 } 214 215 // 写验证码 216 217 // g.setColor(getRandomColor()); 218 // g.setColor(isSimpleColor?Color.BLACK:Color.WHITE); 219 220 // 字体大小为图片高度的80% 221 int fsize = (int) (height * 0.8); 222 int fx = height - fsize; 223 int fy = fsize; 224 225 g.setFont(new Font("Times New Roman", Font.BOLD, 20)); 226 227 // 写验证码字符 228 for (int i = 0; i < textCode.length(); i++) { 229 fy = randomLocation ? (int) ((Math.random() * 0.3 + 0.6) * height) 230 : fy;// 每个字符高低是否随机 231 g.setColor(foreColor == null ? getRandomColor() : foreColor); 232 g.drawString(textCode.charAt(i) + "", fx, fy); 233 fx += fsize * 0.9; 234 } 235 236 g.dispose(); 237 238 return bim; 239 } 240 241 /** 242 * 生成图片验证码 243 * 244 * @param type 245 * 验证码类型，参见本类的静态属性 246 * @param length 247 * 验证码字符长度，大于0的整数 248 * @param exChars 249 * 需排除的特殊字符 250 * @param width 251 * 图片宽度 252 * @param height 253 * 图片高度 254 * @param interLine 255 * 图片中干扰线的条数 256 * @param randomLocation 257 * 每个字符的高低位置是否随机 258 * @param backColor 259 * 图片颜色，若为null，则采用随机颜色 260 * @param foreColor 261 * 字体颜色，若为null，则采用随机颜色 262 * @param lineColor 263 * 干扰线颜色，若为null，则采用随机颜色 264 * @return 图片缓存对象 265 */ 266 public static BufferedImage generateImageCode(int type, int length, 267 String exChars, int width, int height, int interLine, 268 boolean randomLocation, Color backColor, Color foreColor, 269 Color lineColor) { 270 271 String textCode = generateTextCode(type, length, exChars); 272 BufferedImage bim = generateImageCode(textCode, width, height, 273 interLine, randomLocation, backColor, foreColor, lineColor); 274 275 return bim; 276 } 277 278 /** 279 * 产生随机颜色 280 * 281 * @return 282 */ 283 private static Color getRandomColor() { 284 Random r = new Random(); 285 Color c = new Color(r.nextInt(255), r.nextInt(255), r.nextInt(255)); 286 return c; 287 } 288 289 public static void main(String[] args) { 290 291 } 292 293 }
下面是项目的配置文件：
1 <?xml version="1.0" encoding="UTF-8"?> 2 <beans xmlns="http://www.springframework.org/schema/beans" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xmlns:aop="http://www.springframework.org/schema/aop" 5 xmlns:context="http://www.springframework.org/schema/context" 6 xmlns:tx="http://www.springframework.org/schema/tx" 7 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd 8 http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd 9 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd 10 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd 11 " default-lazy-init="true"> 12 13 14 <bean id="securityManager" class="org.apache.shiro.web.mgt.DefaultWebSecurityManager"> 15 <property name="realm" ref="myRealm"/> 16 <!-- 使用下面配置的缓存管理器 --> 17 <property name="cacheManager" ref="cacheManager"/> 18 </bean> 19 <!--自定义Realm--> 20 <bean id="myRealm" class="com.etop.shiro.MyRealm"/> 21 22 <!-- 配置shiro的过滤器工厂类，id- shiroFilter要和我们在web.xml中配置的过滤器一致 --> 23 <bean id="shiroFilter" class="org.apache.shiro.spring.web.ShiroFilterFactoryBean"> 24 <!-- 调用我们配置的权限管理器 --> 25 <property name="securityManager" ref="securityManager"/> 26 <!-- 配置我们的登录请求地址 --> 27 <property name="loginUrl" value="/login.html"/> 28 <!-- 配置我们在登录页登录成功后的跳转地址，如果你访问的是非/login地址，则跳到您访问的地址 --> 29 <property name="successUrl" value="/user.html"/> 30 <!-- 如果您请求的资源不再您的权限范围，则跳转到/403请求地址 --> 31 <property name="unauthorizedUrl" value="/403.html"/> 32 <!-- 权限配置 --> 33 <!-- <property name="filterChainDefinitionMap" ref="chainDefinitionSectionMetaSource"/> --> 34 <property name="filterChainDefinitions"> 35 <value> 36 /static/** = anon 37 /login.html = anon 38 /verifyCode.html = anon 39 /role/** = roles[admin] 40 /user/** = roles[admin] 41 /function/** = roles[admin] 42 /permission/** = roles[admin] 43 /** = authc 44 </value> 45 </property> 46 </bean> 47 <!--自定义filterChainDefinitionMap--> 48 <!-- <bean id="chainDefinitionSectionMetaSource" class="com.etop.shiro.ChainDefinitionSectionMetaSource"/> --> 49 <!--shiro缓存管理器--> 50 <bean id="cacheManager" class="org.apache.shiro.cache.MemoryConstrainedCacheManager"/> 51 <bean id="lifecycleBeanPostProcessor" class="org.apache.shiro.spring.LifecycleBeanPostProcessor"/> 52 53 54 <bean id="propertyConfigurer" 55 class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> 56 <property name="locations" value="classpath:jdbc.properties"/> 57 </bean> 58 59 <!--hibernate session工厂设置--> 60 <bean id="sessionFactory" 61 class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"> 62 <property name="dataSource" ref="dataSource"/> 63 <property name="packagesToScan"> 64 <list> 65 <value>com.etop.pojo</value> 66 </list> 67 </property> 68 <property name="hibernateProperties"> 69 <props> 70 <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> 71 <prop key="hibernate.generate_statistics">false</prop> 72 <prop key="hibernate.show_sql">true</prop> 73 <prop key="hibernate.format_sql">false</prop> 74 <prop key="hibernate.jdbc.batch_size">50</prop> 75 <prop key="jdbc.use_scrollable_resultset">false</prop> 76 <prop key="javax.persistence.validation.mode">none</prop> 77 <prop key="hibernate.cache.use_second_level_cache">true</prop> 78 <prop key="hibernate.cache.use_query_cache">true</prop> 79 <prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</prop> 80 <prop key="jdbc.use_scrollable_resultset">false</prop> 81 </props> 82 </property> 83 </bean> 84 85 <!-- c3p0 configuration --> 86 <bean id="mainDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> 87 <property name="driverClass" value="${jdbc.driverClass}"/> 88 <property name="jdbcUrl" value="${jdbc.url}"/> 89 <property name="user" value="${jdbc.username}"/> 90 <property name="password" value="${jdbc.password}"/> 91 <property name="minPoolSize" value="${jdbc.minPoolSize}"/> 92 <property name="maxPoolSize" value="${jdbc.maxPoolSize}"/> 93 <property name="checkoutTimeout" value="${jdbc.checkoutTimeout}"/> 94 <property name="maxStatements" value="${jdbc.maxStatements}"/> 95 <property name="testConnectionOnCheckin" value="${jdbc.testConnectionOnCheckin}"/> 96 <property name="idleConnectionTestPeriod" value="${jdbc.idleConnectionTestPeriod}"/> 97 </bean> 98 99 <bean id="dataSource" 100 class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy"> 101 <property name="targetDataSource"> 102 <ref bean="mainDataSource"/> 103 </property> 104 </bean> 105 <context:annotation-config/> 106 <context:component-scan base-package="com.etop"> 107 <context:exclude-filter type="regex" expression="com.cn.controller.*"/> 108 </context:component-scan> 109 110 <bean id="transactionManager" 111 class="org.springframework.orm.hibernate4.HibernateTransactionManager"> 112 <property name="sessionFactory"> 113 <ref bean="sessionFactory"/> 114 </property> 115 </bean> 116 117 <!-- 拦截配置 --> 118 <tx:advice id="txAdvice" transaction-manager="transactionManager"> 119 <tx:attributes> 120 <!--说明事务类别 --> 121 <tx:method name="delete*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/> 122 <tx:method name="save*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/> 123 <tx:method name="add*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/> 124 <tx:method name="update*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/> 125 <tx:method name="batch*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/> 126 <tx:method name="sendOpen*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/> 127 <tx:method name="sendClose*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/> 128 <tx:method name="find*" propagation="REQUIRED" read-only="true"/> 129 <tx:method name="get*" propagation="REQUIRED" read-only="true"/> 130 <tx:method name="load*" propagation="REQUIRED" read-only="true"/> 131 <tx:method name="*" read-only="true"/> 132 </tx:attributes> 133 </tx:advice> 134 135 <!-- 切入点 --> 136 <aop:config expose-proxy="true" proxy-target-class="true"> 137 <!-- service层事务 --> 138 <aop:advisor id="serviceTx" advice-ref="txAdvice" 139 pointcut="execution(public * com.etop.service.*.*(..))" order="1"/> 140 </aop:config> 141 142 <tx:annotation-driven/> 143 144 </beans>
1 <ehcache> 2 3 <!-- Sets the path to the directory where cache .data files are created. 4 5 If the path is a Java System Property it is replaced by 6 its value in the running VM. 7 8 The following properties are translated: 9 account.home - Account's home directory 10 account.dir - Account's current working directory 11 java.io.tmpdir - Default temp file path --> 12 <diskStore path="java.io.tmpdir"/> 13 14 15 <!--Default Cache configuration. These will applied to caches programmatically created through 16 the CacheManager. 17 18 The following attributes are required for defaultCache: 19 20 maxInMemory - Sets the maximum number of objects that will be created in memory 21 eternal - Sets whether elements are eternal. If eternal, timeouts are ignored and the element 22 is never expired. 23 timeToIdleSeconds - Sets the time to idle for an element before it expires. Is only used 24 if the element is not eternal. Idle time is now - last accessed time 25 timeToLiveSeconds - Sets the time to live for an element before it expires. Is only used 26 if the element is not eternal. TTL is now - creation time 27 overflowToDisk - Sets whether elements can overflow to disk when the in-memory cache 28 has reached the maxInMemory limit. 29 30 --> 31 <defaultCache 32 maxElementsInMemory="10000" 33 eternal="false" 34 timeToIdleSeconds="120" 35 timeToLiveSeconds="120" 36 overflowToDisk="true" 37 /> 38 39 <!--Predefined caches. Add your cache configuration settings here. 40 If you do not have a configuration for your cache a WARNING will be issued when the 41 CacheManager starts 42 43 The following attributes are required for defaultCache: 44 45 name - Sets the name of the cache. This is used to identify the cache. It must be unique. 46 maxInMemory - Sets the maximum number of objects that will be created in memory 47 eternal - Sets whether elements are eternal. If eternal, timeouts are ignored and the element 48 is never expired. 49 timeToIdleSeconds - Sets the time to idle for an element before it expires. Is only used 50 if the element is not eternal. Idle time is now - last accessed time 51 timeToLiveSeconds - Sets the time to live for an element before it expires. Is only used 52 if the element is not eternal. TTL is now - creation time 53 overflowToDisk - Sets whether elements can overflow to disk when the in-memory cache 54 has reached the maxInMemory limit. 55 56 --> 57 <!-- Place configuration for your caches following --> 58 <cache name="org.hibernate.cache.StandardQueryCache" 59 maxElementsInMemory="10000" eternal="false" 60 timeToIdleSeconds="300" 61 timeToLiveSeconds="4200" overflowToDisk="true" /> 62 63 <cache name="org.hibernate.cache.spi.UpdateTimestampsCache" 64 maxElementsInMemory="5000" 65 eternal="true" 66 overflowToDisk="true" /> 67 68 69 </ehcache>
1 jdbc.driverClass = com.mysql.jdbc.Driver 2 jdbc.url = jdbc:mysql://127.0.0.1:3306/shiro 3 jdbc.username = root 4 jdbc.password = root 5 jdbc.minPoolSize=2 6 jdbc.maxPoolSize=20 7 jdbc.checkoutTimeout=3000 8 jdbc.maxStatements=50 9 jdbc.testConnectionOnCheckin = false 10 jdbc.idleConnectionTestPeriod = 18000
1 log4j.rootLogger=info,stdout 2 3 log4j.appender.stdout = org.apache.log4j.ConsoleAppender 4 log4j.appender.stdout.Target = System.out 5 log4j.appender.stdout.layout = org.apache.log4j.PatternLayout 6 log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n 7 Hibernate 8 #log4j.logger.org.hibernate=debug 9 #log4j.logger.org.hibernate.SQL=debug
数据库文件(数据库用的是mysql)：
1 /* 2 SQLyog 企业版 - MySQL GUI v8.14 3 MySQL - 5.5.19 : Database - shiro 4 ********************************************************************* 5 */ 6 7 8 /*!40101 SET NAMES utf8 */; 9 10 /*!40101 SET SQL_MODE=''*/; 11 12 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 13 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 14 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 15 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 16 CREATE DATABASE /*!32312 IF NOT EXISTS*/`shiro` /*!40100 DEFAULT CHARACTER SET utf8 */; 17 18 USE `shiro`; 19 20 /*Table structure for table `t_function` */ 21 22 DROP TABLE IF EXISTS `t_function`; 23 24 CREATE TABLE `t_function` ( 25 `id` int(11) NOT NULL, 26 `value` varchar(50) DEFAULT NULL, 27 `permission_id` int(11) DEFAULT NULL, 28 `role_id` int(11) DEFAULT NULL, 29 `type` varchar(50) DEFAULT NULL, 30 PRIMARY KEY (`id`), 31 KEY `fk_function_role` (`role_id`), 32 KEY `fk_function_permission` (`permission_id`), 33 CONSTRAINT `fk_function_permission` FOREIGN KEY (`permission_id`) REFERENCES `t_permission` (`id`), 34 CONSTRAINT `fk_function_role` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`id`) 35 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 36 37 /*Data for the table `t_function` */ 38 39 insert into `t_function`(`id`,`value`,`permission_id`,`role_id`,`type`) values (2,'/login.html',NULL,NULL,'anon'),(3,'/user.html',4,NULL,'perms'),(4,'/user/add.html',1,NULL,'perms'),(5,'/user/del.html',2,NULL,'perms'),(6,'/user/edit.html',3,NULL,'perms'),(7,'/test.html',NULL,4,'roles'),(8,'/verifyCode.html',NULL,NULL,'anon'),(9,'/user/userList.html',NULL,4,'roles'); 40 41 /*Table structure for table `t_permission` */ 42 43 DROP TABLE IF EXISTS `t_permission`; 44 45 CREATE TABLE `t_permission` ( 46 `id` int(11) NOT NULL, 47 `permissionname` varchar(45) NOT NULL, 48 PRIMARY KEY (`id`) 49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 50 51 /*Data for the table `t_permission` */ 52 53 insert into `t_permission`(`id`,`permissionname`) values (1,'user:add'),(2,'user:del'),(3,'user:update'),(4,'user:query'); 54 55 /*Table structure for table `t_role` */ 56 57 DROP TABLE IF EXISTS `t_role`; 58 59 CREATE TABLE `t_role` ( 60 `id` int(11) NOT NULL, 61 `rolename` varchar(45) DEFAULT NULL, 62 `description` varchar(45) DEFAULT NULL, 63 PRIMARY KEY (`id`) 64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 65 66 /*Data for the table `t_role` */ 67 68 insert into `t_role`(`id`,`rolename`,`description`) values (1,'admin','超级管理员'),(2,'manager','系统管理员'),(3,'normal','普通管理员'),(4,'user','普通用户'); 69 70 /*Table structure for table `t_role_permission` */ 71 72 DROP TABLE IF EXISTS `t_role_permission`; 73 74 CREATE TABLE `t_role_permission` ( 75 `role_id` int(11) DEFAULT NULL, 76 `permission_id` int(11) DEFAULT NULL 77 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 78 79 /*Data for the table `t_role_permission` */ 80 81 insert into `t_role_permission`(`role_id`,`permission_id`) values (1,1),(1,2),(1,3),(1,4),(2,1),(2,2),(2,3),(3,4),(4,4),(4,3); 82 83 /*Table structure for table `t_user` */ 84 85 DROP TABLE IF EXISTS `t_user`; 86 87 CREATE TABLE `t_user` ( 88 `id` int(11) NOT NULL, 89 `username` varchar(45) DEFAULT NULL, 90 `password` varchar(45) DEFAULT NULL, 91 PRIMARY KEY (`id`) 92 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 93 94 /*Data for the table `t_user` */ 95 96 insert into `t_user`(`id`,`username`,`password`) values (1,'admin1','670b14728ad9902aecba32e22fa4f6bd'),(2,'admin2','670b14728ad9902aecba32e22fa4f6bd'),(3,'admin3','670b14728ad9902aecba32e22fa4f6bd'),(4,'admin4','670b14728ad9902aecba32e22fa4f6bd'); 97 98 /*Table structure for table `t_user_role` */ 99 100 DROP TABLE IF EXISTS `t_user_role`; 101 102 CREATE TABLE `t_user_role` ( 103 `user_id` int(11) DEFAULT NULL, 104 `role_id` int(11) DEFAULT NULL, 105 KEY `FK_role_user` (`role_id`), 106 KEY `FK_user_role` (`user_id`), 107 CONSTRAINT `FK_role_user` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`id`), 108 CONSTRAINT `FK_user_role` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) 109 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 110 111 /*Data for the table `t_user_role` */ 112 113 insert into `t_user_role`(`user_id`,`role_id`) values (1,1),(1,3),(2,2),(2,3),(3,3),(4,4); 114 115 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 116 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 117 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 118 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;