Struts2.3.16+Spring3.2.8+Hibernate4.2.10全注解配置

来源：互联网发布：lol全网络大区编辑：程序博客网时间：2024/05/21 19:50

1 数据库配置

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8

jdbc.username=root

jdbc.password=mysql

2 log4j.xml

log4j.rootLogger=debug, stdout

log4j.logger.java.sql.Connection=info, stdout

log4j.logger.java.sql.Statement=debug, stdout

log4j.logger.java.sql.PreparedStatement=debug, stdout

log4j.logger.org.hibernate=error

log4j.logger.org.hibernate.SQL=debug

log4j.logger.org.hibernate.tool.hbm2ddl=debug

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%p %d{yyyy-MM-dd HH:mm:ss} %c:%L - %m%n

log4j.category.org.springframework = ON

3 pom.xml

<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/xsd/maven-4.0.0.xsd">

<version> 0.0.1-SNAPSHOT</version >

<checkstyle.config.location> config/maven_checks.xml</checkstyle.config.location >

<spring.version> 3.2.8.RELEASE</spring.version >

<struts2.version> 2.3.16.1</struts2.version >

<hibernate.version> 4.2.10.Final</hibernate.version >

<mybatis.version> 3.2.6</mybatis.version >

<mysql.version> 5.1.29</mysql.version >

<servlet-api.version> 2.5</servlet-api.version >

<jsp-api.version> 2.2</jsp-api.version >

<jstl.version> 1.2</jstl.version >

<fastjson.version> 1.1.39</fastjson.version >

<commons-dbcp2.version> 2.0</commons-dbcp2.version >

<commons-pool2.version> 2.2</commons-pool2.version >

<commons-logging.version> 1.1.3</commons-logging.version >

<commons-io.version> 1.3.2</commons-io.version >

<commons-lang3.version> 3.3.1</commons-lang3.version >

<commons-fileupload.version> 1.2.1</commons-fileupload.version >

<log4j.version> 1.2.17</log4j.version >

<slf4j.version> 1.7.6</slf4j.version >

<dom4j.version> 1.6.1</dom4j.version >

<jfreechart.version> 1.0.17</jfreechart.version >

<shiro.version> 1.2.3</shiro.version >

<aspectjweaver.version> 1.7.4</aspectjweaver.version >

<bonecp.version> 0.8.0.RELEASE</bonecp.version >

<druid.version> 1.0.6</druid.version >

<c3p0.version> 0.9.2.1</c3p0.version >

<testng.version> 6.8.8</testng.version >

<junit.version> 4.11</junit.version >

<freemarker.version> 2.3.20</freemarker.version >

<velocity.version> 1.7</velocity.version >

<tapestry.version> 5.3.7</tapestry.version >

<asm.version> 4.2</asm.version >

<cglib.version> 3.1</cglib.version >

<project.build.sourceEncoding> UTF-8</project.build.sourceEncoding >

<jdk.version> 1.6</jdk.version >

</properties>

<url> http://maven.apache.org</url >

<groupId> org.apache.struts</groupId >

<artifactId> struts2-core</artifactId >

<version> ${struts2.version}</version >

</dependency>

<groupId> org.apache.struts</groupId >

<artifactId> struts2-spring-plugin </artifactId>

<version> ${struts2.version}</version >

</dependency>

<groupId> org.apache.struts</groupId >

<artifactId> struts2-json- plugin</ artifactId>

<version> ${struts2.version}</version >

</dependency>

<groupId> org.apache.struts</groupId >

<artifactId> struts2-dwr- plugin</ artifactId>

<version> ${struts2.version}</version >

</dependency>

<groupId> org.apache.struts</groupId >

<artifactId> struts2-rest-plugin </artifactId>

<version> ${struts2.version}</version >

</dependency>

<groupId> org.apache.struts</groupId >

<artifactId> struts2-javatemplates -plugin</artifactId >

<version> ${struts2.version}</version >

</dependency>

