annotation – 朱宏亮

java, jsp, MyBatis, MySql, Spring, SpringMVC, Tomcat 12月 28,2016

Spring4.0.2整合MyBatis.2.0,web网站,tomcat8【附全部代码下载】

下载地址：https://git.oschina.net/zhuhongliang/Spring_MyBatis_J2EE_Study
我的环境windows7，tomcat8，jre7
先看下文档目录和数据库：

我就吧配置文件贴这，其他文件直接下载，都有
SpringController.java：

package com.zhl.controller;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.zhl.model.Favorite;
import com.zhl.service.FavoriteService;

@Controller
public class SpringController {
	
	@Autowired
	FavoriteService favorite;
	
	@RequestMapping("/")
	public String hitu(Model model) 	{

	    List a= favorite.findAll(); 

	    model.addAttribute("list",a);
	    
	    return "a";
	}
	@RequestMapping("/index")
	public void  index(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException	{
	    response.setHeader("content-type", "text/html;charset=UTF-8");
	    response.setCharacterEncoding("UTF-8");
	
	    response.getWriter().println("<h1>打南边来了个喇嘛，手里提拉着五斤鳎犸。<br>"
	    		+ "打北边来了个哑巴，腰里别着个喇叭。<br>"
	    		+ "南边提拉着鳎犸的喇嘛要拿鳎犸换北边别喇叭哑巴的喇叭。<br>"
	    		+ "哑巴不愿意拿喇叭换喇嘛的鳎犸，喇嘛非要换别喇叭哑巴的喇叭。<br>"
	    		+ "喇嘛抡起鳎犸抽了别喇叭哑巴一鳎犸，哑巴摘下喇叭打了提拉着鳎犸的喇嘛一喇叭。<br>"
	    		+ "也不知是提拉着鳎犸的喇嘛抽了别喇叭哑巴一鳎犸，<br>"
	    		+ "还是别喇叭哑巴打了提拉着鳎犸的喇嘛一喇叭。<br>"
	    		+ "喇嘛炖鳎犸，哑巴嘀嘀哒哒吹喇叭</h1>");
	}	
}

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:p="http://www.springframework.org/schema/p" 
	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-4.0.xsd
		http://www.springframework.org/schema/context
		http://www.springframework.org/schema/context/spring-context-4.0.xsd
		http://www.springframework.org/schema/tx
		http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
		

	<!-- 配置数据源-->  
    <bean id="jdbcDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
	    <property name="driverClassName">  
	        <value>org.gjt.mm.mysql.Driver</value>  
	    </property>  
	    <property name="url">  
	        <value>jdbc:mysql://localhost:3306/hitu_crm?useUnicode=true&characterEncoding=UTF-8</value>  
	    </property>  
	    <property name="username">  
	        <value>root</value>  
	    </property>  
	    <property name="password">  
	        <value>root</value>  
	    </property>  
	</bean>  
	<bean id="springApplicationContext" class="com.zhl.util.SpringApplicationContext"/>

	<context:component-scan base-package="com.zhl.controller" /> 
	<context:component-scan base-package="com.zhl.service" /> 
	
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.zhl.mapper"></property>
		<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
	</bean>
	
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
	    <property name="dataSource" ref="jdbcDataSource" />  
	    <property name="configLocation" value="classpath:mybatis-config.xml"></property>  
	</bean>  
	


</beans>

mybatis-config.xml:

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

    
</configuration>

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_2_5.xsd" id="WebApp_ID" version="2.5">
	<display-name>一个简单的springMVC实例</display-name>
	<welcome-file-list>
		<welcome-file>index.html</welcome-file>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
	
	
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:ApplicationContext.xml</param-value>
	</context-param>
	
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	
	<servlet>
		<servlet-name>SpringMVC</servlet-name>
		<servlet-class>
			org.springframework.web.servlet.DispatcherServlet
		</servlet-class>
		<load-on-startup>1</load-on-startup>
	</servlet>	
	<servlet-mapping>
		<servlet-name>SpringMVC</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>
 
</web-app>

Spring-servlet.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:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context"
    xmlns:task="http://www.springframework.org/schema/task"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans-4.0.xsd  
                         http://www.springframework.org/schema/context
                        http://www.springframework.org/schema/context/spring-context-4.0.xsd   
                          http://www.springframework.org/schema/mvc
                          http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
                         http://www.springframework.org/schema/task 
                        http://www.springframework.org/schema/task/spring-task-4.0.xsd">
    
    
	
