Mybatis框架

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>
	<!-- 给类加别名 -->
	<typeAliases>
		<typeAlias type="com.bdqn.po.Users" alias="Users"/>
	</typeAliases>
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="oracle.jdbc.driver.OracleDriver" />
				<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl" />
				<property name="username" value="scott" />
				<property name="password" value="scott" />
			</dataSource>
		</environment>
	</environments>

	<!--加载mapper实体类映射文件-->
	<mappers>
		<mapper resource="com/bdqn/mapper/UsersMapper.xml" />
	</mappers>
</configuration>

实体类Mapper映射文件 UsersMapper.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.bdqn.mapper.UsersMapper">
	<select id="selectUsersByUsersid" parameterType="Users" resultType="Users">
		select * from Users where userid=#{userid}
	</select>
	<select id="selectUsers" resultType="Users">
		select * from Users
	</select>

	<!--增加数据-->
	<insert id="addUsers" parameterType="Users">
		insert into Users(userid,username,pwd)
		values(seq_userid.nextval,#{username},#{pwd})
	</insert>

	<!--修改数据-->
	<update id="updateUsers" parameterType="Users">
		update Users set username=#{username},pwd=#{pwd} where userid=#{userid}
	</update> 

	<!--删除数据-->
	<delete id="deleteUsers" parameterType="int">
		delete from Users where userid=#{userid}
	</delete>
</mapper> 

加载mybatis-config.xml的类

<pre class="java" name="code">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.bdqn.mapper.UsersMapper;
import com.bdqn.po.Users;

public class TestMapperSelectUsers {
	public static void main(String[] args) throws IOException {
		InputStream inputStream=Resources.getResourceAsStream("mybatis-config.xml");
		SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
		SqlSession session=sqlSessionFactory.openSession();
		UsersMapper usersMapper=session.getMapper(UsersMapper.class);
		//查询全部
//		List<Users> list=usersMapper.selectUsers();
//		for(int i=0;i<list.size();i++){
//			System.out.println(list.get(i).getUsername()+"--"+list.get(i).getPwd());
//		}
		
		//查询单个
//		Users users=usersMapper.selectUsersByUsersid(2);
//		System.out.println(users.getUsername()+"--"+users.getPwd());
		
		//修改
//		Users users=new Users();
//		users.setUsername("何何");
//		users.setPwd("hehe");
//		users.setUserid(666);
//		usersMapper.updateUsers(users);
//		session.commit();
//		session.close();
		
		//增加
//		Users users=new Users();
//		users.setUsername("温度");
//		users.setPwd("wendu");
//		usersMapper.addUsers(users);
		
		//删除
		Users users=new Users();
		users.setUserid(4);
		usersMapper.deleteUsers(users);
		session.commit();
		session.close();
	}
}

另一种方法直接调用session中规定好的方法<pre class="java" name="code">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.bdqn.po.Users;
import com.bdqn.util.DBUtil;

public class TestSelectUsers {
	public static void main(String[] args) throws IOException {
//		String resource = "mybatis-config.xml";
//		InputStream inputStream = Resources.getResourceAsStream(resource);
//		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//		SqlSession session=sqlSessionFactory.openSession();
		SqlSession session=DBUtil.getSqlSession();
		//查询单个
		Users u=new Users();
		u.setUserid(2);
		Users user=session.selectOne("com.bdqn.mapper.UsersMapper.selectUsersByUsersid", u);
		System.out.println(user.getUsername());
		//查询全部
//		Users users=new Users();
//		List<Users> u=session.selectList("com.bdqn.mapper.UsersMapper.selectUsers");
//		for (int i = 0; i < u.size(); i++) {
//			System.out.println(u.get(i).getUsername());
//		}
		
		//增加
//		
//		u.setUsername("小刚");
//		u.setPwd("xiaogang");
//		session.insert("com.bdqn.mapper.UsersMapper.addUsers", u);
//		session.commit();
//		session.close();
		
		//修改
//		Users u=new Users();
//		u.setUserid(666);
//		u.setUsername("果果");
//		u.setPwd("guoguo");
//		session.update("com.bdqn.mapper.UsersMapper.updateUsers", u);
//		session.commit();
//		session.close();
		
		//删除
//		Users u=new Users();
//		u.setUserid(3);
//		session.delete("com.bdqn.mapper.UsersMapper.deleteUsers", u);
//		session.commit();
		session.close();
		
	}
}