<groupId> org.apache.struts</groupId >

<artifactId> struts2-jfreechart -plugin</artifactId >

<version> ${struts2.version}</version >

</dependency>

<groupId> org.apache.struts</groupId >

<artifactId> struts2-convention-plugin </artifactId>

<version> ${struts2.version}</version >

</dependency>

<groupId> org.hibernate</groupId >

<artifactId> hibernate-core </artifactId>

<version> ${hibernate.version}</version >

<groupId> javassist</groupId >

<artifactId> javassist</artifactId >

</exclusion>

</exclusions>

</dependency>

<groupId> org.mybatis</groupId >

<artifactId> mybatis</artifactId >

<version> ${mybatis.version}</version >

</dependency>

<groupId> mysql</groupId >

<artifactId> mysql-connector-java </artifactId>

<version> ${mysql.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-core</artifactId >

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-beans</artifactId >

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-context</artifactId >

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-jdbc </artifactId>

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-web</artifactId >

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-webmvc </artifactId>

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-aop </artifactId>

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-tx </artifactId>

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-orm </artifactId>

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-context-support</artifactId >

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework</groupId >

<artifactId> spring-jms </artifactId>

<version> ${spring.version}</version >

</dependency>

<groupId> org.springframework.security</groupId >

<artifactId> spring-security-core</artifactId >

<version> 3.2.4.RELEASE</version >

</dependency>

<groupId> commons-logging</groupId >

<artifactId> commons-logging</artifactId >

<version> ${commons-logging.version}</version >

</dependency>

<version> ${log4j.version}</version >

</dependency>

<version> ${slf4j.version}</version >

</dependency>

<version> ${slf4j.version}</version >

</dependency>

<!-- 依赖的WEB类库 TOMCAT环境注释

<groupId>javax.servlet</groupId>

<artifactId>javax.servlet- api</artifactId>

</dependency>

<groupId>javax.servlet</groupId>

<artifactId> servlet-api </artifactId>

<version>${ servlet-api.version}</version>

</dependency>-->

<groupId> org.springframework</groupId >

<artifactId> spring-test</artifactId >

<version> ${spring.version}</version >

</dependency>

<groupId> junit</groupId >

<artifactId> junit</artifactId >

<version> ${junit.version}</version >

</dependency>

<groupId> org.testng</groupId >

<artifactId> testng</artifactId >

<version> ${testng.version}</version >

</dependency>

<groupId> com.alibaba</groupId >

<artifactId> druid</artifactId >

<version> ${druid.version}</version >

</dependency>

<groupId> com.jolbox</groupId >

<artifactId> bonecp-spring </artifactId>

<version> ${bonecp.version}</version >

</dependency>

<groupId> com.jolbox</groupId >

<artifactId> bonecp</artifactId >

<version> ${bonecp.version}</version >

</dependency>

<groupId> com.mchange</groupId >

<version> ${c3p0.version}</version >

</dependency>

<groupId> org.apache.shiro</groupId >

<artifactId> shiro-core </artifactId>

<version> ${shiro.version}</version >

</dependency>

<groupId> org.apache.shiro</groupId >

<artifactId> shiro-web </artifactId>

<version> ${shiro.version}</version >

</dependency>

<groupId> org.apache.shiro</groupId >

<artifactId> shiro-spring </artifactId>

<version> ${shiro.version}</version >

</dependency>

<groupId> org.apache.shiro</groupId >

<artifactId> shiro-ehcache</artifactId>

<version> ${shiro.version}</version >

</dependency>

<groupId> org.apache.shiro</groupId >

<artifactId> shiro-aspectj</artifactId>

<version> ${shiro.version}</version >

</dependency>

<groupId> org.apache.shiro</groupId >

<artifactId> shiro-quartz </artifactId>

<version> ${shiro.version}</version >

</dependency>

<groupId> org.freemarker</groupId >

<artifactId> freemarker</artifactId >

<version> ${freemarker.version}</version >

</dependency>

<groupId> org.apache.velocity</groupId >

<artifactId> velocity</artifactId >

<version> ${velocity.version}</version >

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-dbcp2</artifactId >

<version> ${commons-dbcp2.version}</version >

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-pool2</artifactId >

<version> ${commons-pool2.version}</version >

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-io </artifactId>

<version> ${commons-io.version}</version >

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-lang3</artifactId >

<version> ${commons-lang3.version}</version >

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-proxy </artifactId>

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-jexl </artifactId>

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-exec </artifactId>

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-compress</artifactId >

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-daemon</artifactId >

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-math</artifactId >

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-collections4</artifactId >

</dependency>

<groupId> org.kuali.commons</groupId >

<artifactId> commons-beanutils </artifactId>

<version> 1.8.3-kuali-4 </version>

</dependency>

<groupId> commons-dbutils </groupId>

<artifactId> commons-dbutils </artifactId>

</dependency>

<groupId> net.sf.ehcache</groupId >

<artifactId> ehcache</artifactId >

</dependency>

<groupId> com.googlecode.xmemcached</groupId >

<artifactId> xmemcached</artifactId >

</dependency>

<groupId> opensymphony</groupId >

<artifactId> oscache</artifactId >

</dependency>

<groupId> cglib</groupId >

<artifactId> cglib-nodep</artifactId>

<version> ${cglib.version}</version >

</dependency>

<groupId> cglib</groupId >

<artifactId> cglib</artifactId >

<version> ${cglib.version}</version >

</dependency>

<version> ${asm.version}</version >

</dependency>

<artifactId> asm-commons </artifactId>

<version> ${asm.version}</version >

</dependency>

<version> ${asm.version}</version >

</dependency>

<version> ${asm.version}</version >

</dependency>

<artifactId> asm-analysis </artifactId>

<version> ${asm.version}</version >

</dependency>

<version> ${asm.version}</version >

</dependency>

<artifactId> asm-debug-all </artifactId>

<version> ${asm.version}</version >

</dependency>

<groupId> com.alibaba</groupId >

<artifactId> fastjson</artifactId >

<version> ${fastjson.version}</version >

</dependency>

<groupId> org.aspectj</groupId >

<artifactId> aspectjweaver</artifactId >

<version> ${aspectjweaver.version}</version >

</dependency>

<version> ${dom4j.version}</version >

</dependency>

<groupId> com.belerweb</groupId >

<artifactId> pinyin4j</artifactId >

</dependency>

<groupId> com.darwinsys</groupId >

<artifactId> hirondelle-date4j </artifactId>

</dependency>

<groupId> net.sourceforge.htmlunit</groupId >

<artifactId> htmlunit</artifactId >

</dependency>

<groupId> net.sourceforge.jwebunit</groupId >

<artifactId> jwebunit-htmlunit-plugin</artifactId >

</dependency>

<groupId> net.sourceforge.javacsv</groupId >

<artifactId> javacsv</artifactId >

</dependency>

<groupId> org.jsoup</groupId >

<artifactId> jsoup</artifactId >

</dependency>

<groupId> org.apache.commons</groupId >

<artifactId> commons-email</artifactId >

</dependency>

<groupId> commons-beanutils </groupId>

<artifactId> commons-beanutils </artifactId>

</dependency>

<groupId> commons-collections</groupId >

<artifactId> commons-collections</artifactId >

</dependency>

<groupId> commons-configuration</groupId >

<artifactId> commons-configuration</artifactId >

</dependency>

<groupId> commons-dbcp </groupId>

<artifactId> commons-dbcp </artifactId>

</dependency>

<groupId> commons-fileupload </groupId>

<artifactId> commons-fileupload</artifactId >

</dependency>

<groupId> org.apache.httpcomponents</groupId >

<artifactId> httpclient</artifactId >

</dependency>

<groupId> commons-validator</groupId >

<artifactId> commons-validator</artifactId >

</dependency>

</dependency>

<groupId> javax.activation</groupId >

<artifactId> activation</artifactId >

<scope> provided</scope >

</dependency>

<groupId> javax.xml</groupId >

<artifactId> jaxrpc-api</artifactId >

<scope> provided</scope >

</dependency>

<groupId> javax.mail</groupId >

<scope> provided</scope >

</dependency>

<groupId> javax.xml</groupId >

<artifactId> namespace</artifactId >

<scope> provided</scope >

</dependency>

<groupId> xerces</groupId >

<artifactId> xmlParserAPIs</artifactId >

<scope> provided</scope >

</dependency>

</dependency>

<groupId> org.apache.openejb</groupId >

<artifactId> javaee-api</artifactId >

<scope> provided</scope >

</dependency>

<groupId> javax.faces</groupId >

<scope> provided</scope >

</dependency>

<groupId> javax.servlet</groupId >

<scope> compile</scope >

</dependency>

<!--

<groupId>javax.servlet.jsp</groupId>

<scope>compile</scope>

</dependency>

-->

<groupId> javax.faces</groupId >

<scope> provided</scope >

</dependency>

</dependencies>

</project>

4 applicationContext.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:tx="http://www.springframework.org/schema/tx"

xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans.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

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context.xsd"

default-autowire="byName" >

<context:property-placeholder location="classpath*:conf/jdbc.properties" />

<context:component-scan base-package="com.lin.ssh.demo.dao" />

<context:component-scan base-package="com.lin.ssh.demo.service" />

<context:component-scan base-package="com.lin.ssh.demo.service.impl" />

<bean id= "dataSource" class="com.alibaba.druid.pool.DruidDataSource"

init-method="init" destroy-method= "close">

<property name="maxPoolPreparedStatementPerConnectionSize"

value="50" />

</bean>

<bean id= "sessionFactory"

class="org.springframework.orm.hibernate4.LocalSessionFactoryBean" >

<props>

<prop key="hibernate.dialect" >org.hibernate.dialect.MySQL5InnoDBDialect</prop >

<prop key="hibernate.current_session_context_class" >org.springframework.orm.hibernate4.SpringSessionContext

</prop>

<prop key="hibernate.hbm2ddl.auto" >update</ prop>

</props>

</property>

<list>

<value> com.lin.ssh.demo.model</value >

</list>

</property>

<!--

<value>classpath:sy/ hbm</value> </list> </property>

-->

</bean>

<bean id= "transactionManager"

class="org.springframework.orm.hibernate4.HibernateTransactionManager" >

</bean>

<tx:advice id= "txAdvice" transaction-manager ="transactionManager">

<tx:attributes>

<tx:method name="select*" read-only= "true" />

<tx:method name="get*" read-only= "true" />

<tx:method name="load*" read-only= "true" />

<tx:method name="find*" read-only= "true" />

<tx:method name="query*" read-only= "true" />

<tx:method name="read*" read-only= "true" />

<tx:method name="sync*" />

<tx:method name="*" propagation= "REQUIRED" rollback-for="Exception" />

</tx:attributes>

</tx:advice>

<aop:config proxy-target-class="true" >

<aop:pointcut expression="this(com.lin.ssh.demo.service.IBaseService)"

id= "transactionPointcut" />

<aop:advisor advice-ref="txAdvice" pointcut-ref="transactionPointcut" />

</aop:config>

</beans>

5 Struts2配置

<?xml version="1.0" encoding= "UTF-8" ?>

<!DOCTYPE struts PUBLIC

"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"

"http://struts.apache.org/dtds/struts-2.3.dtd" >

<!--

指定spring框架的装配模式，装配方式有: name, type, auto, and constructor (name

是默认装配模式)

-->

<global-results>

<result name="success" >/pages/index.jsp</ result>

<result name="login" >/index.jsp</ result>

<result name="error" >/error.jsp</ result>

</global-results>

</package>

</struts>

6 web.xml

<?xml version="1.0" encoding= "UTF-8"?>

<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee

http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" >

<context-param>

<param-name>log4jConfigLocation</param-name>

<param-value>classpath:conf/log4j.properties</param-value>

</context-param>

<context-param>

<param-name>contextConfigLocation</param-name >

<param-value>classpath:conf/applictionContext.xml</param-value>

</context-param>

<listener-class> org.springframework.web.util.Log4jConfigListener</listener-class >

</listener>

<listener-class> org.springframework.web.context.ContextLoaderListener </listener-class>

</listener>

<listener-class> org.springframework.web.context.request.RequestContextListener </listener-class>

</listener>

<listener-class> org.springframework.web.util.IntrospectorCleanupListener </listener-class>

</listener>

<filter-name> encodingFilter</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>

</filter>

<filter-mapping>

<filter-name>encodingFilter</filter-name>

<url-pattern>/*</url-pattern>

</filter-mapping>

<filter-name>struts2</filter-name >

<filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter </filter-class>

</filter>

<filter-mapping>

<filter-name>struts2</filter-name >

<url-pattern> /*</ url-pattern>

</filter-mapping>

<welcome-file-list>

<welcome-file> login.html</welcome-file >

</welcome-file-list>

</web-app>

7 UserAction

package com.lin.ssh.demo.web.action;

import java.util.List;

import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.apache.struts2.convention.annotation.Result;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Component;

import com.lin.ssh.demo.model.UserBean;
import com.lin.ssh.demo.service.IUserService;
import com.opensymphony.xwork2.ActionSupport;

//@ParentPackage("demoPackage")
@Namespace("/demo")
@Component
@Scope("prototype")
@Action("userAction")
public class UserAction extends ActionSupport {

     private IUserService userService;
     private UserBean user;
     private List<UserBean> userList;

     /**
     * http://127.0.0.1:8080/ssh/demo/regUser!index.do
     * @return
     */
     @Action(value = "regUser", results = {
               @Result(name = "success", location = "/pages/login.jsp"),
               @Result(name = "input", location = "/pages/error.jsp") })
     public String index() {
          System.out.println("----reg page----");
          return SUCCESS;
     }

     @Action(value = "saveUser", results = {
               @Result(name = "list", location = "/pages/list.jsp"),
               @Result(name = "input", location = "/pages/error.jsp"),
               @Result(name = "success", location = "/pages/index.jsp")})
     public String save() {
          System.out.println("----save----");
          System.out.println("===="+user);
          try {
               userService.saveUser(user);
          } catch (Exception e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
          }
          return SUCCESS;
     }

     /**
     * http://127.0.0.1:8080/ssh/demo/userAction!list.do
     */
     public void list() {
          System.out.println("----list----");
          System.out.println(user);
          try {
               userList = userService.queryUserAll();
               System.out.println("userList ==" + userList.get(0).toString());
          } catch (Exception e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
          }
          // return SUCCESS;
     }

     public List<UserBean> getUserList() {
          return userList;
     }

     public void setUserList(List<UserBean> userList) {
          this.userList = userList;
     }

     public IUserService getUserService() {
          return userService;
     }

     @Autowired
     public void setUserService(IUserService userService) {
          this.userService = userService;
     }

     public UserBean getUser() {
          return user;
     }

     public void setUser(UserBean user) {
          this.user = user;
     }

}

