阳曲网站建设推荐咨询,wordpress给分类做模板,阿里云wordpress数据库,网站加搜索框在工作中发现mybatis默认的连接池POOLED#xff0c;运行时间长了会报莫名其妙的连接失败错误。因此采用阿里巴巴的Druid数据源#xff08;码云链接 #xff0c;中文文档链接#xff09;。 mybatis更多数据源参考博客链接 。 1 环境 eclipse mars2 maven3.3.9 mysql5.7 2 … 在工作中发现mybatis默认的连接池POOLED运行时间长了会报莫名其妙的连接失败错误。因此采用阿里巴巴的Druid数据源码云链接 中文文档链接。 mybatis更多数据源参考博客链接 。 1 环境 eclipse mars2 maven3.3.9 mysql5.7 2 开发过程 项目码云地址链接 文件目录结构如下 2.0 建立数据表 在本地mysql数据库中建立名为test的database并建立user表
CREATE DATABASE test default charsetutf8;CREATE TABLE user ( name varchar(64) DEFAULT NULL, age int(11) DEFAULT NULL ) ENGINEInnoDB DEFAULT CHARSETutf8; insert into user(name,age) values (叶莜落,27),(张三丰,128); 2.1 建立一个maven工程POM文件如下 project xmlnshttp://maven.apache.org/POM/4.0.0 xmlns:xsihttp://www.w3.org/2001/XMLSchema-instance xsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd modelVersion4.0.0/modelVersion groupIdcom.yeyouluo.mybatis.druid/groupId artifactIdmybatis-druid/artifactId version0.0.1-SNAPSHOT/version properties myabtis.version3.4.1/myabtis.version /properties dependencies dependency groupIdorg.mybatis/groupId artifactIdmybatis/artifactId version${myabtis.version}/version /dependency dependency groupIdmysql/groupId artifactIdmysql-connector-java/artifactId version5.1.30/version /dependency dependency groupIdcom.alibaba/groupId artifactIddruid/artifactId version1.0.14/version /dependency /dependencies /project 2.2 配置文件 ①db.properties drivercom.mysql.jdbc.Driver
urljdbc:mysql://localhost:3306/test usernameroot passwordroot ②mybatis-config.xml ?xml version1.0 encodingUTF-8 ?
!DOCTYPE configuration PUBLIC -//mybatis.org//DTD Config 3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtd
configuration!-- 引用db.properties配置文件 -- properties resourcedb.properties / typeAliases typeAlias typecom.yeyouluo.mybatis.druid.utils.DruidDataSourceFactory aliasDRUID / /typeAliases !-- development : 开发模式 work : 工作模式 -- environments defaultwork environment idwork transactionManager typeJDBC / !-- 配置数据库连接信息 -- dataSource typeDRUID !-- value属性值引用db.properties配置文件中配置的值 -- property namedriver value${driver} / property nameurl value${url} / property nameusername value${username} / property namepassword value${password} / /dataSource /environment /environments !-- mybatis的mapper文件每个xml配置文件对应一个接口 -- mappers mapper resourcemapper/userMapper.xml / /mappers /configuration ③在resources目录下建立userMapper.xml ?xml version1.0 encodingUTF-8 ?
!DOCTYPE mapper PUBLIC -//ibatis.apache.org//DTD Mapper 3.0//EN http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd
mapper namespacecom.yeyouluo.mybatis.druid.dao.userDao select idfindAllUsers resultTypecom.yeyouluo.mybatis.druid.pojo.User select * from user /select /mapper 2.3 实体类 User package com.yeyouluo.mybatis.druid.pojo;public class User {private String name;private int age; public String getName() { return name; } public void setName(String name) { this.name name; } public int getAge() { return age; } public void setAge(int age) { this.age age; } Override public String toString() { return User [name name , age age ]; } } 2.4 工具类 ①DruidDataSourceFactory.java package com.yeyouluo.mybatis.druid.utils;import java.sql.SQLException;
import java.util.Properties;
import javax.sql.DataSource;
import org.apache.ibatis.datasource.DataSourceFactory;
import com.alibaba.druid.pool.DruidDataSource;public class DruidDataSourceFactory implements DataSourceFactory {private Properties props;Overridepublic DataSource getDataSource() {DruidDataSource dds new DruidDataSource(); dds.setDriverClassName(this.props.getProperty(driver)); dds.setUrl(this.props.getProperty(url)); dds.setUsername(this.props.getProperty(username)); dds.setPassword(this.props.getProperty(password)); // 其他配置可以根据MyBatis主配置文件进行配置 try { dds.init(); } catch (SQLException e) { e.printStackTrace(); } return dds; } Override public void setProperties(Properties props) { this.props props; } } ②MyBatisUtil.java package com.yeyouluo.mybatis.druid.utils;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 MyBatisUtil {private static final String configFile mybatis-config.xml; /** * 创建连接 */ public static SqlSession getSession() { SqlSession session null; try { InputStream is Resources.getResourceAsStream(configFile); SqlSessionFactory factory new SqlSessionFactoryBuilder().build(is); session factory.openSession(); } catch (Exception e) { e.printStackTrace(); } return session; } public static void closeSession(SqlSession session) { session.close(); } public static void main(String[] args) { SqlSession session MyBatisUtil.getSession(); System.out.println(session); session.close(); } } 2.5 DAO ①接口IUserDao.java package com.yeyouluo.mybatis.druid.dao;import java.util.List;import com.yeyouluo.mybatis.druid.pojo.User;public interface IUserDao {public ListUser findAllUsers(); } ②实现类UserDao.java package com.yeyouluo.mybatis.druid.dao.impl;import java.util.List;import org.apache.ibatis.session.SqlSession;import com.yeyouluo.mybatis.druid.dao.IUserDao;
import com.yeyouluo.mybatis.druid.pojo.User;
import com.yeyouluo.mybatis.druid.utils.MyBatisUtil;public class UserDao implements IUserDao {private static final String namespace com.yeyouluo.mybatis.druid.dao.userDao.; Override public ListUser findAllUsers() { ListUser users null; SqlSession session MyBatisUtil.getSession(); try { users session.selectList(namespace findAllUsers, User.class); //注意此处有陷阱如果做了更新、插入或删除操作必须使用 //session.commit(); } catch (Exception e) { e.printStackTrace(); }finally{ MyBatisUtil.closeSession(session); } return users; } } 2.6 测试类UserDaoTest.java package com.yeyouluo.mybatis.druid.dao.test;import java.util.List;import com.yeyouluo.mybatis.druid.dao.IUserDao;
import com.yeyouluo.mybatis.druid.dao.impl.UserDao;
import com.yeyouluo.mybatis.druid.pojo.User;public class UserDaoTest {public static void main(String[] args) { // TODO Auto-generated method stub IUserDao userDao new UserDao(); ListUser users userDao.findAllUsers(); for(User user : users){ System.out.println(user.toString()); } } } 3 结果 4 参考 Jar程序使用MyBatis集成阿里巴巴druid连接池 转载于:https://www.cnblogs.com/helloIT/p/7676505.html
