mybatis的初步应用

1.一样首先导入所需的jar包

2.编写 model 层 和 dao层

Uerinfo.java 

package com.gxa.bj.model;


public class Userinfo {
	private String username;
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getUserpwd() {
		return userpwd;
	}
	public void setUserpwd(String userpwd) {
		this.userpwd = userpwd;
	}
	public String getUserid() {
		return userid;
	}
	public void setUserid(String userid) {
		this.userid = userid;
	}
	public String getUserbalace() {
		return userbalace;
	}
	public void setUserbalace(String userbalace) {
		this.userbalace = userbalace;
	}
	public String getLogintime() {
		return logintime;
	}
	public void setLogintime(String logintime) {
		this.logintime = logintime;
	}
	
	public String getPaymoney() {
		return paymoney;
	}
	public void setPaymoney(String paymoney) {
		this.paymoney = paymoney;
	}
	private String paymoney;
	private String userpwd;

	private String userid;
	private String userbalace;//用户余额
	private String logintime;//注册时间
}

IDaoP2p.java

package com.mybatis.dao;

import java.util.List;

public interface IDaoP2p<T> {
	public int addItem(T t);                //添加的接口
	public int removeItem(Object ob);      //删除的接口
	public T getModel(Object ob);        //查找的接口
	public List<T> getList(T t);              //查找返回集合

}

再写个userMapper的接口继承dao

package com.gxa.bj.dao.imp;

import com.gxa.bj.model.Userinfo;
import com.mybatis.dao.IDaoP2p;

public interface userMapper extends IDaoP2p<Userinfo>{

}

然后配置mybatis

userInfoMapper.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.gxa.bj.dao.imp.userMapper">
  <!-- 通过id查找用户 -->
  <select id="getModel" resultType="com.gxa.bj.model.Userinfo">
    select * from Userinfo where id = #{id}
  </select>
  <!-- 添加用户信息 -->
  <insert id="addItem" parameterType="com.gxa.bj.model.Userinfo">
      insert into Userinfo(userid,username,userpwd,logintime)
      values(#{userid},#{username},#{userpwd},#{logintime})
  </insert>
</mapper>

写个连接池

config.properties

jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:orcl
jdbc.name=p2p
jdbc.pwd=123

mubatis-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>
   <properties resource="config.properties">
   </properties>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.name}"/>
        <property name="password" value="${jdbc.pwd}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="com/gxa/bj/model/userInfoMapper.xml"/>
  </mappers>
</configuration>

最后写个测试类

testui.java

package com.gxa.bj.dao.imp;

import java.io.IOException;
import java.io.InputStream;

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.gxa.bj.model.Userinfo;

public class testui {
     public static void main(String[] args){
    	 String resource = "mubatis-config.xml";
     	InputStream inputStream=null;
		try {
			inputStream = Resources.getResourceAsStream(resource);
			
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
 		
     	SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
     	SqlSession sqlSession = sqlSessionFactory.openSession();
        userMapper userMapper = sqlSession.getMapper(userMapper.class);
 		Userinfo u= new Userinfo();
 		u.setUserid("12");
 		u.setUsername("ss1");
 		u.setUserpwd("3211");
 		u.setLogintime("222221");
 		if(userMapper.addItem(u)>0){
 			sqlSession.commit();
 			System.out.println("操作成功");
 		}else{
 			System.out.println("操作失败");
 		}
 		
     }
}