	<context:component-scan base-package="com.zhl.controller" />
	
	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
	   <property name="prefix" value="/WEB-INF/jsp/" />
	   <property name="suffix" value=".jsp" />
	</bean>


</beans>

我在本地访问：http://localhost:8081/Spring_MyBatis_web_Study/

我在本地访问：http://localhost:8081/Spring_MyBatis_web_Study/index

这个代码有点多：其他文件直接下载了看吧。

我的环境windows7，tomcat8，jre7

下载地址：https://git.oschina.net/zhuhongliang/Spring_MyBatis_J2EE_Study

作者朱宏亮

java, MyBatis, MySql, Spring 12月 28,2016

Spring4.0.2整合Mybatis3.2.0_J2SE【附源码下载】

源码下载：https://git.oschina.net/zhuhongliang/Spring4.0.2_Mybatis3.2.0_J2SE_Study

文档目录结构：（不算log4j的话一共就6个文件）

数据库：

下面看代码：

app.java：

package com.zhl.main;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.stereotype.Service;

import com.zhl.service.FavoriteService;
@Service
public class app {
	
	@Autowired
	FavoriteService favorite;
	
	public void setFavorite(FavoriteService favorite){
		this.favorite = favorite;
 	}
	
	public static void main(String[] args){
		long aa=System.currentTimeMillis();
		@SuppressWarnings("resource")
		//加载配置文件耗时将近一秒，如果ApplicationContext.xml的9、11、13行最后的spring版本写错了会导致这里加载慢3-30倍
		ApplicationContext context2 = new ClassPathXmlApplicationContext("ApplicationContext.xml"); 
		long bb=System.currentTimeMillis();
		
		//方法1：明显慢一点，差不多0.06秒
		app qqq = (app) context2.getBean("app");
		qqq.favorite.findAll();
		
		long cc=System.currentTimeMillis();
		
		//方法2：明显快一些，差不多0.01秒，相差大概6-7倍的速度
		FavoriteService a = (FavoriteService) context2.getBean("favoriteService");
		a.findAll();
		long dd=System.currentTimeMillis();
		
		System.out.println("运行时间："+(bb-aa)/1000f+"\t"+(cc-bb)/1000f+"\t"+(dd-cc)/1000f);
	}
}

FavoriteMapper.java:

package com.zhl.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.zhl.model.Favorite;

public interface FavoriteMapper {
	
	@Insert("insert into `favorite` (station, station_code) values (#{station}, #{station_code})")
	int insert(Favorite favorite);

	@Select("select * from `favorite`")
	List findAll();
	
	@Select("select * from `favorite` where id = #{id}")
	Favorite findOne( String id);
	
	@Update("Update `favorite` set station = #{station}, station_code = #{station_code} where id = #{id}")
	int update(Favorite favorite);
	
	@Delete("delete from `favorite` where id = #{id}")
	int delete(String id);
	
}

Favorite.java:

package com.zhl.model;

public class Favorite {

	public Favorite(){
		super();
	}
	private String id;
	private String station;		//火车车次
	private String station_code;		//火车长码
	
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getStation() {
		return station;
	}
	public void setStation(String station) {
		this.station = station;
	}
	public String getStation_code() {
		return station_code;
	}
	public void setStation_code(String station_code) {
		this.station_code = station_code;
	}
}

FavoriteService.java:

package com.zhl.service;

import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.zhl.mapper.FavoriteMapper;
import com.zhl.model.Favorite;

@Service
public class FavoriteService {
	
	@Autowired
	private FavoriteMapper favoriteMapper;

	public  void setFavoriteMapper(FavoriteMapper favoriteMapper) {
		this.favoriteMapper = favoriteMapper;
	}
	 
