使用idea搭建SSH

左手的ㄟ右手 2021-10-18 07:12 548阅读 0赞

# 一、新建项目 #

1.  选中Spring  
    ![1622529-20190601134347751-1375001046.png][]  
    ![1622529-20190601134434275-246448238.png][]
    
     
    
     
2.  strust2  
    ![1622529-20190601134504040-1155731179.png][]
    
     
3.  hibernate  
    ![1622529-20190601134519555-1769856087.png][]

# 二、见项目根路径下的lib下的jar移动到WEB-INF下 #

1.  移动  
    ![1622529-20190601134944691-733813441.png][]
    
     
2.  修改路径  
    ![1622529-20190601135258080-1256447945.png][]  
      
    
3.  在lib目录下导入【c3p0-0.9.5.2.jar】、【mysql-connector-java-5.1.7-bin.jar】并加载到项目  
    ![1622529-20190601135500204-580400380.png][]

# 三、配置文件 #

1.  web.xml
    
    ![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]
    
        <?xml version="1.0" encoding="UTF-8"?>
        <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
                 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                 xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
                 version="4.0">
            
            <listener>
                <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
            </listener>
            
            <context-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:spring/applicationContext-*.xml</param-value>
            </context-param>
            
            <filter>
                <filter-name>openSessionInViewFilter</filter-name>
                <filter-class>org.springframework.orm.hibernate5.support.OpenSessionInViewFilter</filter-class>
            </filter>
            <filter-mapping>
                <filter-name>openSessionInViewFilter</filter-name>
                <url-pattern>/*</url-pattern>
            </filter-mapping>
            
            <filter>
                <filter-name>struts2</filter-name>
                <filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class>
            </filter>
            <filter-mapping>
                <filter-name>struts2</filter-name>
                <url-pattern>/*</url-pattern>
            </filter-mapping>
        </web-app>
    
    web.xml
2.  jdbc.properties
    
    ![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]
    
        hibernate.dialect=org.hibernate.dialect.MySQLDialect
        jdbc.driverClassName=com.mysql.jdbc.Driver
        jdbc.validationQuery=SELECT 1
        jdbc.url=jdbc:mysql://localhost:3306/stu_return_late?useUnicode=true&characterEncoding=UTF-8
        jdbc.username=root
        jdbc.password=123456
        
        
        hibernate.hbm2ddl.auto=update
        hibernate.show_sql=true
        hibernate.format_sql=true
    
    jdbc.properties
    
     
3.  log4j.properties
    
    ![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]
    
        # This is the configuring for logging displayed in the Application Server
        log4j.rootLogger=INFO, stdout,file
        log4j.addivity.org.apache=true
        log4j.appender.stdout=org.apache.log4j.ConsoleAppender
        log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
        log4j.appender.stdout.layout.ConversionPattern= %p [%d] %c{1}.%M(%L) | %m%n
        
        log4j.appender.file=org.apache.log4j.FileAppender
        log4j.appender.file.File=D:\\logs\\test.log
        log4j.appender.file.layout=org.apache.log4j.PatternLayout
        log4j.appender.file.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss,SSS} [%c]-[%p] %m%n
        
        log4j.logger.org.acegisecurity.context=DEBUG
        log4j.logger.org.apache.commons=ERROR
        log4j.logger.org.springframework=INFO
        log4j.logger.org.hibernate.ps.PreparedStatementCache=WARN
        log4j.logger.org.hibernate=WARN
        log4j.logger.org.hibernate.SQL=ERROR
        log4j.logger.org.hibernate.type=ERROR
        
        ##############################################
        
        handlers = org.apache.juli.FileHandler, java.util.logging.ConsoleHandler    
        
        ############################################################
        # Handler specific properties.
        # Describes specific configuration info for Handlers.
        ############################################################
        
        #org.apache.juli.FileHandler.level = FINE
        #org.apache.juli.FileHandler.directory = ../logs/
        #org.apache.juli.FileHandler.prefix = error-debug.
        #
        #java.util.logging.ConsoleHandler.level = FINE
        #java.util.logging.ConsoleHandler.formatter = java.util.logging.SimpleFormatter
    
    log4j.properties
    
     
4.  spring
    
    ![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]
    
        <?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: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">
        
            
            <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
                <property name="driverClass" value="${jdbc.driverClassName}"/>
                <property name="jdbcUrl" value="${jdbc.url}"/>
                <property name="user" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
                
                <property name="idleConnectionTestPeriod" value="300"></property>
                
                <property name="maxIdleTime" value="900"></property>
                
                <property name="maxPoolSize" value="40"></property>
                <property name="minPoolSize" value="1"></property>
                <property name="initialPoolSize" value="1"></property>
            </bean>
        
            
            <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
                
                <property name="dataSource" ref="dataSource"/>
                
                <property name="packagesToScan" value="com.stureturnlate.moudels.sys.vo" />
                
                <property name="hibernateProperties">
                    <props>
                        <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
                        <prop key="hibernate.dialect">${hibernate.dialect}</prop>
                        <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                        <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
                        <prop key="hibernate.connection.url">jdbc:mysql://localhost:3306/stu_return_late</prop>
                        <prop key="hibernate.connection.driver_class">com.mysql.jdbc.Driver</prop>
                    </props>
                </property>
            </bean>
        
            
            <bean id="hibernateTemplate" class="org.springframework.orm.hibernate5.HibernateTemplate">
                <property name="sessionFactory" ref="sessionFactory"></property>
            </bean>
        
            
            <bean id="txManager"
                  class="org.springframework.orm.hibernate5.HibernateTransactionManager">
                <property name="sessionFactory" ref="sessionFactory" />
            </bean>
        
            
            <tx:annotation-driven transaction-manager="txManager" proxy-target-class="true" />
        
            
            <tx:advice id="txAdvice" transaction-manager="txManager">
                <tx:attributes>
                    <tx:method name="query*" read-only="true" propagation="REQUIRED" />
                    <tx:method name="find*" read-only="true" propagation="REQUIRED" />
                    <tx:method name="select*" read-only="true" propagation="REQUIRED" />
                    <tx:method name="*" propagation="REQUIRED" />
                </tx:attributes>
            </tx:advice>
        
            
            <aop:config proxy-target-class="true">
                <aop:pointcut expression="execution(* *..service..*Service*.*(..))" id="serviceMethod" />
                <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceMethod" />
            </aop:config>
        </beans>
    
    applicationContext-hibernate.xml
    
    ![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]
    
        <?xml version="1.0" encoding="UTF-8"?>
        <beans xmlns="http://www.springframework.org/schema/beans"  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
            xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
        
            
            <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
                <property name="locations">
                    <list>
                        <value>classpath:jdbc.properties</value>
                    </list>
                </property>
            </bean>
        
        </beans>
    
    applicationContext-resource.xml
    
    ![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]
    
        <?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:context="http://www.springframework.org/schema/context"
               xmlns:task="http://www.springframework.org/schema/task"
               xsi:schemaLocation="http://www.springframework.org/schema/beans
                http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
                http://www.springframework.org/schema/context
                http://www.springframework.org/schema/context/spring-context-3.0.xsd
                http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-3.0.xsd
        ">
            <task:annotation-driven/>
             
            <context:component-scan base-package="com.stureturnlate.moudels.sys.dao"/>
            
            <context:component-scan base-package=" com.stureturnlate.moudels.sys.service"/>
            
            
        </beans>
    
    applicationContext-service.xml
    
     
5.  strust
    
    ![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]
    
        <?xml version="1.0" encoding="UTF-8"?>
        <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.5//EN" "http://struts.apache.org/dtds/struts-2.5.dtd">
        
        <struts>
        
            
            <constant name="struts.objectFactory" value="spring" />
        
            <constant name="struts.enable.DynamicMethodInvocation" value="true"/>
            
            <constant name="struts.ui.theme" value="simple"></constant>
            
            
            <constant name="struts.convention.package.locators.basePackage" value="com" />
        
        
            
            <constant name="struts.i18n.encoding" value="utf-8" />
        
            <package name="defaultPackage" namespace="/" extends="struts-default">
        
            </package>
        
            <include file="strust/struts-sys.xml"/>
            <include file="strust/struts-biz.xml"/>
            <include file="strust/struts-app.xml"/>
        </struts>
    
    struts.xml
    
    struts-app.xml、struts-biz.xml、struts-sys.xml....
    
    ![1622529-20190601140509443-921560868.png][]

# 四、新建数据表，并反向映射实体类 #

1.  建好数据库表  
    ![1622529-20190601140538295-376273072.png][]
    
     
2.  打开Persistence选项：**View**→**Tool Windows**→**Persistence  
    ![1622529-20190601140811334-901539575.png][]**
    
     
3.  在hibernateGen上右键，进行如下操作  
    ![1622529-20190601140939632-1450548271.png][]
    
     
4.  生成  
    ![1622529-20190601141031617-833332065.png][]
    
     
5.  结果  
    ![1622529-20190601141111862-123615153.png][]

# 报错：java.lang.ClassNotFoundException: org.springframework.web.context.ContextLoaderListener #

1.  原因：项目未引入【spring-web-5.1.5.RELEASE.jar】
2.  解决办法：下载【[spring-web-5.1.5.RELEASE.jar][]】

# 报错：Cannot resolve method 'getContextPath() #

1.  如图  
    ![1622529-20190601145152887-604545110.png][]
    
     
2.  原因：缺少了【[javax.servlet-api-3.1.0.jar][]】和【[jsp-api-2.0.jar][]】  
    ![1622529-20190601145516390-896155668.png][]

# 配置AOP报错：Could not find bean with name 'org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor #

*  原因，缺少了包【[aopalliance-1.0.jar][]】和【[aspectjweaver-1.9.2.jar][]】

# 配置C3P0报错：Error creating bean with name 'dataSource'--Caused by: java.lang.NoClassDefFoundError: com/mchange/v2/ser/Indirector #

*  原因：使用c3p0时要导入两个包【[c3p0-0.9.5.2.jar][]】和【mchange-commons-java-0.2.11.jar】

# 实体类外键映射报错：Caused by: org.hibernate.MappingException: Repeated column in mapping for entity: com.stureturnlate.moudels.sys.vo.HostelEntity column: dorm\_id (should be mapped with insert="false" update="false") #

# 报错：Caused by: Cannot locate the chosen ObjectFactory implementation: spring - \[unknown location\] #

1.  在Strust.xml配置了还在报错,缺少整合Struts和Spring的Jar  
    ![1622529-20190602093658916-239586510.png][]
    
     
2.  原因：少了【[struts2-spring-plugin-2.5.20.jar][]】

#  启动tomcat报错：java.lang.ClassNotFoundException: org.apache.jsp.index\_jsp #

1.  如图：  
    ![1622529-20190602095217634-432794654.png][]
    
     
2.  看看是不是少了这几个包【[servlet-api-2.5.jar][]】和【[jsp-api-2.1.jar][]】和【[jstl-1.2.jar][]】

# 页面404：strust无法用通配符执行action的方法 #

1.  原因：使用了新版本的strust2
2.  解决办法：在strust2的配置文件中加入【strict-method-invocation="false"】  
    ![1622529-20190602111955732-1932707454.png][]

# 项目中用到JSON,配置struts.xml时遇到json-default发红：Cannot resolve Struts Package 'json-default' #

1.  如图：  
    ![1622529-20190603094911767-714659524.png][]
    
     
2.  原因：缺少了【[struts2-json-plugin-2.5.20.jar][]】  
      
    
3.  解决办法：  
    一、项目导入包  
    二、到Project Structure条件strust配置文件  
    三、如下图：  
    ![1622529-20190603095351259-1175288529.png][]

# SSH框架下Ajax与Action交互数据时报错：org.apache.struts2.json.JSONException: java.lang.reflect.InvocationTargetException #

*  根本原因是：是Hibernate的懒加载引起的。就是在传递的数据中有引用类型的数据采用了懒加载机制。

# 主键(int)查询报错：java.lang.IllegalArgumentException: org.hibernate.TypeMismatchException: Provided id of the wrong type for class com.stureturnlate.moudels.sys.vo.StudentEntity. Expected: class java.lang.String, got class java.lang.Integer #

## 第一种可能： ##

*   原因：实体类的hibernate映射文件没有指定字段属性的sql-type，导致查询的时候默认String  
    ![1622529-20190608093902578-1786544928.png][]
    
     
 *  解决办法：在生成实体类的时候这样子勾选：  
    ![1622529-20190608094021202-1745805454.png][]

## 第二种可能： ##

*  使用了hibernate的get方法查询
    
        Session currentSession = sessionFactory.openSession();
        return currentSession.get(StudentEntity.class, 主键id);
        //return currentSession.load(StudentEntity.class, 主键id);--懒加载查询
    
     
 *  使用这种方法查询，查询条件必须为主键，且类型要与主键匹配

## 第三种可能： ##

*  外键查询
 *  解决办法：（qbc查询）
    
    ![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]
    
        if (studentEntity.getUserId() != null) {
        
                    Criteria cr=currentSession.createCriteria(StudentEntity.class);//userId为student外键，为sysUser主键
        //            cr.add(Restrictions.eq("sysUser.userId", studentEntity.getUserId()));//是外键的直接用，没问题
                    cr.add(Restrictions.eq("userId", studentEntity.getUserId()));//是外键的直接用，没问题
                    //cr.add(Restrictions.eq("sysUser.userName", "aaa"));//报错
        //            cr.createAlias("sysUser", "sysUser").add(Restrictions.eq("sysUser.userName", "黄结"));//不是外键的定义别名,不会报错
        
                    list = cr.list();
        //            return (StudentEntity) cr.list().get(0);
                } else {
        
                    CriteriaBuilder criteriaBuilder = currentSession.getCriteriaBuilder();
        
                    CriteriaQuery<StudentEntity> query = criteriaBuilder.createQuery(StudentEntity.class);
        
                    Root<StudentEntity> root = query.from(StudentEntity.class);
        
                    Predicate studentId = criteriaBuilder.equal(root.get("studentId"), studentEntity.getStudentId());
        
                    query.where(studentId);
        
                    list = currentSession.createQuery(query).list();
        
                }
                return list.size()>0&&list!=null?list.get(0):null;
    
    例子

#  jsp页面向后台action绑定模型驱动Date类型的属性：No result defined for action com.stureturnlate.moudels.biz.action.student.StudentAction and result input #

*  原因：该实体类的Date属性使用了【java.sql.Date】
 *  解决办法：改为【java.util.Date】

转载于:https://www.cnblogs.com/HuangJie-sol/p/10959447.html

[1622529-20190601134347751-1375001046.png]: /images/20211018/791de6be53ea425ca2a85d85799f8dde.png
[1622529-20190601134434275-246448238.png]: /images/20211018/dcf3464a725c49da9e854f7bfe342205.png
[1622529-20190601134504040-1155731179.png]: /images/20211018/625e6b757afe4157bc4e5036693bc324.png
[1622529-20190601134519555-1769856087.png]: /images/20211018/51c66f8f46b842daa4d93a4a110062dc.png
[1622529-20190601134944691-733813441.png]: /images/20211018/2e23a7b71fbc4a1ba1aaf969e40f9ea1.png
[1622529-20190601135258080-1256447945.png]: /images/20211018/6ce4e11337ea404d91e7cf40dcd4ac8a.png
[1622529-20190601135500204-580400380.png]: /images/20211018/dc9e4c1a46b94c929951090b52c3570c.png
[ContractedBlock.gif]: https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211018/9230fd57a370497abfd82a432ca0c446.png
[1622529-20190601140509443-921560868.png]: /images/20211018/0c70b0b622c746d7aadbf711f562a16d.png
[1622529-20190601140538295-376273072.png]: /images/20211018/a230c6f7f1714cbe872062dbc5632712.png
[1622529-20190601140811334-901539575.png]: /images/20211018/825604b5603b4af999f77f10e5a85940.png
[1622529-20190601140939632-1450548271.png]: /images/20211018/025196d9b3374cd688be6a1ae067cf94.png
[1622529-20190601141031617-833332065.png]: /images/20211018/289634a0460c417e8775a5a704b81861.png
[1622529-20190601141111862-123615153.png]: /images/20211018/80b805e9aaa642d28420caebe84b0f74.png
[spring-web-5.1.5.RELEASE.jar]: http://central.maven.org/maven2/org/springframework/spring-web/5.1.5.RELEASE/spring-web-5.1.5.RELEASE.jar
[1622529-20190601145152887-604545110.png]: /images/20211018/d5ec1d6032e94f65b2d68fb5a53e4e9f.png
[javax.servlet-api-3.1.0.jar]: http://central.maven.org/maven2/javax/servlet/jsp-api/2.0/jsp-api-2.0.jar
[jsp-api-2.0.jar]: http://central.maven.org/maven2/javax/servlet/javax.servlet-api/3.1.0/javax.servlet-api-3.1.0.jar
[1622529-20190601145516390-896155668.png]: /images/20211018/de1907e38332436f9c38bcadec8d66b6.png
[aopalliance-1.0.jar]: http://central.maven.org/maven2/aopalliance/aopalliance/1.0/aopalliance-1.0.jar
[aspectjweaver-1.9.2.jar]: http://central.maven.org/maven2/org/aspectj/aspectjweaver/1.9.2/aspectjweaver-1.9.2.jar
[c3p0-0.9.5.2.jar]: http://central.maven.org/maven2/com/mchange/c3p0/0.9.5.2/c3p0-0.9.5.2.jar
[1622529-20190602093658916-239586510.png]: /images/20211018/b61e5a1281bc4eaeafd1a4775133d09a.png
[struts2-spring-plugin-2.5.20.jar]: http://central.maven.org/maven2/org/apache/struts/struts2-spring-plugin/2.5.20/struts2-spring-plugin-2.5.20.jar
[1622529-20190602095217634-432794654.png]: /images/20211018/61a53deaefce4f188957b05a66ef6cd1.png
[servlet-api-2.5.jar]: http://central.maven.org/maven2/javax/servlet/servlet-api/2.5/servlet-api-2.5.jar
[jsp-api-2.1.jar]: http://central.maven.org/maven2/javax/servlet/jsp/jsp-api/2.1/jsp-api-2.1.jar
[jstl-1.2.jar]: http://central.maven.org/maven2/javax/servlet/jstl/1.2/jstl-1.2.jar
[1622529-20190602111955732-1932707454.png]: https://img2018.cnblogs.com/blog/1622529/201906/1622529-20190602111955732-1932707454.png
[1622529-20190603094911767-714659524.png]: https://img2018.cnblogs.com/blog/1622529/201906/1622529-20190603094911767-714659524.png
[struts2-json-plugin-2.5.20.jar]: http://central.maven.org/maven2/org/apache/struts/struts2-json-plugin/2.5.20/struts2-json-plugin-2.5.20.jar
[1622529-20190603095351259-1175288529.png]: https://img2018.cnblogs.com/blog/1622529/201906/1622529-20190603095351259-1175288529.png
[1622529-20190608093902578-1786544928.png]: https://img2018.cnblogs.com/blog/1622529/201906/1622529-20190608093902578-1786544928.png
[1622529-20190608094021202-1745805454.png]: https://img2018.cnblogs.com/blog/1622529/201906/1622529-20190608094021202-1745805454.png