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

<!--

Licensed to the Apache Software Foundation (ASF) under one

or more contributor license agreements. See the NOTICE file

distributed with this work for additional information

regarding copyright ownership. The ASF licenses this file

to you under the Apache License, Version 2.0 (the

"License"); you may not use this file except in compliance

with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing,

software distributed under the License is distributed on an

"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY

KIND, either express or implied. See the License for the

specific language governing permissions and limitations

under the License.

-->

<ivy-module version="2.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:noNamespaceSchemaLocation="http://ant.apache.org/ivy/schemas/ivy.xsd">

<info

organisation="com.cdv"

module="Smmil"

status="integration">

</info>

<configurations>

<conf name="default" visibility="public" description="runtime dependencies and master artifact can be used with this conf" extends="runtime,master"/>

<conf name="master" visibility="public" description="contains only the artifact published by this module itself, with no transitive dependencies"/>

<conf name="compile" visibility="public" description="this is the default scope, used if none is specified. Compile dependencies are available in all classpaths."/>

<conf name="provided" visibility="public" description="this is much like compile, but indicates you expect the JDK or a container to provide it. It is only available on the compilation classpath, and is not transitive."/>

<conf name="runtime" visibility="public" description="this scope indicates that the dependency is not required for compilation, but is for execution. It is in the runtime and test classpaths, but not the compile classpath." extends="compile"/>

<conf name="test" visibility="private" description="this scope indicates that the dependency is not required for normal use of the application, and is only available for the test compilation and execution phases." extends="runtime"/>

<conf name="system" visibility="public" description="this scope is similar to provided except that you have to provide the JAR which contains it explicitly. The artifact is always available and is not looked up in a repository."/>

<conf name="sources" visibility="public" description="this configuration contains the source artifact of this module, if any."/>

<conf name="javadoc" visibility="public" description="this configuration contains the javadoc artifact of this module, if any."/>

<conf name="optional" visibility="public" description="contains all optional dependencies"/>

</configurations>

<dependencies>

<!-- Spring 相关内容 -->

<dependency org="org.springframework" name="spring-core" rev="3.2.5.RELEASE" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.springframework" name="spring-beans" rev="3.2.5.RELEASE" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.springframework" name="spring-web" rev="3.2.5.RELEASE" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.springframework" name="spring-context" rev="3.2.5.RELEASE" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.springframework" name="spring-aop" rev="3.2.5.RELEASE" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.springframework" name="spring-expression" rev="3.2.5.RELEASE" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.springframework" name="spring-tx" rev="3.2.5.RELEASE" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.springframework" name="spring-jms" rev="3.2.5.RELEASE" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.springframework" name="spring-jdbc" rev="3.2.5.RELEASE" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="aopalliance" name="aopalliance" rev="1.0" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="com.sun.xml.fastinfoset" name="FastInfoset" rev="1.2.12" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="cglib" name="cglib-nodep" rev="2.2.2" conf="compile->compile(*),master(*);runtime->runtime(*)" />

<dependency org="org.aspectj" name="aspectjrt" rev="1.6.11" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.aspectj" name="aspectjweaver" rev="1.6.11" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<!--添加日志包 -->

<dependency org="commons-logging" name="commons-logging" rev="1.2" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"></dependency> 

<!-- 数据库相关内容 -->

<dependency org="com.h2database" name="h2" rev="1.3.174" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="mysql" name="mysql-connector-java" rev="5.1.18" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="commons-dbcp" name="commons-dbcp" rev="1.4" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="commons-pool" name="commons-pool" rev="1.5.6" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.liquibase" name="liquibase-core" rev="2.0.4" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.mybatis" name="mybatis" rev="3.1.1" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

<dependency org="org.mybatis" name="mybatis-spring" rev="1.1.1" conf="compile->compile(*),master(*);runtime->runtime(*)" transitive="false"/>

</dependencies>

</ivy-module>

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

<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"

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

xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">

<include file="table.xml" relativeToChangelogFile="true" />

<include file="view.xml" relativeToChangelogFile="true" />

<include file="data.xml" relativeToChangelogFile="true" />

</databaseChangeLog>

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

<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"

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

xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">

<!-- OOOOOO注意: 本文件不要格式化OOOOOO -->

