SSH框架模板

SSH：

S:SpringMVC —– S:Spring —– H:Hibernate

引入的包：

antlr-.jar
aopalliance.jar
asm-.jar
aspectjrt.jar
aspectjweaver.jar
c3p0-.jar
cglib-.jar
classmate-.jar
commons-codec-.jar
commons-dbcp2-.jar
commons-dbutils-.jar
commons-fileupload-.jar
commons-io-.jar
commons-logging-.jar
commons-pool2-.jar
dom4j-.jar
hibernate-commons-annotations-.Final.jar
hibernate-core-.Final.jar
hibernate-envers-.Final.jar
hibernate-jpa--api-.Final.jar
hibernate-jpamodelgen-.Final.jar
jandex-.Final.jar
javassist--GA.jar
jboss-logging-.Final.jar
jboss-transaction-api_1_spec-.Final.jar
jsp-api.jar
jstl-.jar
mysql-connector-java--bin.jar
servlet-api.jar
spring-aop-.RELEASE.jar
spring-beans-.RELEASE.jar
spring-context-.RELEASE.jar
spring-core-.RELEASE.jar
spring-expression-.RELEASE.jar
spring-jdbc-.RELEASE.jar
spring-orm-.RELEASE.jar
spring-tx-.RELEASE.jar
spring-web-.RELEASE.jar
spring-webmvc-.RELEASE.jar

配置文件：

web.xml

<!-- Spring 相关配置 -->
    <!-- needed for ContextLoaderListener -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>/WEB-INF/classes/config/bean-*.xml</param-value>
    </context-param>
    <!-- Bootstraps the root web application context before servlet initialization -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <!-- Spring MVC -->
    <!-- The front controller of this Spring Web application, responsible for handling all application requests -->
    <servlet>
        <servlet-name>springDispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:config/spring-mvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <!-- Map all requests to the DispatcherServlet for handling -->
    <servlet-mapping>
        <servlet-name>springDispatcherServlet</servlet-name>
        <url-pattern>*.action</url-pattern>
    </servlet-mapping>
    <filter>
        <filter-name>characterEncodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
 </filter>
    <filter-mapping>
        <filter-name>characterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

bean-base.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd">
    <!--将Hibernate中的连接数据库的相关信息配置到Spring中来 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="acquireIncrement" value="2"></property>
        <property name="maxPoolSize" value="100"></property>
        <property name="minPoolSize" value="2"></property>
        <property name="maxStatements" value="100"></property>
        <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
        <property name="jdbcUrl" value="jdbc:mysql:///test01"></property>
        <property name="user" value="root"></property>
        <property name="password" value="123456"></property>
    </bean>
    <!--Spring和Hibernate整合的关键点是SessionFactory的创建问题 -->
    <bean id="sessionFactory"  class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <!--下面我要将hibernate的配置文件写到这个里面来-->
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
                <prop key="hibernate.hbm2ddl.auto">update</prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.format_sql">true</prop>
                <prop key="current_session_context_class">thread</prop>
            </props>
        </property>
        <!--编写hibernate的映射配置-->
        <property name="mappingDirectoryLocations">
            <list>
                 <!--配置mapping映射文件的根路径就好了-->
            <value>classpath:com/wc/hrm/pojo</value>
            </list> 
        </property>
    </bean>
   <!--配置aop的扫描-->
    <aop:aspectj-autoproxy></aop:aspectj-autoproxy>
</beans>

spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
    <!--配置的是文件上传的类  前面的文件名字必须是 multipartResolver   别的名字好像不行-->
    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"></bean>
    <!-- 配置视图解析器 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/jsp/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean> 
     <!--配置IOC/DI的扫描器-->
   <context:component-scan base-package="com.wc.hrm">
    </context:component-scan>
    <!-- 设置mvc的注解的驱动 -->
    <mvc:annotation-driven></mvc:annotation-driven> 
    <!--    配置事务 -->
    <bean id="txManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>
     <!--应用这个事务-->
     <tx:annotation-driven transaction-manager="txManager"/>
</beans>

User.java

/**
 * 实体管理员类
 * @author Administrator
 *
 */
