[bigdata-077] maven+mybatis+mysql 数据库 mybatis xml文件方式
1. 在eclipse创建安一个maven项目 2. 给pom增加依赖 <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.4</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.25</version> </dependency> 3. 项目的目录和文件结构 ├── config 4. App.java文件内容如下: package com.tttzzz.demo.mybatisxml; import java.io.IOException; import java.io.Reader; 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 App { public static void main( String[] args ) throws IOException { String resource = "MyBatis-Configuration.xml"; Reader reader = Resources.getResourceAsReader(resource); SqlSessionFactoryBuilder builfer = new SqlSessionFactoryBuilder(); SqlSessionFactory factory = builfer.build(reader); SqlSession session = factory.openSession(); UserDao userDao = session.getMapper(UserDao.class); //查询数据库中记录总数 System. out .println("数据库中的记录数:" + userDao.countAll()); session.commit(); } } 5.?UserDao.java 内容如下 package com.tttzzz.demo.mybatisxml; public interface UserDao { public int insert(User user); public int countAll(); } 6. User.java内容如下 package com.tttzzz.demo.mybatisxml; public class User { private int id; private String usename; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUsename() { return usename; } public void setUsename(String usename) { this.usename = usename; } } 7.?UserDaoMapper.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.tttzzz.demo.mybatisxml.UserDao"> <select id="countAll" resultType="int"> <!-- 查询表中记录总数 --> select count(*) c from tb_user; </select> </mapper> 8.MyBatis-Configuration.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> <environments default= "development" > <environment id= "development" > <transactionManager type= "JDBC" /> <dataSource type= "POOLED" > <property name= "driver" value= "com.mysql.jdbc.Driver" /> <property name= "url" value="jdbc:mysql://192.168.1.22:3306/pyspiderdb?useUnicode=true&characterEncoding=UTF8"/> <property name= "username" value= "root" /> <property name= "password" value= "t8" /> </dataSource> </environment> </environments> <mappers> <mapper resource= "com/tttzzz/demo/mybatisxml/UserDaoMapper.xml" /> </mappers> </configuration>? (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |