一.将需要的包拷贝到lib中
总共的包为:
二.在src中写相应的代码 eg:
1)在src下建立一个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>
<properties resource="config.properties">
</properties>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driverClass}"/>
<property name="url" value="${jdbc.jdbcUrl}"/>
<property name="username" value="${jdbc.user}"/>
<property name="password" value="${jdbc.password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/gxa/bj/modle/UserInfoMapper.xml"/>
</mappers>
</configuration>
2)在src下建立一个config.properties方便其他项目调用,代码如下:
jdbc.jdbcUrl=jdbc:oracle:thin:@127.0.0.1:1521:orcl
jdbc.driverClass=oracle.jdbc.driver.OracleDriver
jdbc.user=bbs
jdbc.password=123
3)搭建modle,dao和dao.imp层:
dao接口层:
package com.gxa.bj.dao;
import java.sql.SQLException;
import java.util.List;
/**
* @author Administrator
*针对数据库中增删改查的方法的接口
* @param <T>
*/
public interface IDaoBBs<T> {
/**
* @param t
* @return 向数据库表里添加一条数据的方法
* @throws SQLException
*/
public int addItem(T t) ;
/**
* @param objId
* @return 从数据库表里删除一条数据的方法
* @throws SQLException
*/
public int removeItem(Object objId) ;
/**
* @param t
* @return 跟新数据库表里一条字段的方法
* @throws SQLException
*/
public int updateItem(T t) ;
/**
* @param objId
* @return 根据主键的字段获取该条信息,并将它转化为实体的对象
* @throws SQLException
*/
public T getMolde(Object objId) ;
/**
* @param t
* @return 根据查询条件获取多条数据,并转化为相应的集合
* @throws SQLException
*/
public List<T> getList(T t) ;
}
modle层,除了数据表的外添加一个针对某个数据表的增,删,改,查的mapper.xml like: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="<span style="background-color: rgb(255, 0, 0);">com.gxa.bj.dao.imp.UserMapper</span>">用来连接到dao.imp
<insert id="addItem" parameterType="com.gxa.bj.modle.UserInfo">
insert into UserInfo(userId,userName,userPwd,userEmail)
values(usernext.nextval,#{userName},#{userPwd},#{userEmail})
</insert>
<delete id="removeItem" >
delete from UserInfo where userId = #{id}
</delete>
<update id="updateItem" parameterType="com.gxa.bj.modle.UserInfo">
update UserInfo set userName=#{userName},userPwd=#{userPwd},userEmail=#{userEmail}
where userId=#{userId}
</update>
<select id="getMolde" resultType="com.gxa.bj.modle.UserInfo">
select * from UserInfo where userId = #{id}
</select>
<select id="getUsers" parameterType="java.lang.String" resultSets="com.gxa.bj.modle.UserInfo" resultType="com.gxa.bj.modle.UserInfo">
select * from UserInfo where userName like '%${value}%'
</select>
</mapper>
dao.imp层,通过接口来实现接口里的方法,建立一个接口UserMapper来继承dao中的接口:
package com.gxa.bj.dao.imp;
import java.util.List;
import com.gxa.bj.dao.IDaoBBs;
import com.gxa.bj.modle.UserInfo;
public interface UserMapper extends IDaoBBs<UserInfo>{
/**
* 跟据用户名进行一个模糊查询,获取用户表中该用户的信息集合
* @author chenqing
*
*/
public List<UserInfo> getUsers(String name); //查询集合时调用
}
实现TestUI:
package com.gxa.bj.dao.imp;
import java.io.IOException;
import java.io.InputStream;
import java.sql.SQLException;
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.gxa.bj.modle.UserInfo;
public class TestUI {
public static void main(String[] args) {
// TODO Auto-generated method stub
String resource = "mybatis-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 sqlSessin=sqlSessionFactory.openSession();
UserMapper userMapper=sqlSessin.getMapper(UserMapper.class);
// 添加
/* UserInfo u=new UserInfo();
u.setUserName("李四");
u.setUserPwd("123");
u.setUserEmail("www.@66.oo");
if(userMapper.addItem(u)>0){
sqlSessin.commit();
System.out.println("添加成功");
}else{
System.out.println("添加失败");
} */
//删除
/*if(userMapper.removeItem(4)>0){
sqlSessin.commit();
System.out.println("删除成功");
}else{
System.out.println("删除失败");
}*/
//修改
/* UserInfo u=new UserInfo();
u.setUserId(7);
u.setUserName("李流");
u.setUserPwd("123");
u.setUserEmail("www.@66.oo");
if(userMapper.updateItem(u)>0){
sqlSessin.commit();
System.out.println("修改成功");
}else{
sqlSessin.rollback();
System.out.println("修改失败");
} */
//查询单个
/* Integer userId=7;
UserInfo u=userMapper.getMolde(userId);
System.out.println("查询到用户名为:"+u.getUserName());*/
//查询集合
String userName="陶渊明";
List<UserInfo> u1= userMapper.getUsers(userName);
System.out.println("查询到用户信息为:"+ u1.get(0).getUserId()+u1.get(0).getUserPwd());
sqlSessin.close();
}
}