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内容如下
[html] view plain copy
- <?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"
- 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">
- <!-- classpath 是指什么呢 -->
- <context:property-placeholder location="classpath:db.properties" />
- <!-- 使用annotation -->
- <context:annotation-config/>
- <!-- 使用annotation自动注册bean,并检查@Controller, @Service, @Repository注解已被注入 -->
- <context:component-scan base-package="com.kevin.action"/>
- <context:component-scan base-package="com.kevin.service"/>
- <context:component-scan base-package="com.kevin.dao" />
- <!-- data connection setting -->
- <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
- <property name="driverClass" value="${database.driverClassName}"></property>
- <property name="jdbcUrl" value="${database.url}"></property>
- <property name="user" value="${database.username}"></property>
- <property name="password" value="${database.password}"></property>
- <!-- 设置数据库连接池的最大连接数 -->
- <property name="maxPoolSize">
- <value>50</value>
- </property>
- <!-- 设置数据库连接池的最小连接数 -->
- <property name="minPoolSize">
- <value>5</value>
- </property>
- <!-- 设置数据库连接池的初始化连接数 -->
- <property name="initialPoolSize">
- <value>5</value>
- </property>
- <!-- 设置数据库连接池的连接最大空闲时间 -->
- <property name="maxIdleTime">
- <value>20</value>
- </property>
- <!-- c3p0缓存Statement的数量数 -->
- <property name="maxStatements">
- <value>50</value>
- </property>
- <!-- 当连接池里面的连接用完的时候,C3P0一下获取新的连接数 -->
- <property name="acquireIncrement">
- <value>20</value>
- </property>
- </bean>
- <!-- hibernate 管理-->
- <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
- <!-- 引用上面设置的数据源 -->
- <property name="dataSource">
- <ref bean="dataSource" />
- </property>
- <property name="hibernateProperties">
- <props>
- <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
- <prop key="hibernate.autoReconnect">true</prop>
- <prop key="hibernate.hbm2ddl.auto">update</prop>
- <prop key="hibernate.show_sql">true</prop>
- <prop key="hibernate.format_sql">true</prop>
- <!-- 解决session关闭问题 -->
- <prop key="hibernate.enable_lazy_load_no_trans">true</prop>
- <prop key="current_session_context_class">thread</prop>
- <prop key="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</prop>
- <prop key="hibernate.max_fetch_depth">3</prop>
- <prop key="hibernate.connection.url">jdbc:mysql://localhost:3306/TESTDB</prop>
- <prop key="hibernate.connection.driver_class">com.mysql.jdbc.Driver</prop>
- </props>
- </property>
- <!-- 包扫描的方式加载注解类 -->
- <property name="packagesToScan">
- <list>
- <value>com.kevin.entity</value>
- </list>
- </property>
- </bean>
- <!-- 用注解来实现事物管理 -->
- <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
- <property name="sessionFactory" ref="sessionFactory" />
- </bean>
- <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
- </beans>
3. DAO层代码
为了代码的可拓展性,我们把实现与定义分离;在src/main/java/com/kevin/dao下面再建立一个impl包,存放接口的实现类;在dao目录下新建一个UserDao.java接口类(记住是接口,在选择类型的时候要选择接口), 在impl放这个接口的实现类,UserDaoImpl.java
UserDao.java文件内容
[java] view plain copy
- package com.kevin.dao;
- import com.kevin.entity.User;
- import java.util.List;
- /**
- * Created by kinthon on 17-6-23.
- */
- public interface UserDao {
- /**
- * 添加并保存用户
- * @param user
- */
- public void add(User user);
- /**
- * 进行登录
- */
- public boolean login(User user);
- /**
- * 获取用户列表
- */
- public List getUser();
- /**
- * 根据用户Id获取用户信息
- * @param id
- * @return
- */
- public User getUser(int id);
- /**
- * 更新用户信息
- * @param user
- */
- public void update(User user);
- /**
- * 根据用户id删除用户信息
- * @param id
- */
- public void delete(int id);
- }
UserDaoImpl.java 内容
[java] view plain copy
- package com.kevin.dao.impl;
- import com.kevin.dao.UserDao;
- import com.kevin.entity.User;
- import org.hibernate.Query;
- import org.hibernate.SessionFactory;
- import org.springframework.stereotype.Repository;
- import org.springframework.transaction.annotation.Transactional;
- import javax.annotation.Resource;
- import java.util.Iterator;
- import java.util.List;
- /**
- * Created by kinthon on 17-6-23.
- */
- @Transactional(rollbackFor = Exception.class)
- //出现Exception异常回滚
- @Repository("userDao") //进行注入
- public class UserDaoImpl implements UserDao {
- @Resource(name="sessionFactory")
- private SessionFactory sessionFactory;
- @Override
- public void add(User user) {
- sessionFactory.getCurrentSession().save(user);
- }
- @Override
- public boolean login(User user) {
- Iterator<User> it;
- String hsql="FROM User u where u.username=? and u.password=?";
- System.out.println(hsql);
- Query query = sessionFactory.getCurrentSession().createQuery(hsql);
- query.setString(0, user.getUsername());
- query.setString(1, user.getPassword());
- System.out.println(user.getUsername());
- it=query.iterate();
- if(it.hasNext()) {
- System.out.println("true");
- return true;
- } else {
- System.out.println("false");
- return false;
- }
- }
- @Override
- public List getUser() {
- return sessionFactory.getCurrentSession().createQuery("FROM User").list();
- }
- @Override
- public User getUser(int id) {
- return (User)sessionFactory.getCurrentSession().get(User.class, id);
- }
- @Override
- public void update(User user) {
- sessionFactory.getCurrentSession().update(user);
- }
- @Override
- public void delete(int id) {
- sessionFactory.getCurrentSession().delete(
- sessionFactory.getCurrentSession().get(User.class, id)
- );
- }
- }