<changeSet author="lgp" id="20150710-test" context="production">

<createTable tableName="user_info">

<column name="userid" type="NVARCHAR(100)"><constraints nullable="false" primaryKey="true" primaryKeyName="PK_USER_INFO" /></column>

<column name="userhome" type="NVARCHAR(100)"></column>

<column name="useraddress" type="NVARCHAR(100)"><constraints nullable="false" /></column>

</createTable>

</changeSet>

</databaseChangeLog>

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

<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"

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

xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">

</databaseChangeLog>

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

<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"

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

xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">

<changeSet author="lgp" id="20150710-test-initdata">

<insert tableName="user_info">

<column name="userid" value="lisi" />

<column name="userhome" value="111111ls" />

<column name="useraddress" value="123456ls" />

</insert>

<insert tableName="user_info">

<column name="userid" value="zhaoliu" />

<column name="userhome" value="111111zl" />

<column name="useraddress" value="123456" />

</insert>

</changeSet>

</databaseChangeLog>

package com.lgp.test.pojo;

public class UserInfo {

private String userId;

private String userHome;

private String userAddress;

public String getUserId() {

return userId;

}

public void setUserId(String userId) {

this.userId = userId;

}

public String getUserHome() {

return userHome;

}

public void setUserHome(String userHome) {

this.userHome = userHome;

}

public String getUserAddress() {

return userAddress;

}

public void setUserAddress(String userAddress) {

this.userAddress = userAddress;

}

}

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

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<!--设置别名 -->

<typeAliases>

<typeAlias type="com.lgp.test.pojo.UserInfo" alias="UserInfo"/>

</typeAliases>

<mappers>

<mapper resource="com/lgp/test/dao/UserMapper.xml"/>

</mappers>

</configuration>

package com.lgp.test.dao;

import java.util.List;

import com.lgp.test.pojo.UserInfo;

public interface UserInfoDao {

public int insert(UserInfo user);

public int update(UserInfo user);

public int delete(String userId);

public List<UserInfo> selectAll();

public int countAll();

public UserInfo find(String userId);

}

（实现接口）com/lgp/test/dao/UserMapper.xml

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

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.lgp.test.dao.UserInfoDao">

<select id="countAll" resultType="int"> <!-- 查询表中记录总数 -->

select count(*) c from user_info

</select>

<select id="selectAll" resultType="UserInfo"> <!-- 查询表中的所有用户 -->

select * from user_info order by userid asc

</select>

<insert id="insert" parameterType="UserInfo"> <!-- 向数据库中插入用户 -->