	public  void findAll(){

		List allUsers = favoriteMapper.findAll();
	
		for(int i = 0; i < allUsers.size(); i++){
			System.out.println(allUsers.get(i).getId()+"\t"+allUsers.get(i).getStation()+"\t"+allUsers.get(i).getStation_code());
		}

	}
}

ApplicationContext.xml:(第9行、11行、13行，这三行后面对应spring的数字不要写错了，我开始写成了4.2结果导致app.java加载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: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-4.0.xsd
		http://www.springframework.org/schema/context
		http://www.springframework.org/schema/context/spring-context-4.0.xsd
		http://www.springframework.org/schema/tx
		http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
		

    <bean id="jdbcDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
	    <property name="driverClassName">  
	        <value>org.gjt.mm.mysql.Driver</value>  
	    </property>  
	    <property name="url">  
	        <value>jdbc:mysql://localhost:3306/hitu_crm?useUnicode=true&characterEncoding=UTF-8</value>  
	    </property>  
	    <property name="username">  
	        <value>root</value>  
	    </property>  
	    <property name="password">  
	        <value>root</value>  
	    </property>  
	</bean>  
	
	<!-- 下面是自动扫描 -->
    <context:component-scan base-package="com.zhl.service"/>  
    <context:component-scan base-package="com.zhl.main"/>   
    
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.zhl.mapper"></property>
		<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
	</bean>
	
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
	    <property name="dataSource" ref="jdbcDataSource" />  
	    <property name="configLocation" value="classpath:mybatis.xml"></property>  
	</bean>  

</beans>

log4j的配置文件就不贴出来了，无关紧要的东西
mybatis.xml:(这个文件里真的就是这么写的，什么都没写)

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

</configuration>

运行结果：

1	北京	BJP
2	上海	SHH
3	天津	TJP
4	重庆	CQW
5	长沙	CSQ
6	长春	CCT
7	成都	CDW
8	福州	FZS
9	广州	GZQ
10	贵阳	GIW
11	呼和浩特	HHC
12	哈尔滨	HBB
13	合肥	HFH
14	杭州	HZH
15	海口	VUQ
16	济南	JNK
17	昆明	KMM
18	拉萨	LSO
19	兰州	LZJ
20	南宁	NNZ
21	南京	NJH
22	南昌	NCG
23	沈阳	SYT
24	石家庄	SJP
25	太原	TYV
26	乌鲁木齐南	WMR
27	武汉	WHN
28	西宁	XNO
29	西安	XAY
30	银川	YIJ
31	郑州	ZZF
32	深圳	SZQ
33	厦门	XMS
35	嘿嘿嘿	哈哈哈
36	33333333333333333333	2222222222
1	北京	BJP
2	上海	SHH
3	天津	TJP
4	重庆	CQW
5	长沙	CSQ
6	长春	CCT
7	成都	CDW
8	福州	FZS
9	广州	GZQ
10	贵阳	GIW
11	呼和浩特	HHC
12	哈尔滨	HBB
13	合肥	HFH
14	杭州	HZH
15	海口	VUQ
16	济南	JNK
17	昆明	KMM
18	拉萨	LSO
19	兰州	LZJ
20	南宁	NNZ
21	南京	NJH
22	南昌	NCG
23	沈阳	SYT
24	石家庄	SJP
25	太原	TYV
26	乌鲁木齐南	WMR
27	武汉	WHN
28	西宁	XNO
29	西安	XAY
30	银川	YIJ
31	郑州	ZZF
32	深圳	SZQ
33	厦门	XMS
35	嘿嘿嘿	哈哈哈
36	33333333333333333333	2222222222
运行时间：0.975	0.061	0.009

源码下载：https://git.oschina.net/zhuhongliang/Spring4.0.2_Mybatis3.2.0_J2SE_Study

作者朱宏亮

java, Spring 12月 27,2016

Spring4.0.2,基于注解(Annotation)版本的操作，包括jdbc【附完整源码下载】

源代码下载地址+jar包：https://git.oschina.net/zhuhongliang/spring4.0.2_Study

下面看下文档结构和数据库：

springannotation

mysql

很棒，还是只有三个文件，实现数据注入和jdbc

App.java：

package com.zhl.annotation;

import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;

public class app {

	public static void main(String[] args){
		
		ApplicationContext context = new AnnotationConfigApplicationContext(SpringConfig.class);
		
		HelloWorld obj = (HelloWorld) context.getBean("a");
		
		//obj.setMsg("天王盖地虎  \t ");
		
		obj.printHelloWorld();
		
		obj.find();
	}
}

HelloWorld.java:

package com.zhl.annotation;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.annotation.Resource;
import javax.sql.DataSource;

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

public class HelloWorld{

	private String msg;
	private String msgg;
	
	HelloWorld(){
		this.msgg = "宝塔镇河妖";
	}
	
	@Resource(name="b")
	public void setMsg(String msg){
		this.msg = msg;
	}
	
	
	@Resource(name="c")
	public void setMsgg(String msgg){
		this.msgg = msgg;
	}

	public void printHelloWorld() {
		
		System.out.println(msg + "\t" +msgg );
		
	}
	
	//下面是jdbc
	
	@Autowired
	private DataSource dataSource;
	
	
	public void setDataSource(DataSource dataSource){
		this.dataSource = dataSource;
	}


	public void find() {
		Connection conn = null;
		
		try {
			conn = dataSource.getConnection();
			String sql = "select * from `user` ";
			PreparedStatement ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				System.out.println("----------------------------------");
				System.out.println("name\t"+rs.getString("name"));
				System.out.println("age\t"+rs.getInt("age"));
				System.out.println("sex\t"+rs.getString("sex"));
				

			}
	
		}catch(Exception e){
			System.out.println(e);
		}
	}
}

SpringConfig.java:

package com.zhl.annotation;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;


@Configuration
public class SpringConfig {
	
	@Bean(name="dataSource")
    public DataSource dataSource() {  
        BasicDataSource dataSource = new BasicDataSource();  
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");  
        dataSource.setUrl("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8");  
        dataSource.setUsername("root");  
        dataSource.setPassword("root");  
        return dataSource;  
    }  

