1.导入依赖
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<spring.version>3.1.1.RELEASE</spring.version>
<hibernate.version>3.6.5.Final</hibernate.version>
<struts2.version>2.3.1</struts2.version>
</properties>
<dependencies>
<!--这两个是jstl所需要用的依赖包-->
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/javax.servlet/jstl -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--=-=-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<!-- 让Servlet-api在编译的时候,能够让编译器找到对应的类,运行的时候无效 -->
<scope>provided</scope>
</dependency>
<!-- 打印日志所需的依赖 -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- 界面的所需的依赖 -->
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
<scope>provided</scope>
</dependency>
<!-- 单元测试所需依赖 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
<!-- spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>cglib</groupId>
<artifactId>cglib-nodep</artifactId>
<version>2.1_3</version>
</dependency>
<!-- hibernate -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>${hibernate.version}</version>
</dependency>
<!-- struts2 -->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-core</artifactId>
<version>${struts2.version}</version>
</dependency>
<!--config-browser-plugin插件,使用了这个插件之后,就可以很方便的浏览项目中的所有action及其与 jsp view的映射 -->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-junit-plugin</artifactId>
<version>${struts2.version}</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-spring-plugin</artifactId>
<version>${struts2.version}</version>
</dependency>
<!-- 添加对数据库的支持 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.0.5</version>
</dependency>
<!-- 添加对数据源的支持 -->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-war-plugin</artifactId>
<version>2.2</version>
<configuration>
<webResources>
<resource>
<directory>src\main\webapp</directory>
</resource>
</webResources>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>1.6</source>
<target>1.6</target>
</configuration>
</plugin>
</plugins>
<finalName>com</finalName>
</build>
2.在src/main下建立四个包,分别为cn.itlaobing.dao cn.itlaobing.entity cn.itlaobing.service cn.itlaobing.action;
①entity是Hibernate对于数据库抽象出来的类,与数据库完全对应,后期可自动生成自动生成
②action是表示层,控制页面的跳转(负责调用业务逻辑的服务组件)
3.点击file,选择project structs...添加web,(使其变成web项目),之后自动生成WEB-INF和web.xml文件,在WEB-INF下建立index.jsp文件;此时webapp就是tomcat目录;
二:JAVA代码层
1.生成entity
①建立Database,在IDEA界面的右边点击Database-->Data Source;之后添加配置,之后进行Test Connection;
②操作,自动生成Entity;我们可以看到在Idea界面里面看不到Persistence选项(将鼠标悬浮在左下角的正方形那里,截图如下),因为一开始使用maven来搭建项目,我们并没有显示引入hibernate,所以没有Persistence界面,所以我们作如下操作来显示加入Hibernate; 点击 File-----> Project Structure------>Modules----->点击+-------->选择Hibernate------>Apply------>OK; 看界面,我们可以看到 Persistence出现了,截图如下:
2.配置applicationContext.xml.applicationContext.xml是spring的配置文件,让spring接管Hibernate 配置工作(将Hiberante的配置内容写到spring中),并建立db.properties文件(相当于txt文件),并将这两个文件都写到src/main/resources下
applicationContext.xml内容如下
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:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
5. 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">
6. <!-- classpath 是指什么呢 -->
7. <context:property-placeholder location="classpath:db.properties" />
8.
9. <!-- 使用annotation -->
10. <context:annotation-config/>
11. <!-- 使用annotation自动注册bean,并检查@Controller, @Service, @Repository注解已被注入 -->
12. <context:component-scan base-package="com.kevin.action"/>
13. <context:component-scan base-package="com.kevin.service"/>
14. <context:component-scan base-package="com.kevin.dao" />
15.
16. <!-- data connection setting -->
17. <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
18. <property name="driverClass" value="${database.driverClassName}"></property>
19. <property name="jdbcUrl" value="${database.url}"></property>
20. <property name="user" value="${database.username}"></property>
21. <property name="password" value="${database.password}"></property>
22. <!-- 设置数据库连接池的最大连接数 -->
23. <property name="maxPoolSize">
24. <value>50</value>
25. </property>
26. <!-- 设置数据库连接池的最小连接数 -->
27. <property name="minPoolSize">
28. <value>5</value>
29. </property>
30. <!-- 设置数据库连接池的初始化连接数 -->
31. <property name="initialPoolSize">
32. <value>5</value>
33. </property>
34. <!-- 设置数据库连接池的连接最大空闲时间 -->
35. <property name="maxIdleTime">
36. <value>20</value>
37. </property>
38. <!-- c3p0缓存Statement的数量数 -->
39. <property name="maxStatements">
40. <value>50</value>
41. </property>
42. <!-- 当连接池里面的连接用完的时候,C3P0一下获取新的连接数 -->
43. <property name="acquireIncrement">
44. <value>20</value>
45. </property>
46.
47. </bean>
48.
49. <!-- hibernate 管理-->
50. <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
51. <!-- 引用上面设置的数据源 -->
52. <property name="dataSource">
53. <ref bean="dataSource" />
54. </property>
55.
56. <property name="hibernateProperties">
57. <props>
58. <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
59. <prop key="hibernate.autoReconnect">true</prop>
60. <prop key="hibernate.hbm2ddl.auto">update</prop>
61. <prop key="hibernate.show_sql">true</prop>
62. <prop key="hibernate.format_sql">true</prop>
63. <!-- 解决session关闭问题 -->
64. <prop key="hibernate.enable_lazy_load_no_trans">true</prop>
65. <prop key="current_session_context_class">thread</prop>
66.
67. <prop key="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</prop>
68. <prop key="hibernate.max_fetch_depth">3</prop>
69. <prop key="hibernate.connection.url">jdbc:mysql://localhost:3306/TESTDB</prop>
70. <prop key="hibernate.connection.driver_class">com.mysql.jdbc.Driver</prop>
71. </props>
72.
73. </property>
74.
75. <!-- 包扫描的方式加载注解类 -->
76. <property name="packagesToScan">
77. <list>
78. <value>com.kevin.entity</value>
79. </list>
80. </property>
81. </bean>
82.
83. <!-- 用注解来实现事物管理 -->
84. <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
85. <property name="sessionFactory" ref="sessionFactory" />
86. </bean>
87. <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
88. </beans>
3. DAO层代码
为了代码的可拓展性,我们把实现与定义分离;在src/main/java/com/kevin/dao下面再建立一个impl包,存放接口的实现类;在dao目录下新建一个UserDao.java接口类(记住是接口,在选择类型的时候要选择接口), 在impl放这个接口的实现类,UserDaoImpl.java
UserDao.java文件内容
1. package com.kevin.dao;
2.
3. import com.kevin.entity.User;
4.
5. import java.util.List;
6.
7. /**
8. * Created by kinthon on 17-6-23.
9. */
10. public interface UserDao {
11. /**
12. * 添加并保存用户
13. * @param user
14. */
15. public void add(User user);
16.
17. /**
18. * 进行登录
19. */
20. public boolean login(User user);
21.
22.
23. /**
24. * 获取用户列表
25. */
26. public List getUser();
27.
28. /**
29. * 根据用户Id获取用户信息
30. * @param id
31. * @return
32. */
33. public User getUser(int id);
34.
35. /**
36. * 更新用户信息
37. * @param user
38. */
39. public void update(User user);
40.
41.
42. /**
43. * 根据用户id删除用户信息
44. * @param id
45. */
46. public void delete(int id);
47.
48. }
UserDaoImpl.java 内容
1. package com.kevin.dao.impl;
2.
3. import com.kevin.dao.UserDao;
4. import com.kevin.entity.User;
5. import org.hibernate.Query;
6. import org.hibernate.SessionFactory;
7. import org.springframework.stereotype.Repository;
8. import org.springframework.transaction.annotation.Transactional;
9.
10. import javax.annotation.Resource;
11. import java.util.Iterator;
12. import java.util.List;
13.
14. /**
15. * Created by kinthon on 17-6-23.
16. */
17.
18. @Transactional(rollbackFor = Exception.class)
19. //出现Exception异常回滚
20. @Repository("userDao") //进行注入
21. public class UserDaoImpl implements UserDao {
22. @Resource(name="sessionFactory")
23. private SessionFactory sessionFactory;
24.
25. @Override
26. public void add(User user) {
27. sessionFactory.getCurrentSession().save(user);
28. }
29.
30. @Override
31. public boolean login(User user) {
32. Iterator<User> it;
33. String hsql="FROM User u where u.username=? and u.password=?";
34. System.out.println(hsql);
35. Query query = sessionFactory.getCurrentSession().createQuery(hsql);
36. query.setString(0, user.getUsername());
37. query.setString(1, user.getPassword());
38. System.out.println(user.getUsername());
39. it=query.iterate();
40. if(it.hasNext()) {
41. System.out.println("true");
42. return true;
43. } else {
44. System.out.println("false");
45. return false;
46. }
47. }
48.
49. @Override
50. public List getUser() {
51. return sessionFactory.getCurrentSession().createQuery("FROM User").list();
52. }
53.
54. @Override
55. public User getUser(int id) {
56. return (User)sessionFactory.getCurrentSession().get(User.class, id);
57. }
58.
59. @Override
60. public void update(User user) {
61. sessionFactory.getCurrentSession().update(user);
62. }
63.
64. @Override
65. public void delete(int id) {
66. sessionFactory.getCurrentSession().delete(
67. sessionFactory.getCurrentSession().get(User.class, id)
68. );
69. }
70. }