public class User {
    private Integer id;//管理员id
    private String  loginName;//登录名
    private String password;//密码
    private int status;//状态
    private String username;//用户名
    private String createDate;//创建时间
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getLoginName() {
        return loginName;
    }
    public void setLoginName(String loginName) {
        this.loginName = loginName;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public int getStatus() {
        return status;
    }
    public void setStatus(int status) {
        this.status = status;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getCreateDate() {
        return createDate;
    }
    public void setCreateDate(String createDate) {
        this.createDate = createDate;
    }
    public User(String loginName, String password, int status, String username) {
        super();
        this.loginName = loginName;
        this.password = password;
        this.status = status;
        this.username = username;
    }
    public User() {
        super();
    }
    @Override
    public String toString() {
        return "User [id=" + id + ", loginName=" + loginName + ", password=" + password + ", status=" + status
                + ", username=" + username + ", createDate=" + createDate + "]";
    }   
}

User.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
 <!--package是否可以省略?
            可以
            省略之后类的名字 编写全路径就OK了       
 -->       
 <hibernate-mapping  package="com.wc.hrm.pojo"  default-lazy="false"> 
    <!--一个class就相当于对应了一张表
         name:表示的是我们对应数据库表的那个对象的名字  这个名字如果上面没有配置package的话那么是需要全路径的
         table:这个标签是我们的JAVA对象  在数据库表中对应的这个表名
         abstract:这个用在继承映射的时候 这个类是否在数据库对应表的问题
         lazy:是否这个对象支持懒惰形加载 (我们只有在使用这个数据的时候那么 才加载这个数据  如果我们不需要使用这个数据的话 那么就不会加载)
         abstract="true" lazy="true"
         table:是否可以省略?
                        可以的
                        省略之后默认的表明就是实体的名字
    -->
    <class name="User" table="u_user">
       <!--配置的主键
          id：是用来配置这个主键的(每一个表都有主键) 值直接写我们实体里面的主键属性 
          column:这个是用来定义这个列的列名的
          type:表示的是当前的这个类中的属性的数据格式是什么  这里可以写java里面的类型的全路径 也可以写hibernate中支持的数据类型
          column:可以省略 默认的字段就是属性的名字  
          type:也可以省略:默认的类型和实体的数据类型是一样的
        -->
        <id name="id" column="ID">
            <generator class="native"></generator>
        </id>
        <!--配置的是普通的列
            property:设置的是普通的列  
            column:列名(当前对象的属性在数据库中对应的列名)  可以省略
            lazy:是否支持懒惰性的加载  :也默认值
            not-null:是否可以为null
            unique:是否这个列的值是唯一的
            type:可以省略 默认数据类型和实体中的属性的类型一直
            length:设置的是长度(有点必须的)-->
        <property name="loginName" column="loginname"></property>
         <property name="password" column="PASSWORD"></property>
          <property name="status" column="STATUS"></property>
           <property name="username"></property>
            <property name="createDate"></property>
    </class>
</hibernate-mapping>

IUserDao.java

/**
 * 持久层接口：管理员
 * @author Administrator
 *
 */
public interface IUSerDao {
    /**
     * 增加方法
     * @param user
     * @throws Exception
     */
    public void  insert(User user)throws Exception;
    /**
     * 修改方法
     * @param user
     * @throws Exception
     */
    public void update(User user) throws Exception;
    /**
     * 删除方法
     * @param id
     * @throws Exception
     */
    public void delete(Integer id)throws Exception;
    /**
     *  id查询方法
     * @param id
     * @return
     * @throws Exception
     */
    public User query(Integer id )throws Exception;
    /**
     * username,status查询方法
     * @param username
     * @param status
     * @return
     * @throws Exception
     */
    public List<User> query(String  username,Integer status) throws Exception ;
    /**
     * 登录查询方法
     * @param username
     * @param password
     * @return
     * @throws Exception
     */
    public User query(String username,String password) throws Exception ;
}

UserDao.java

/**
 * 持久层实现：管理员
 * 
 * @author Administrator
 *
 */
@Repository
public class UserDao implements IUSerDao {
    @Autowired
    private SessionFactory sessionFactory = null;
    @Override
    public void insert(User user) throws Exception {
        user.setCreateDate(DateUtils.getDate3());// 设置创建时间(工具类)
        sessionFactory.openSession().save(user);
    }
    @Override
    public void update(User user) throws Exception {
        Session session = sessionFactory.getCurrentSession();
        session.update(user);
    }
    @Override
    @Transactional
    public void delete(Integer id) throws Exception {
        Session session = sessionFactory.getCurrentSession();
        Query query = session.createQuery("delete from User as u where u.id=:id");
        query.setParameter("id", id);
        query.executeUpdate();
        System.out.println("delete");
    }
    @Override
    public User query(Integer id) throws Exception {
        Session session = sessionFactory.openSession();
        User user = session.get(User.class, id);
        return user;
    }
    @SuppressWarnings("rawtypes")
    @Override
    public User query(String loginname, String password) throws Exception {
        Session session = sessionFactory.openSession();
        System.out.println(loginname);
        System.out.println(password);
        Query query = session.createQuery("select u from User u where u.loginName=:username AND u.password=:password");
        query.setParameter("username", loginname);
        query.setParameter("password", password);
        User user = null;
        if (query.list().size() != ) {
            user = (User) query.list().get();
        }
        return user;
    }
    @Override
    public List<User> query(String username, Integer status) throws Exception {
        Session session = sessionFactory.openSession();
        Query query = null;
        String hql = "select u from User u where 1=1";
        if (username == null || username == "" || username == " ") {
            if (status != null) {
                hql = hql + " AND u.status=:status";
                query = session.createQuery(hql);
                query.setParameter("status", status);
            } else {
                query = session.createQuery(hql);
            }
        } else {
            if (status != null) {
                hql = hql + " AND u.status=:status AND u.username like :username";
                query = session.createQuery(hql);
                query.setParameter("username", "%" + username + "%");
                query.setParameter("status", status);
            } else {
                hql = hql + " AND u.username like :username";
                query = session.createQuery(hql);
                query.setParameter("username", "%" + username + "%");
            }
        }
        return query.list();
    }
}

IUserService.java

/**
 * 业务逻辑层接口：管理员
 * @author Administrator
 *
 */
public interface IUserService {
    /**
     * 增加方法
     * @param employee
     * @throws Exception
     */
    public void  insert(User user)throws Exception;
    /**
     * 修改方法
     * @param employee
     * @throws Exception
     */
    public void update(User user) throws Exception;
    /**
     * 删除方法
     * @param employee
     * @throws Exception
     */
    public void delete(Integer id)throws Exception;
    /**
     * 查询方法
     * @param id
     * @return
     * @throws Exception
     */
    public User query(Integer id )throws Exception;
    /**
     * 查询方法
     * @return
     * @throws Exception
     */
    public List<User> query(String username,Integer status)throws Exception;
    /**
     * 查询方法
     * @param username
     * @param password
     * @return
     * @throws Exception
     */
    public User query(String username,String password )throws Exception;
}

UserService.java

/**
 * 业务逻辑层实现：管理员
 * @author Administrator
 *
 */
@Service
@Transactional
public class UserService implements IUserService{
    @Autowired
    private IUSerDao userDao=null;
    @Override
    public void insert(User user) throws Exception {
        userDao.insert(user);
    }
    @Override
    public void update(User user) throws Exception {
        userDao.update(user);
    }
    @Override
    public void delete(Integer id) throws Exception {
        if(id!=null) {
            userDao.delete(id);
        }
    }
    @Override
    public User query(Integer id) throws Exception {
        User user=null;
        if(id!=null) {
            user=userDao.query(id);
        }
        return user;
    }
    @Override
    public User query(String loginname, String password) throws Exception {
        User user=userDao.query(loginname,password);
        System.out.println("service"+user);
        return user;
    }
    @Override
    public List<User> query(String username, Integer status) throws Exception {
        List<User> users=userDao.query(username,status);
        return users;
    }
}

UserControll.java

/**
 * 控制层：管理员
 * @author Administrator
 *
 */
@Controller
@RequestMapping("/user")
public class UserControll {
    @Resource
    private IUserService userService=null;
    /**
     * 用户查询
     * @param username
     * @param status
     * @return
     * @throws Exception
     */
    @RequestMapping("/selectUser.action")
    public ModelAndView selectUser(String  username,Integer status) throws Exception {
        List<User> users=userService.query(username,status);
        ModelAndView modelAndView=new ModelAndView();
        modelAndView.setViewName("user/user");
        modelAndView.addObject("users",users);
        return modelAndView;    
    }   
    /**
     * 添加用户跳转
     * @return
     */
    @RequestMapping("/addUser.action")
    public String addUser() {
        return "user/showAddUser";
    }   
    /**
     * 添加用户提交
     * @param user
     * @return
     * @throws Exception
     */
    @RequestMapping("/addUserF.action")
    public  ModelAndView addUser(User user) throws Exception {
        userService.insert(user);
        return selectUser(null,null);   
    }   
    /**
     *  修改用户跳转
     * @param id
     * @return
     * @throws Exception
     */
    @RequestMapping("/updateUser.action")
    public  ModelAndView updateUser(int id) throws Exception {
        User user=userService.query(id);
        ModelAndView modelAndView=new ModelAndView();
        modelAndView.setViewName("user/showUpdateUser");
        modelAndView.addObject("user",user);
        return modelAndView;
    }   
    /**
     * 修改用户提交
     * @param user
     * @return
     * @throws Exception
     */
    @RequestMapping("/updateUserF.action")
    public ModelAndView updateUser(User user) throws Exception {
        userService.update(user);
        return selectUser(null,null);
    }   
    /**
     * 删除用户
     * @return
     * @throws Exception 
     */
    @RequestMapping("/removeUser.action")
    public ModelAndView removeUser(int[] ids ) throws Exception {
        for(int i:ids) {
            userService.delete(i);
        }
        return selectUser(null,null);
    }   
}

SSH框架模板

继续阅读

Justin_第1组_2009.4.2

数据流图的设计

mvc原理和mvc模式的优缺点

AS3 类库

VS2010/MFC编程入门之二（利用MFC向导生成单文档应用程序框架）

VS2010/MFC编程入门之四（MFC应用程序框架分析）

推技术聊天室的实现(下)

领域建模实现思考

项目管理那些事儿

pmbok学习笔记（1）

wecenter二次开发系列（三）——多个wc框架同域网站共享cookie

下载APP显示服务器检索信息出错 ”RPC:S-7:AEC-0“等

SSM框架（二）------------表现层的SpringMVC

Intellij idea基于Maven 的SSM 框架整合

阿里巴巴分布式服务框架 Dubbo 团队成员梁飞专访

sshd dead but subsys locked问题解决