MyBatis 实战

数据库

文件目录：

代码：User. (配置文件)

<?  version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://myb atis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="test">	<select id="getUserById" parameterType="int" resultType="com.neuedu.model.User">		select * from user where usersid = #{usersid}	</select>	<select id="getAllUsers" resultType="com.neuedu.model.User">		select * from user	</select></mapper>

sqlMapConfig. （配置文件）

<?  version="1.0" encoding="UTF-8"?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>		<!-- 和spring整合后 environments配置将废除-->	<environments default="development">		<environment id="development">		<!-- 使用jdbc事务管理，事务控制由mybatis-->			<transactionManager type="JDBC" />		<!-- 数据库连接池，由mybatis管理-->			<dataSource type="POOLED">				<property name="driver" value="com.mysql.jdbc.Driver" />				<property name="url" value="jdbc:mysql://localhost:3306/exam" />				<property name="username" value="root" />				<property name="password" value="439901" />			</dataSource>		</environment>	</environments>	<!-- 加载 映射文件 -->	<mappers>		 <mapper resource="sqlMap/User. "></mapper>	</mappers>	</configuration>

User.java

package com.neuedu.model;public class User {	private int usersid;	private String username;	private String password;	private int phone;	private String email;	public int getUserid() {		return usersid;	}	public void setUserid(int userid) {		this.usersid = userid;	}	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;	}	public int getPhone() {		return phone;	}	public void setPhone(int phone) {		this.phone = phone;	}	public String getEmail() {		return email;	}	public void setEmail(String email) {		this.email = email;	}	@Override	public String toString() {		return "User [usersid=" + usersid + ", username=" + username + ", password=" + password + ", phone=" + phone				+ ", email=" + email + "]";	}		}

UserTest.java

package com.neuedu.test;import java.io.IOException;import java.io.InputStream;import java.util.List;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import com.neuedu.model.User;public class UserTest {	public static void main(String[] args) throws IOException {		InputStream inputStream = Resources.getResourceAsStream("sqlMapConfig. ");		SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(inputStream);				SqlSession session = ssf.openSession();	/*	User user =(User)session.selectOne("test.getUserById",1);		System.out.println(user);*/				List<User> users = session.selectList("test.getAllUsers");		for(User user : users) {			System.out.println(user);					}			}}

jdbc.properties

jdbc.driver=oracle.jdbc.driver.OracleDriverjdbc.url=jdbc:oracle:thin:@localhost:1521:orcljdbc.username=oaecjdbc.password=oaec

log4j.properties

# Global logging configuration#u5728u5f00u53d1u73afu5883u4e0bu65e5u5fd7u7ea7u522bu8981u8bbeu7f6eu6210DEBUGuff0cu751fu4ea7u73afu5883u8bbeu7f6eu6210infou6216errorlog4j.rootLogger=DEBUG, stdout# Console output...log4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

输出：

二、mybatis_Mapper代理方法

文件目录：

代码：User. (配置文件)

<?  version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://myb atis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.neuedu.mapper.UserMapper">	<select id="getUserById" parameterType="int" resultType="com.neuedu.model.User">		select * from user where usersid = #{usersid}	</select>	<select id ="getAllUsers" resultType="com.neuedu.model.User">		select * from user	</select></mapper>

sqlMapConfig. （配置文件）

<?  version="1.0" encoding="UTF-8"?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>	<!-- 和spring整合后 environments配置将废除-->	<environments default="development">		<environment id="development">		<!-- 使用jdbc事务管理，事务控制由mybatis-->			<transactionManager type="JDBC" />		<!-- 数据库连接池，由mybatis管理-->			<dataSource type="POOLED">				<property name="driver" value="com.mysql.jdbc.Driver" />				<property name="url" value="jdbc:mysql://localhost:3306/exam" />				<property name="username" value="root" />				<property name="password" value="439901" />			</dataSource>		</environment>	</environments>	<!-- 加载 映射文件 -->	<mappers>		 <mapper resource="sqlMap/User. "></mapper>	</mappers>	</configuration>

User.java

package com.neuedu.model;public class User {	private int usersid;	private String username;	private String password;	private int phone;	private String email;	public int getUserid() {		return usersid;	}	public void setUserid(int userid) {		this.usersid = userid;	}	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;	}	public int getPhone() {		return phone;	}	public void setPhone(int phone) {		this.phone = phone;	}	public String getEmail() {		return email;	}	public void setEmail(String email) {		this.email = email;	}	@Override	public String toString() {		return "User [usersid=" + usersid + ", username=" + username + ", password=" + password + ", phone=" + phone				+ ", email=" + email + "]";	}		}

UserMapper.java

package com.neuedu.mapper;import java.util.List;import com.neuedu.model.User;public interface UserMapper {	public User getUserById(int usersid);	public List<User> getAllUsers();}

UserMapperTest.java

package com.neuedu.test;import java.io.IOException;import java.io.InputStream;import java.util.List;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import com.neuedu.mapper.UserMapper;import com.neuedu.model.User;public class UserMapperTest {	public static void main(String[] args) throws IOException {		InputStream inputStream = Resources.getResourceAsStream("sqlMapConfig. ");		SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(inputStream);		SqlSession session = ssf.openSession();				UserMapper mapper = session.getMapper(UserMapper.class);		/*User user = mapper.getUserById(1);		System.out.println(user);*/				List<User> users = mapper.getAllUsers();		for(User user : users) {			System.out.println(user);					}		                                                                                                                                                                                                                       			}}

UserTest.java

package com.neuedu.test;import java.io.IOException;import java.io.InputStream;import java.util.List;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import com.neuedu.model.User;public class UserTest {	public static void main(String[] args) throws IOException {		InputStream inputStream = Resources.getResourceAsStream("sqlMapConfig. ");		SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(inputStream);				SqlSession session = ssf.openSession();	/*	User user =(User)session.selectOne("test.getUserById",1);		System.out.println(user);*/				List<User> users = session.selectList("test.getAllUsers");		for(User user : users) {			System.out.println(user);					}			}}

输出：