8 UserDAO

package com.lin.ssh.demo.dao;

import java.util.List;

import com.lin.ssh.demo.model.UserBean;

public interface IUserDAO {
public void save(UserBean entity) throws Exception;

public List<UserBean> find(Class<UserBean> clazz) throws Exception;
}

package com.lin.ssh.demo.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.lin.ssh.demo.model.UserBean;

@Repository("userDao")
public class UserDAO extends DaoSupport implements IUserDAO {

     /**
     * 保存对象
     *
     * @param entity
     * @throws Exception
     */
     @Override
     public void save(UserBean entity) throws Exception {
          super.save(entity);

     }

     @Override
     public List<UserBean> find(Class clazz) throws Exception {
          return super.findAll(clazz);
     }
}

package com.lin.ssh.demo.dao;

import static org.hibernate.criterion.Restrictions.eq;

import java.util.List;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.springframework.beans.factory.annotation.Autowired;

/**

* @author linhz

public class DaoSupport {

private SessionFactory sessionFactory;

@Autowired

public void setSessionFactory(SessionFactory sessionFactory) {

this.sessionFactory = sessionFactory;

}

protected Session getSession() {

return sessionFactory.getCurrentSession();

}

protected void save(Object obj) {

getSession().save(obj);

}

protected <T> T get(Class<T> clazz, int id) {

return (T) getSession().get(clazz, id);

}

protected <T> List<T> findByProperty(Class<T> clazz, String property,

Object value) {

return getSession().createCriteria(clazz).add(eq(property, value))

.list();

}

protected <T> List<T> findAll(Class<T> clazz) {

return getSession().createCriteria(clazz).list();

}

protected void update(Object obj) {

getSession().update(obj);

}

protected void delete(Class clazz, int id) {

getSession().delete(get(clazz, id));

}

protected void delete(Object obj) {

getSession().delete(obj);

}

9 Model POJO

package com.lin.ssh.demo.model;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.Id;

import javax.persistence.Table;

import static javax.persistence.GenerationType.IDENTITY;

@Entity

@Table(name = "tb_demo", schema = "test")

public class UserBean implements java.io.Serializable {

@Id

@GeneratedValue(strategy = IDENTITY)

@Column(name = "id", unique = true, nullable = false)

private Long id;

@Column(name = "username", length = 32)

private String username;

@Column(name = "password", length = 16)

private String password;

public UserBean() {

}

public UserBean(String username, String password) {

this.username = username;

this.password = password;

}

public Long getId() {

return id ;

}

public void setId(Long id) {

this.id = id;

}

public String getUsername() {

return username ;

}

public void setUsername(String username) {

this.username = username;

}

public String getPassword() {

return password ;

}

public void setPassword(String password) {

this.password = password;

}

@Override

public String toString() {

return "User{" +

"id=" + id +

", username='" + username + '\'' +

", password='" + password + '\'' +

'}';

}

10 UserService

package com.lin.ssh.demo.service;

public interface IBaseService {

}

package com.lin.ssh.demo.service;

import java.util.List;

import com.lin.ssh.demo.model.UserBean;

public interface IUserService extends IBaseService {

public void saveUser(UserBean user) throws Exception;

public List<UserBean> queryUserAll() throws Exception;

}

package com.lin.ssh.demo.service.impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.lin.ssh.demo.dao.UserDAO;
import com.lin.ssh.demo.model.UserBean;
import com.lin.ssh.demo.service.IUserService;

@Service("userService")
public class UserServiceImpl implements IUserService {

     @Resource
     private UserDAO userDao;

     public void saveUser(UserBean user) throws Exception {
          userDao.save(user);
     }

     public List<UserBean> queryUserAll() throws Exception {
          return userDao.find(UserBean.class);
     }

}

11 测试页面 index.jsp

<%@ page contentType= "text/html;charset=UTF-8" language= "java"%>

String path = request.getContextPath();

String contextPath = request.getScheme() + "://"

+ request.getServerName() + ":" + request.getServerPort()

+ path + "/";

<html>

<head>

</head>

<body>

<form action=" <%=contextPath%> /demo/saveUser!save.action" method="get" >

<br>

用户名：

<br>

密码：

</form>

</body>

</html>

12 SQL语句脚本

use test ;
CREATE TABLE `tb_demo` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(32) DEFAULT NULL,
`password` varchar(16) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8

13 测试

webcontent部署为：ssh

访问地址：

http://127.0.0.1:8080/ssh/demo/regUser!index.do

数据正常插入

0 0