Spring+SpringMVC+Hibernate三大框架整合
- 测试表
User_Login(
u_id int,
u_name varchar(50),
u_age int,
u_sex varchar(50),
u_tel varchar(50),
u_pwd varchar(50),
)
- 使用的工具有eclipse,maven,Sql Server2012
- 项目结构
- ![这里写图片描述](https://img-blog.csdn.net/20170827141731746?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvcXFfMzU4NzMxMDI=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
- 这里我使用的是Maven来管理的,所以先创建一个Maven Web工程
- 所需要的jar包依赖
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.yzkj</groupId>
<artifactId>spring_springmvc_Hibernate</artifactId>
<packaging>war</packaging>
<version>0.0.1-SNAPSHOT</version>
<name>spring_springmvc_Hibernate Maven Webapp</name>
<url>http://maven.apache.org</url>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- Hibernate Core -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>4.3.5.Final</version>
</dependency>
<!-- MySQL JDBC driver -->
<dependency>
<groupId>com.hynnet</groupId>
<artifactId>sqljdbc4-chs</artifactId>
<version>4.0.2206.100</version>
</dependency>
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-dbcp2</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>com.jspsmart.upload</groupId>
<artifactId>smartupload</artifactId>
<version>1.2.6</version>
</dependency>
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-core</artifactId>
<version>2.5</version>
</dependency>
<!-- Spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.2.RELEASE</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<!-- spring测试包 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>4.3.2.RELEASE</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.8.2</version>
</dependency>
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-slf4j-impl</artifactId>
<version>2.6.2</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.9</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>4.3.10.RELEASE</version>
</dependency>
</dependencies>
<build>
<finalName>spring_springmvc_Hibernate</finalName>
</build>
</project>
- db.properties属性文件配置如下:
#application configs
#jdbc c3p0 config
jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url = jdbc:sqlserver://localhost:1433;databaseName=Test
jdbc.username = sa
jdbc.password = a
#hibernate config
hibernate.dialect = org.hibernate.dialect.SQLServerDialect
hibernate.show_sql = true
hibernate.format_sql = true
hibernate.hbm2ddl.auto = update
hibernate.cache.use_second_level_cache = true
hibernate.cache.use_query_cache = true
hibernate.cache.region.factory_class = org.hibernate.cache.ehcache.EhCacheRegionFactory
hibernate.cache.provider_configuration_file_resource_path = ehcache.xml
- spring.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:util="http://www.springframework.org/schema/util" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" 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/util
http://www.springframework.org/schema/util/spring-util.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 指定可以做为spring容器管理的对象的包 -->
<context:component-scan base-package="com.yzkj" />
<!-- 引入外部的属性文件 -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 配置数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
<property name="driverClassName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!-- 配置hibernate的SessionFactory -->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="packagesToScan">
<list>
<value>com.yzkj.login.entity</value>
</list>
</property>
<!-- 注入数据源 相关信息看源码 -->
<property name="dataSource" ref="dataSource" />
<!-- hibernate配置信息 -->
<property name="hibernateProperties">
<props>
<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.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
<prop key="hibernate.current_session_context_class">org.springframework.orm.hibernate4.SpringSessionContext</prop>
</props>
</property>
<!-- 扫描hibernate注解配置的entity
<property name="mappingLocations">
<list>
<value>classpath*:EntityMapper/*.hbm.xml</value>
</list>
</property>-->
</bean>
<!--简化JDBC的操作 -->
<bean id="jdbcTemplate"
class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource">
<ref bean="dataSource"/>
</property>
</bean>
<!-- 事务的注解 -->
<tx:annotation-driven transaction-manager="transactionManager" />
<!-- 配置事务管理器 -->
<bean id="transactionManager"
class="org.springframework.orm.hibernate4.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
</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:util="http://www.springframework.org/schema/util"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/util
http://www.springframework.org/schema/util/spring-util.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!-- 指定可以做为spring-mvc容器管理的对象的包 -->
<context:component-scan base-package="com.yzkj.login.web.handler" />
<!-- 配制 springmv视图处理器的bean -->
<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/"/> <!-- 给视图加上前缀 -->
<property name="suffix" value=".jsp"/> <!-- 给视图加上后缀名 如:视图是success ==》 success.jsp -->
</bean>
<!-- 只拦截处理handler, 其它页面不处理 -->
<mvc:default-servlet-handler/>
<mvc:annotation-driven/>
</beans>
- log4j.xml日志配置内容如下:
<?xml version="1.0" encoding="UTF-8"?>
<Configuration>
<Appenders>
<Console name="STDOUT" target="SYSTEM_OUT">
<PatternLayout pattern="%d %-5p %C{1} (%F:%L) - %m%n"/>
</Console>
</Appenders>
<Loggers>
<Logger name="com.yzkj" level="debug"/>
<Logger name="org.apache.ibatis.logging.jdbc" level="debug"/>
<Root level="error">
<AppenderRef ref="STDOUT"/>
</Root>
</Loggers>
</Configuration>
ps:这里没有配置全面,只是基本的配置,大家可以根据需要添加其他的配置
web.xml的配置内容如下:
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring.xml</param-value>
</context-param>
<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>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<filter>
<filter-name>hiddenHttpMethodFilter</filter-name>
<filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>hiddenHttpMethodFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<filter>
<filter-name>openSessionInViewFilter</filter-name>
<filter-class>org.springframework.orm.hibernate4.support.OpenSessionInViewFilter</filter-class>
<init-param>
<param-name>singleSession</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>openSessionInViewFilter</filter-name>
<url-pattern>*</url-pattern>
</filter-mapping>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
</web-app>
实体类,此处使用的是注解的方式
package com.yzkj.login.entity;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="User_Login")
public class User_Login {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer u_id;
@Column(insertable = true,length = 50,nullable = false,updatable = true)
private String u_name;
@Column(insertable = true,nullable = false,updatable = true)
private Integer u_age;
@Column(insertable = true,length = 50,nullable = false,updatable = true)
private String u_sex;
@Column(insertable = true,length = 50,nullable = false,updatable = true)
private String u_tel;
@Column(insertable = true,length = 50,nullable = false,updatable = true)
private String u_pwd;
public Integer getU_id() {
return u_id;
}
public void setU_id(Integer u_id) {
this.u_id = u_id;
}
public String getU_name() {
return u_name;
}
public void setU_name(String u_name) {
this.u_name = u_name;
}
public Integer getU_age() {
return u_age;
}
public void setU_age(Integer u_age) {
this.u_age = u_age;
}
public String getU_sex() {
return u_sex;
}
public void setU_sex(String u_sex) {
this.u_sex = u_sex;
}
public String getU_tel() {
return u_tel;
}
public void setU_tel(String u_tel) {
this.u_tel = u_tel;
}
public String getU_pwd() {
return u_pwd;
}
public void setU_pwd(String u_pwd) {
this.u_pwd = u_pwd;
}
public User_Login(Integer u_id, String u_name, Integer u_age, String u_sex,
String u_tel, String u_pwd) {
super();
this.u_id = u_id;
this.u_name = u_name;
this.u_age = u_age;
this.u_sex = u_sex;
this.u_tel = u_tel;
this.u_pwd = u_pwd;
}
public User_Login() {
super();
// TODO Auto-generated constructor stub
}
@Override
public String toString() {
return "User_Login [u_id=" + u_id + ", u_name=" + u_name + ", u_age="
+ u_age + ", u_sex=" + u_sex + ", u_tel=" + u_tel + ", u_pwd="
+ u_pwd + "]";
}
}
现在可以进行单元测试了
import java.sql.SQLException;
import javax.sql.DataSource;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.transaction.annotation.Transactional;
import com.yzkj.login.entity.User_Login;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:spring.xml"})
public class Test_1 {
@Autowired
private DataSource dataSource;
@Autowired
private SessionFactory sessionFactory;
@Test
@Transactional
public void test() throws SQLException {
Session session = sessionFactory.getCurrentSession();
System.out.println(session.get(User_Login.class, 1));
}
}
下面是实现了一个简单的登陆功能,对三大框架整合进行测试
控制分发类handler
package com.yzkj.login.web.handler;
import javax.servlet.http.HttpSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.yzkj.login.entity.User_Login;
import com.yzkj.login.service.UserLoginService;
@Controller
@RequestMapping("/user")
public class UserLoginHandler{
@Autowired
private UserLoginService userLoginService;
@RequestMapping("/login")
@ResponseBody
public boolean doLogin(User_Login user,HttpSession session){
User_Login user_Login = userLoginService.getLogin(user);
if(user_Login!=null){
return true;
}else{
return false;
}
}
}
service接口类
package com.yzkj.login.service;
import org.springframework.stereotype.Component;
import com.yzkj.login.entity.User_Login;
@Component("userLoginService")
public interface UserLoginService {
public User_Login getLogin(User_Login user);
}
service实现类
package com.yzkj.login.service.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.yzkj.login.dao.UserLoginDao;
import com.yzkj.login.entity.User_Login;
import com.yzkj.login.service.UserLoginService;
@Service("userLoginService")
public class UserLoginServiceImpl implements UserLoginService {
@Autowired
private UserLoginDao userLoginDao;
@Override
public User_Login getLogin(User_Login user) {
return userLoginDao.getLogin(user);
}
}
dao层接口类
UserLoginDao 类
package com.yzkj.login.dao;
import com.yzkj.login.entity.User_Login;
public interface UserLoginDao {
User_Login getLogin(User_Login user);
}
BaseDao类
package com.yzkj.login.dao;
import java.io.Serializable;
import java.util.Collection;
import java.util.List;
import org.springframework.jdbc.core.RowMapper;
/**
* @ClassName: IBaseDao
* @Description: Dao封装接口
* @author yz
* @date 2014年6月16日17:05:17
*/
public interface BaseDao<T, ID extends Serializable> {
/**
* <保存实体>
* <完整保存实体>
* @param t 实体参数
*/
public abstract void save(T t);
/**
* <保存或者更新实体>
* @param t 实体
*/
public abstract void saveOrUpdate(T t);
/**
* <load>
* <加载实体的load方法>
* @param id 实体的id
* @return 查询出来的实体
*/
public abstract T load(ID id);
/**
* <get>
* <查找的get方法>
* @param id 实体的id
* @return 查询出来的实体
*/
public abstract T get(ID id);
/**
* <contains>
* @param t 实体
* @return 是否包含
*/
public abstract boolean contains(T t);
/**
* <delete>
* <删除表中的t数据>
* @param t 实体
*/
public abstract void delete(T t);
/**
* <根据ID删除数据>
* @param Id 实体id
* @return 是否删除成功
*/
public abstract boolean deleteById(ID Id);
/**
* <删除所有>
* @param entities 实体的Collection集合
*/
public abstract void deleteAll(Collection<T> entities);
/**
* <执行Hql语句>
* @param hqlString hql
* @param values 不定参数数组
*/
public abstract void queryHql(String hqlString, Object... values);
/**
* <执行Sql语句>
* @param sqlString sql
* @param values 不定参数数组
*/
public abstract void querySql(String sqlString, Object... values);
/**
* <根据HQL语句查找唯一实体>
* @param hqlString HQL语句
* @param values 不定参数的Object数组
* @return 查询实体
*/
public abstract T getByHQL(String hqlString, Object... values);
/**
* <根据SQL语句查找唯一实体>
* @param sqlString SQL语句
* @param values 不定参数的Object数组
* @return 查询实体
*/
public abstract T getBySQL(String sqlString, Object... values);
/**
* <根据HQL语句,得到对应的list>
* @param hqlString HQL语句
* @param values 不定参数的Object数组
* @return 查询多个实体的List集合
*/
public abstract List<T> getListByHQL(String hqlString, Object... values);
/**
* <根据SQL语句,得到对应的list>
* @param sqlString HQL语句
* @param values 不定参数的Object数组
* @return 查询多个实体的List集合
*/
public abstract List<T> getListBySQL(String sqlString, Object... values);
/**
* 由sql语句得到List
* @param sql
* @param map
* @param values
* @return List
*/
public List<?> findListBySql(final String sql, final RowMapper<?> map, final Object... values);
/**
* <refresh>
* @param t 实体
*/
public abstract void refresh(T t);
/**
* <update>
* @param t 实体
*/
public abstract void update(T t);
/**
* <根据HQL得到记录数>
* @param hql HQL语句
* @param values 不定参数的Object数组
* @return 记录总数
*/
public abstract Long countByHql(String hql, Object... values);
}
dao层实现类
BaseDaoImpl类
package com.yzkj.login.dao.impl;
import java.io.Serializable;
import java.lang.reflect.ParameterizedType;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.sql.Types;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.ScrollableResults;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.jdbc.Work;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.yzkj.login.dao.BaseDao;
/**
* @ClassName: BaseDao
* @Description: baseDao实现
* @author yz
* @date 2014年6月16日17:09:52
*
*/
@SuppressWarnings({ "rawtypes", "unchecked" })
@Service("baseDaoImpl")
@Transactional
public class BaseDaoImpl<T, ID extends Serializable> implements BaseDao<T, ID> {
@Autowired
private SessionFactory sessionFactory;
protected Class<T> entityClass;
public BaseDaoImpl() {
}
protected Class getEntityClass() {
if (entityClass == null) {
entityClass = (Class<T>) ((ParameterizedType) getClass().getGenericSuperclass()).getActualTypeArguments()[0];
}
return entityClass;
}
/**
* <保存实体>
* <完整保存实体>
* @param t 实体参数
* @see com.itv.launcher.util.IBaseDao#save(java.lang.Object)
*/
@Override
public void save(T t) {
this.getSession().save(t);
}
/**
* <保存或者更新实体>
* @param t 实体
* @see com.itv.launcher.util.IBaseDao#saveOrUpdate(java.lang.Object)
*/
@Override
public void saveOrUpdate(T t) {
this.getSession().saveOrUpdate(t);
}
/**
* <load>
* <加载实体的load方法>
* @param id 实体的id
* @return 查询出来的实体
* @see com.itv.launcher.util.IBaseDao#load(java.io.Serializable)
*/
@Override
public T load(ID id) {
T load = (T) this.getSession().load(getEntityClass(), id);
return load;
}
/**
* <get>
* <查找的get方法>
* @param id 实体的id
* @return 查询出来的实体
* @see com.itv.launcher.util.IBaseDao#get(java.io.Serializable)
*/
@Override
public T get(ID id) {
T load = (T) this.getSession().get(getEntityClass(), id);
return load;
}
/**
* <contains>
* @param t 实体
* @return 是否包含
* @see com.itv.launcher.util.IBaseDao#contains(java.lang.Object)
*/
@Override
public boolean contains(T t) {
return this.getSession().contains(t);
}
/**
* <delete>
* <删除表中的t数据>
* @param t 实体
* @see com.itv.launcher.util.IBaseDao#delete(java.lang.Object)
*/
@Override
public void delete(T t) {
this.getSession().delete(t);
}
/**
* <根据ID删除数据>
* @param Id 实体id
* @return 是否删除成功
* @see com.itv.launcher.util.IBaseDao#deleteById(java.io.Serializable)
*/
@Override
public boolean deleteById(ID Id) {
T t = get(Id);
if(t == null){
return false;
}
delete(t);
return true;
}
/**
* <删除所有>
* @param entities 实体的Collection集合
* @see com.itv.launcher.util.IBaseDao#deleteAll(java.util.Collection)
*/
@Override
public void deleteAll(Collection<T> entities) {
for(Object entity : entities) {
this.getSession().delete(entity);
}
}
/**
* <执行Hql语句>
* @param hqlString hql
* @param values 不定参数数组
* @see com.itv.launcher.util.IBaseDao#queryHql(java.lang.String, java.lang.Object[])
*/
@Override
public void queryHql(String hqlString, Object... values) {
Query query = this.getSession().createQuery(hqlString);
if (values != null)
{
for (int i = 0; i < values.length; i++)
{
query.setParameter(i, values[i]);
}
}
query.executeUpdate();
}
/**
* <执行Sql语句>
* @param sqlString sql
* @param values 不定参数数组
* @see com.itv.launcher.util.IBaseDao#querySql(java.lang.String, java.lang.Object[])
*/
@Override
public void querySql(String sqlString, Object... values) {
Query query = this.getSession().createSQLQuery(sqlString);
if (values != null)
{
for (int i = 0; i < values.length; i++)
{
query.setParameter(i, values[i]);
}
}
query.executeUpdate();
}
/**
* <根据HQL语句查找唯一实体>
* @param hqlString HQL语句
* @param values 不定参数的Object数组
* @return 查询实体
* @see com.itv.launcher.util.IBaseDao#getByHQL(java.lang.String, java.lang.Object[])
*/
@Override
public T getByHQL(String hqlString, Object... values) {
Query query = this.getSession().createQuery(hqlString);
if (values != null)
{
for (int i = 0; i < values.length; i++)
{
query.setParameter(i, values[i]);
}
}
return (T) query.uniqueResult();
}
/**
* <根据SQL语句查找唯一实体>
* @param sqlString SQL语句
* @param values 不定参数的Object数组
* @return 查询实体
* @see com.itv.launcher.util.IBaseDao#getBySQL(java.lang.String, java.lang.Object[])
*/
@Override
public T getBySQL(String sqlString, Object... values) {
Query query = this.getSession().createSQLQuery(sqlString);
if (values != null)
{
for (int i = 0; i < values.length; i++)
{
query.setParameter(i, values[i]);
}
}
return (T) query.uniqueResult();
}
/**
* <根据HQL语句,得到对应的list>
* @param hqlString HQL语句
* @param values 不定参数的Object数组
* @return 查询多个实体的List集合
* @see com.itv.launcher.util.IBaseDao#getListByHQL(java.lang.String, java.lang.Object[])
*/
@Override
public List<T> getListByHQL(String hqlString, Object... values) {
Query query = this.getSession().createQuery(hqlString);
if (values != null)
{
for (int i = 0; i < values.length; i++)
{
query.setParameter(i, values[i]);
}
}
return query.list();
}
/**
* <根据SQL语句,得到对应的list>
* @param sqlString HQL语句
* @param values 不定参数的Object数组
* @return 查询多个实体的List集合
* @see com.itv.launcher.util.IBaseDao#getListBySQL(java.lang.String, java.lang.Object[])
*/
@Override
public List<T> getListBySQL(String sqlString, Object... values ) {
Query query = this.getSession().createSQLQuery(sqlString);
if (values != null)
{
for (int i = 0; i < values.length; i++)
{
query.setParameter(i, values[i]);
}
}
return query.list();
}
/**
* 由sql语句得到List
* @param sql
* @param map
* @param values
* @return List
* @see com.itv.launcher.util.IBaseDao#findListBySql(java.lang.String, com.itv.launcher.util.RowMapper, java.lang.Object[])
*/
@Override
public List findListBySql(final String sql, final RowMapper map, final Object... values) {
final List list = new ArrayList();
// 执行JDBC的数据批量保存
Work jdbcWork = new Work()
{
public void execute(Connection connection)
throws SQLException
{
PreparedStatement ps = null;
ResultSet rs = null;
try
{
ps = connection.prepareStatement(sql);
for (int i = 0; i < values.length; i++)
{
setParameter(ps, i, values[i]);
}
rs = ps.executeQuery();
int index = 0;
while (rs.next())
{
Object obj = map.mapRow(rs, index++);
list.add(obj);
}
}
finally
{
if (rs != null)
{
rs.close();
}
if (ps != null)
{
ps.close();
}
}
}
};
this.getSession().doWork(jdbcWork);
return list;
}
/**
* <refresh>
* @param t 实体
* @see com.itv.launcher.util.IBaseDao#refresh(java.lang.Object)
*/
@Override
public void refresh(T t) {
this.getSession().refresh(t);
}
/**
* <update>
* @param t 实体
* @see com.itv.launcher.util.IBaseDao#update(java.lang.Object)
*/
@Override
public void update(T t) {
this.getSession().update(t);
}
/**
* <根据HQL得到记录数>
* @param hql HQL语句
* @param values 不定参数的Object数组
* @return 记录总数
* @see com.itv.launcher.util.IBaseDao#countByHql(java.lang.String, java.lang.Object[])
*/
@Override
public Long countByHql(String hql, Object... values) {
Query query = this.getSession().createQuery(hql);
if(values != null){
for(int i = 0; i < values.length; i++) {
query.setParameter(i, values[i]);
}
}
return (Long) query.uniqueResult();
}
/**
* @return the sessionFactory
*/
public SessionFactory getSessionFactory() {
return sessionFactory;
}
/**
* @param sessionFactory the sessionFactory to set
*/
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
/**
*
* @return session
*/
public Session getSession() {
//需要开启事物,才能得到CurrentSession
return sessionFactory.getCurrentSession();
}
/**
*
* 设置每行批处理参数
*
* @param ps
* @param pos ?占位符索引,从0开始
* @param data
* @throws SQLException
* @see [类、类#方法、类#成员]
*/
private void setParameter(PreparedStatement ps, int pos, Object data)
throws SQLException
{
if (data == null)
{
ps.setNull(pos + 1, Types.VARCHAR);
return;
}
Class dataCls = data.getClass();
if (String.class.equals(dataCls))
{
ps.setString(pos + 1, (String)data);
}
else if (boolean.class.equals(dataCls))
{
ps.setBoolean(pos + 1, ((Boolean)data));
}
else if (int.class.equals(dataCls))
{
ps.setInt(pos + 1, (Integer)data);
}
else if (double.class.equals(dataCls))
{
ps.setDouble(pos + 1, (Double)data);
}
else if (Date.class.equals(dataCls))
{
Date val = (Date)data;
ps.setTimestamp(pos + 1, new Timestamp(val.getTime()));
}
else if (BigDecimal.class.equals(dataCls))
{
ps.setBigDecimal(pos + 1, (BigDecimal)data);
}
else
{
// 未知类型
ps.setObject(pos + 1, data);
}
}
}
UserLoginDaoImpl类
package com.yzkj.login.dao.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;
import com.yzkj.login.dao.BaseDao;
import com.yzkj.login.dao.UserLoginDao;
import com.yzkj.login.entity.User_Login;
@SuppressWarnings("rawtypes")
@Repository
@Transactional
public class UserLoginDaoImpl implements UserLoginDao{
@Autowired
private BaseDao baseDao;
@Override
public User_Login getLogin(User_Login user) {
String hql="from User_Login where u_name=? and u_pwd=?";
return (User_Login) baseDao.getByHQL(hql, user.getU_name(),user.getU_pwd());
}
}
前端发送请求jq代码
<script type="text/javascript">
function doLogin(){
$.post("user/login?u_name="+$("#u_name").val()+"&u_pwd=" + $("#u_pwd").val(),function(data){
if(data){
window.location.href = "page/admin.jsp";
}else{
alert("用户名或密码错误!!!");
}
},'json');
}
</script>
接下来使用Tomcat运行,,测试成功,说明ssh三大框架整合就完成了
这个适合新手使用,欢迎大神们多多指教,谢谢
项目源代码百度网盘下载地址:http://pan.baidu.com/s/1i5EGxUl