使用Mybatis封装jdbc，实现列表数据增删改查功能

mybatis

mybatis src

com.bdqn.dao

UserDao.java
UserDaoXml.xml

com.bdqn.entity

User.java

com.bdqn.uitls

MySqlSession.java

database.properties

log4j.properties

mybatis-config.xml

需要用到jar包

log4j-1.2.16.jar
mybatis-3.2.2-sources.jar
mybatis-3.2.2.jar
mysql-connector-java-3.1.10-bin.jar

UserDao.java

package com.bdqn.dao;

import java.util.List;

import com.bdqn.entity.User;

public interface UserDao {
 List<User> selectAll();

 int deleteByid(int uid);

 int update(User user);

 List<User> selectByName(String str);

 int insert(User user);

}

UserDaoXml.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.dao.UserDao">

    <select id="count" resultType="int">
    select count(1) from user
    </select>

    <select id="selectAll" resultType="com.bdqn.entity.User">
    select *from user
    </select>

    <delete id="deleteByid" parameterType="int" >
    delete from user where uid=#{uid}
    </delete>

    <update id="update" parameterType="com.bdqn.entity.User">
    update user set uname=#{uname},upwd=#{upwd} where uid=#{uid}
    </update>

    <select id="selectByName" resultType="com.bdqn.entity.User" parameterType="String">
    select uid,uname,upwd from user where uname like concat('%',#{str},'%')
    <!--关键字：concat  -->
    </select>

    <insert id="insert" parameterType="com.bdqn.entity.User">
    insert into user values(#{uid},#{uname},#{upwd})
    </insert>
</mapper>

User.java

package com.bdqn.entity;

import java.io.Serializable;

public class User implements Serializable{
private int uid;
private String uname;
private String upwd;
public int getUid() {
    return uid;
}
public void setUid(int uid) {
    this.uid = uid;
}
public String getUname() {
    return uname;
}
public void setUname(String uname) {
    this.uname = uname;
}
public String getUpwd() {
    return upwd;
}
public void setUpwd(String upwd) {
    this.upwd = upwd;
}
@Override
public String toString() {
    return "User [uid=" + uid + ", uname=" + uname + ", upwd=" + upwd + "]";
}

}

MySqlSession.java

package com.bdqn.uitls;

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;



public class MySqlSession {


    private static SqlSessionFactory factory = null;

    static{

        InputStream is =null;
        try {
            is = Resources.getResourceAsStream("mybatis-config.xml");
        } catch (IOException e) {
            e.printStackTrace();    
        }       

        factory =  new SqlSessionFactoryBuilder().build(is);

    }



    public static SqlSession getSession() {
        //false:取消自动提交
        SqlSession session = factory.openSession(false);

        return session;
    }

    public static void closeSession(SqlSession session){
        if(session!=null){
            session.close();
        }

    }




}

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">

<!-- 通过这个配置文件完成mybatis与数据库的连接 -->
<configuration>
    <!-- 引入 database.properties 文件-->
    <properties resource="database.properties"/>
    <!-- 配置mybatis的log实现为LOG4J -->
    <settings>
        <setting name="logImpl" value="LOG4J" />
    </settings>
    <environments default="development">
        <environment id="development">
            <!--配置事务管理，采用JDBC的事务管理  -->
            <transactionManager type="JDBC"></transactionManager>
            <!-- POOLED:mybatis自带的数据源，JNDI:基于tomcat的数据源 -->
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${user}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>

    <!-- 将mapper文件加入到配置文件中 -->
    <mappers>
        <mapper resource="com/bdqn/dao/UserDaoXml.xml"/>
    </mappers>



</configuration>

Test.java

package com.bdqn.test;




import java.util.List;

import org.apache.ibatis.session.SqlSession;

import com.bdqn.dao.UserDao;
import com.bdqn.entity.User;
import com.bdqn.uitls.MySqlSession;




public class Test {

    public static void main(String[] args) {
        SqlSession session = null;
        try {
            session = MySqlSession.getSession();
            UserDao ud = session.getMapper(UserDao.class);

            //全查
            List<User> list = ud.selectAll();
            System.out.println(list.toString());

            /*//删除
            int result = ud.deleteByid(1);
            //提交事务
            session.commit();
            System.out.println(result);*/

            /*//更新
            User user = new User();
            user.setUid(2);
            user.setUname("更新");
            user.setUpwd("更新");
            int result2 = ud.update(user);
            System.out.println(result2);
            session.commit();*/

            //模糊查询
            List<User> list2 = ud.selectByName("admin");
            System.out.println(list2.toString());

            //添加
            User user4 = new User();
            user4.setUid(6);
            user4.setUname("添加");
            user4.setUpwd("添加");
            int insertResult = ud.insert(user4);
            session.commit();
            System.out.println(insertResult);

        } catch (Exception e) {
            e.printStackTrace();
            //事务回滚
            session.rollback();
        } finally{
            if(session!=null){
                session.close();
            }
        }

    }

}