spring和mybatis是用注解方式进行开发

很久没有编程了，最近又在捣弄这些。感觉还可以。这里记录一下自己的信息。如果使用spring与mybatis是用注解方式进行开发。
1，获取jar包，这里采用那个maven的方式。具体内容为：

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>6.0.4</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.4.4</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>4.3.10.RELEASE</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>4.3.10.RELEASE</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-beans -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-beans</artifactId>
			<version>4.3.10.RELEASE</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.1</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2 -->
		<dependency>
			<groupId>org.apache.commons</groupId>
			<artifactId>commons-dbcp2</artifactId>
			<version>2.1.1</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>4.3.10.RELEASE</version>
		</dependency>

然后编辑po信息：

package com.duduli.li;

public class Cp {
	private int id;
	private String chddm;
	private String bh;
	private String zh;
	private String sl;
	private String zt;
	private String gh;
	private String xssj;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getChddm() {
		return chddm;
	}
	public void setChddm(String chddm) {
		this.chddm = chddm;
	}
	public String getBh() {
		return bh;
	}
	public void setBh(String bh) {
		this.bh = bh;
	}
	public String getZh() {
		return zh;
	}
	public void setZh(String zh) {
		this.zh = zh;
	}
	public String getSl() {
		return sl;
	}
	public void setSl(String sl) {
		this.sl = sl;
	}
	public String getZt() {
		return zt;
	}
	public void setZt(String zt) {
		this.zt = zt;
	}
	public String getGh() {
		return gh;
	}
	public void setGh(String gh) {
		this.gh = gh;
	}
	/**
	 * @return the xssj
	 */
	public String getXssj() {
		return xssj;
	}
	/**
	 * @param xssj the xssj to set
	 */
	public void setXssj(String xssj) {
		this.xssj = xssj;
	}
	/* (non-Javadoc)
	 * @see java.lang.Object#toString()
	 */
	@Override
	public String toString() {
		return "Cp [id=" + id + ", chddm=" + chddm + ", bh=" + bh + ", zh=" + zh + ", sl=" + sl + ", zt=" + zt + ", gh="
				+ gh + ", xssj=" + xssj + "]";
	}

	
}

在下来就是spring的配置：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd   
                http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd">

	<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url"
			value="jdbc:mysql://localhost:3306/hnfc?serverTimezone=UTC" />
		<property name="username" value="root" />
		<property name="password" value="xxxxxx" />
		<!-- 连接初始值，连接池启动时创建的连接数量的初始值 默认值是0 -->
		<property name="initialSize" value="3" />
		<!-- 最小空闲值.当空闲的连接数少于阀值时，连接池就会预申请去一些连接，以免洪峰来时来不及申请 默认值是0 -->
		<property name="minIdle" value="3" />
		<!-- 最大空闲值.当经过一个高峰时间后，连接池可以慢慢将已经用不到的连接慢慢释放一部分，一直减少到maxIdle为止 ，0时无限制 默认值是8 -->
		<property name="maxIdle" value="5" />
		<!-- 连接池的最大值，同一时间可以从池分配的最多连接数量，0时无限制 默认值是8 -->
		<property name="maxTotal" value="15" />
	</bean>

	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
	</bean>
	<!-- 此配置是解决spring运行的时候对mapper接口映射的 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.duduli.li" />
	</bean>
	<context:annotation-config></context:annotation-config>
	<context:component-scan base-package="com.duduli.li"></context:component-scan>

</beans>

这里注意

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.duduli.li" />
	</bean>

接下来mybatis的接口

@Repository("mapper")
public interface CPmapper {
	@Select("select * from cp")
	public List<Cp> getAllCP();
	
	@Select("select id from cp")
	public List<Integer> getAllId();
}

再下来就是，方法接口

public interface CPservice {
	public List<Cp> getAllCP();
	public void getAllId();
}

方法实现类：

@Component("cpservice")
public class CPserviceImpl implements CPservice {
	@Autowired
	@Qualifier("mapper")
	private CPmapper cpmapper;
	public List<Cp> getAllCP() {
		// TODO Auto-generated method stub
		for(Cp c:cpmapper.getAllCP()) {
			System.out.println(c.toString());
		}
		return cpmapper.getAllCP();
	}
	
	public void getAllId() {
		for(int i:cpmapper.getAllId()) {
			System.out.println(i);
		}
	}

}

最后就是测试类：

	public static void main(String[] args) {
		// TODO Auto-generated method stub
        String[] files = {"com/duduli/li/springContext.xml" };     
		ApplicationContext context = new ClassPathXmlApplicationContext(files);     
//        UserService userService = (UserService) context.getBean("userService");  
        CPservice cpservice = (CPservice) context.getBean("cpservice");
//        cpservice.getAllCP();
        cpservice.getAllId();
	}