koala框架+Mybatis+Oracle

1新建项目

1.1 file->new->other->koala->koalaproject

next

填写相关信息

next

勾选子系统->高级设置

填写信息 点关闭按钮自动保存

Finish->Finish

2修改配置

2.1修改pom.xml(总的)

<url>http://maven.oschina.net/content/repositories/koala-release/</url>

<url>http://maven.oschina.net/content/repositories/koala-snapshots/</url>

2.2修改persistence-context.xml

添加一个bean

<beanid="entityManagerFactory" class="org.openkoala.koala.util.KoalaEntityManagerFactoryBean">

                   <propertyname="persistenceUnitName" value="default" />

                   <propertyname="packagesToScan">

                            <list>

                                     <value>com.dhcc.DrgResource.core.domain</value>

                                     <value>org.openkoala.gqc.core.domain</value>

                                     <value>org.openkoala.businesslog.model</value>

                                     <value>org.openkoala.security.core.domain</value>

                                     <value>org.openkoala.organisation.core.domain</value>

                                     <value>org.openkoala.security.org.core.domain</value>

                                     <value>org.openkoala.example.domain</value>

                            </list>

                   </property>

                   <!-- 如果权限使用了不同的数据源，则去掉securitymappings -->

                   <propertyname="scanMappingResourceDir" value="mappings" />

                   <propertyname="dataSource" ref="dataSource" />

                   <propertyname="jpaVendorAdapter">

                            <beanclass="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">

                                     <propertyname="database"value="${database.Type}"></property>

                                     <propertyname="showSql"value="${hibernate.show_sql}"></property>

                                     <propertyname="generateDdl" value="${generateDdl}"></property>

                                     <propertyname="databasePlatform"value="${db.jdbc.dialect}"></property>

                            </bean>

                   </property>

         </bean>

3修改项目源码

3.1***–core层   修改MenuResource.java

@Column(name= "LEVEL")==》@Column(name = "LEVEL_")

3.2数据库中创建序列  hibernate_sequence

　　create sequence hibernate_sequence

　　minvalue 0

　　maxvalue 99999999

　　start with 1

　　increment by 1;

3.3 ***–core层  修改Authority.java

Authority.findAllAuthoritiesByUserAccount  里面找到相应的语句把group by去掉

修改SecurityAccessFacadeImpl.java

SecurityAccessFacadeImpl.findTopMenuResourceByUserAccountAsRole   把group by去掉

SecurityAccessFacadeImpl.findAllMenuResourceByUserAccountAsRole把group by去掉

3.4***–core层 修改SecurityAccessFacadeImpl.java

SecurityAccessFacadeImpl.findTopMenuResource  把group by去掉

SecurityAccessFacadeImpl.findChidrenMenuResource    把group by去掉

 

3.5 ***–core层 ResourceAssignment.java

ResourceAssignment.findSecurityResourcesByAuthorities  把group by 去掉