	@Bean(name="a")
	public HelloWorld helloWorld(){
		HelloWorld a = new HelloWorld();
		return a;
	}
	
	
	@Bean(name="b")
	public String msggg(){
		String msggg = "小鸡炖蘑菇";
		return msggg;
	}
	
	
	@Bean(name="c")
	public String msgggg(){
		String msgggg = "一座玲珑塔，面向青寨背靠沙！";
		return msgggg;
	}
}

运行结果：(控制台输出结果最上面两行是log4j的提示信息，不要在意这个细节)

log4j:WARN No appenders could be found for logger (org.springframework.core.env.StandardEnvironment).
log4j:WARN Please initialize the log4j system properly.
小鸡炖蘑菇	一座玲珑塔，面向青寨背靠沙！
----------------------------------
name	tom
age	88
sex	man
----------------------------------
name	孙悟空
age	99999
sex	齐天大圣

源代码下载地址+jar包：https://git.oschina.net/zhuhongliang/spring4.0.2_Study

作者朱宏亮

java, MyBatis, MySql 12月 9,2016

简单的MyBatis实例(4),实体类的属性名和数据库的字段名不一样【解决方案】

一共有两个办法。1，修改sql语句。2，使用<resultMap>映射类属性名和字段的关系。xml方式和annotation注解都是相同的。

全部代码下载地址：https://git.oschina.net/zhuhongliang/SimpleMybatisDemo/tree/differentName

这个demo还是在前几篇的基础上修改来的，下面放代码：

先看下mysql数据库的字段名和实体类的属性名：
%e6%95%b0%e6%8d%ae%e5%ba%93

User.java

package com.zhl.obj;

public class User {

	private int id_a;
	private String namea;
	private int newAgehehe;
	
	public int getId_a() {
		return id_a;
	}
	public void setId_a(int id_a) {
		this.id_a = id_a;
	}
	public String getNamea() {
		return namea;
	}
	public void setNamea(String namea) {
		this.namea = namea;
	}
	public int getNewAgehehe() {
		return newAgehehe;
	}
	public void setNewAgehehe(int newAgehehe) {
		this.newAgehehe = newAgehehe;
	}
	
	public String toString(){
		return "User [id= "+id_a+",name= "+namea+",age= "+newAgehehe+"]";
	}
}

下面先看下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.zhl.mapping.userMapper">

	

       <!-- 没有修改sql语句，resultMap的值是下面resultMap标签的id值 -->
	<!-- 查一个 -->
	<select id="getUser" parameterType="int" resultMap="getUserMap">        
		select * from users where id = #{id_a}
	</select>

        <!--这里用resultMap标签 映射user类和数据库字段 -->

	<resultMap type="User" id="getUserMap">
            <!-- 用id属性来映射主键字段 -->
            <id property="id_a" column="id"/>
            <!-- 用result属性来映射非主键字段 -->
            <result property="newAgehehe" column="age"/>
            <result property="namea" column="name"/>
        </resultMap>
	


       <!-- 下面的都没什么修改，sql语句的变量要写实体类的属性：#{namea}, #{newAgehehe} -->


	<!-- 增 -->
	<insert id="addUser" parameterType="User">
		insert into users(name, age) values(#{namea}, #{newAgehehe})
	</insert>

	<!-- 删 -->
	<delete id="deleteUser" parameterType="String">
		delete from users where name =#{namea}
	</delete>

	<!-- 改 -->
	<update id="updateUser" parameterType="User">
		update users set name=#{namea}, age =#{newAgehehe} where id=#{id_a}
	</update>


         <!-- 直接修改sql语句 -->
	<!-- 查全部 -->
	<select id="getAll"  resultType="User">
		select id id_a, name namea, age newAgehehe from users
	</select>
</mapper>

下面看看annotation版本的代码：

package com.zhl.mapping;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.Results;
import com.zhl.obj.User;

public interface UserMapperI {

	
	@Insert("insert into users (name, age) values(#{namea}, #{newAgehehe})")
	public int addUser(User user);
	//直接修改sql语句
	@Select("select id id_a, name namea, age newAgehehe from users where id = #{id_a}")
	public User getUser(int id);
	
        //使用Result映射实体类的属性和数据库的字段
	@Select("select * from users")
	@Results({  
        @Result(id=true,column="id",property="id_a"),  
        @Result(column="name",property="namea"),  
        @Result(column="age",property="newAgehehe")
              }) 
	public List getAll();
	
	@Update("update users set name= #{namea}, age=#{newAgehehe} where id= #{id_a}")
	public int updateUser (User user);
	
	@Delete("delete from users where name = #{namea}")
	public int deleteUser(String name);
	
}

就这么简单，全部代码下载地址：https://git.oschina.net/zhuhongliang/SimpleMybatisDemo/tree/differentName

作者朱宏亮

Tag annotation