insert into user_info(userid,userHome,useraddress) values(#{userId},#{userHome},#{userAddress})

</insert>

<update id="update" parameterType="UserInfo"> <!-- 更新库中的用户 -->

update user_info set userhome=#{userHome},useraddress=#{userAddress} where userid=#{userId}

</update>

<delete id="delete" parameterType="String"> <!-- 删除用户 -->

delete from user_info where userid=#{userId}

</delete>

<select id="find" parameterType="String" resultType="UserInfo"> <!-- 根据用户名查找用户 -->

select * from user_info where userid=#{userId}

</select>

</mapper>

<?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="test" version="3.0">

<context-param>

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

<param-value>classpath:beans.xml</param-value>

</context-param>

<listener>

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

</listener>

<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>

# Database connection

database.driver=com.mysql.jdbc.Driver

database.url=jdbc:mysql://127.0.0.1:3306/test

database.user=root

database.password=123456

# Database

#database.driver=org.h2.Driver

#database.url=jdbc:h2:${database.h2.basedir}\\test

#database.user=sa

#database.password=

<?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"

xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:util="http://www.springframework.org/schema/util"

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

http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd

http://cxf.apache.org/jaxws http://cxf.apache.org/schemas/jaxws.xsd"

xmlns:jaxws="http://cxf.apache.org/jaxws">

<!-- enable transaction demarcation with annotations -->

<tx:annotation-driven />

<!-- enable autowire -->

<context:annotation-config />

<bean

class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

<property name="locations">

<list>

<value>classpath:dbconfig.properties</value>

</list>

</property>

</bean>

<!-- 数据库、数据源等相关配置-->

<bean id="ds" class="org.apache.commons.dbcp.BasicDataSource"

destroy-method="close">

<property name="driverClassName" value="${database.driver}" />

<property name="url" value="${database.url}" />

<property name="username" value="${database.user}" />

<property name="password" value="${database.password}" />

</bean>

<!-- 指明mybatis工厂类的配置 -->

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="dataSource" ref="ds" />

<property name="configLocation" value="classpath:com/lgp/test/mapper/mybatis-config.xml" />

</bean>

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

<property name="basePackage" value="com.lgp.test.dao" />

</bean>

<!-- 数据库事务管理-->

<bean id="transactionManager"

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

<property name="dataSource" ref="ds" />

</bean> 

<!-- 初始化数据库 -->

<bean id="liquibase" class="liquibase.integration.spring.SpringLiquibase">

<property name="dataSource" ref="ds" />

<property name="changeLog" value="classpath:com/lgp/test/db_changelog/master.xml" />

<property name="contexts" value="production" />

</bean> 

</beans>

package com.lgp.test.controller;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.lgp.test.dao.UserInfoDao;

import com.lgp.test.pojo.UserInfo;

@WebServlet("/testUser")

public class UserInfoServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

static ApplicationContext ctx=null;

public UserInfoServlet() {

super();

ctx=new ClassPathXmlApplicationContext("beans.xml");

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

String action = request.getParameter("action");

UserInfoDao userInfoDao = (UserInfoDao)ctx.getBean("userInfoDao");

if ("find".equals(action)) {

System.out.println("信息记录数："+userInfoDao.countAll());

UserInfo user = userInfoDao.find(request.getParameter("userId"));

System.out.println("用户信息："+user.getUserId()+"=="+user.getUserHome()+"=="+user.getUserAddress());

}

if ("insert".equals(action)) {

System.out.println("信息记录数："+userInfoDao.countAll());

UserInfo user = new UserInfo();

user.setUserId(request.getParameter("userId"));

user.setUserHome(request.getParameter("userHome"));

user.setUserAddress(request.getParameter("userAddress"));

userInfoDao.insert(user);

System.out.println("添加一条数据成功==信息记录数："+userInfoDao.countAll());

System.out.println("修改后用户信息："+user.getUserId()+"=="+user.getUserHome()+"=="+user.getUserAddress());

}

if ("update".equals(action)) {

System.out.println("信息记录数："+userInfoDao.countAll());

UserInfo user = new UserInfo();

user.setUserId(request.getParameter("userId"));

user.setUserHome(request.getParameter("userHome"));

user.setUserAddress(request.getParameter("userAddress"));

userInfoDao.update(user);

System.out.println("修改一条数据成功==信息记录数："+userInfoDao.countAll()+"====");

}

if ("delete".equals(action)) {

System.out.println("信息记录数："+userInfoDao.countAll());

userInfoDao.delete(request.getParameter("userId"));

System.out.println("删除一条数据成功==信息记录数："+userInfoDao.countAll()+"====");

}

}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

doGet(request, response);

}

}

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Insert title here</title>

</head>

<body>

<a href="find.jsp">find</a>

<br/>

<a href="save.jsp">insert</a>

<br/>

<a href="delete.jsp">delete</a>

<br/>

<a href="update.jsp">update</a>

</body>

</html>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Insert title here</title>

</head>

<body>

<form action="testUser">

<input type="hidden" name="action" value="find">

<input type="text" name="userId">

<input type="submit">

</form>

</body>

</html>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Insert title here</title>

</head>

<body>

<form action="testUser">

<input type="hidden" name="action" value="insert">

<input type="text" name="userId">

<input type="text" name="userHome">

<input type="text" name="userAddress">

<input type="submit">

</form>

</body>

</html>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Insert title here</title>

</head>

<body>

<form action="testUser">

<input type="hidden" name="action" value="update">

<input type="text" name="userId">

<input type="text" name="userHome">

<input type="text" name="userAddress">

<input type="submit">

</form>

</body>

</html>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Insert title here</title>

</head>

<body>

<form action="testUser">

<input type="hidden" name="action" value="delete">

<input type="text" name="userId">

<input type="submit">

</form>

</body>

</html>