Mybatis框架

mybatis-config.xml中的文件

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//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 mapperPUBLIC "-//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();}}