Mybatis手写Mybatis框架测试手写的mybatis框架的功能-----Mybatis框架

落日映苍穹つ 2024-03-24 22:19 86阅读 0赞

>     package com.powernode.Test;
>     
>     import com.powernode.godbatis.pojo.User;
>     import org.god.ibatis.core.SqlSession;
>     import org.god.ibatis.core.SqlSessionFactory;
>     import org.god.ibatis.core.SqlSessionFactoryBuilder;
>     import org.god.ibatis.utils.Resources;
>     import org.junit.Test;
>     
>     public class UserMapperTest
>     {
>         @Test
>         public void Test()
>         {
>             SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
>             SqlSessionFactory build = sqlSessionFactoryBuilder.build(Resources.getResourceAsStream("mybatis-config.xml"));
>             SqlSession sqlSession = build.openSession();
>             Object o = sqlSession.SelectOne("abc.selectById", 1111);
>             System.out.println(o);
>             User user = new User("11","sun","sa");
>             int insert = sqlSession.insert("abc.insertUser", user);
>             sqlSession.commit();
>             sqlSession.close();
>         }
>     }
> 
>     package com.powernode.Test;
>     
>     import com.powernode.godbatis.pojo.User;
>     import org.god.ibatis.core.SqlSession;
>     import org.god.ibatis.core.SqlSessionFactory;
>     import org.god.ibatis.core.SqlSessionFactoryBuilder;
>     import org.god.ibatis.utils.Resources;
>     import org.junit.Test;
>     
>     public class UserMapperTest
>     {
>         @Test
>         public void Test()
>         {
>             SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
>             SqlSessionFactory build = sqlSessionFactoryBuilder.build(Resources.getResourceAsStream("mybatis-config.xml"));
>             SqlSession sqlSession = build.openSession();
>             Object o = sqlSession.SelectOne("abc.selectById", 1111);
>             System.out.println(o);
>             User user = new User("11","sun","sa");
>             int insert = sqlSession.insert("abc.insertUser", user);
>             sqlSession.commit();
>             sqlSession.close();
>         }
>     }

>     package com.powernode.godbatis.pojo;
>     
>     public class User
>     {
>         private String id;
>         private String name;
>         private String age;
>     
>         public String getId() {
>             return id;
>         }
>     
>         @Override
>         public String toString() {
>             return "User{" +
>                     "id='" + id + '\'' +
>                     ", name='" + name + '\'' +
>                     ", age='" + age + '\'' +
>                     '}';
>         }
>     
>         public void setId(String id) {
>             this.id = id;
>         }
>     
>         public String getName() {
>             return name;
>         }
>     
>         public void setName(String name) {
>             this.name = name;
>         }
>     
>         public String getAge() {
>             return age;
>         }
>     
>         public void setAge(String age) {
>             this.age = age;
>         }
>     
>         public User(String id, String name, String age) {
>             this.id = id;
>             this.name = name;
>             this.age = age;
>         }
>     
>         public User() {
>         }
>     }
> 
>     package com.powernode.godbatis.pojo;
>     
>     public class User
>     {
>         private String id;
>         private String name;
>         private String age;
>     
>         public String getId() {
>             return id;
>         }
>     
>         @Override
>         public String toString() {
>             return "User{" +
>                     "id='" + id + '\'' +
>                     ", name='" + name + '\'' +
>                     ", age='" + age + '\'' +
>                     '}';
>         }
>     
>         public void setId(String id) {
>             this.id = id;
>         }
>     
>         public String getName() {
>             return name;
>         }
>     
>         public void setName(String name) {
>             this.name = name;
>         }
>     
>         public String getAge() {
>             return age;
>         }
>     
>         public void setAge(String age) {
>             this.age = age;
>         }
>     
>         public User(String id, String name, String age) {
>             this.id = id;
>             this.name = name;
>             this.age = age;
>         }
>     
>         public User() {
>         }
>     }

>     <?xml version="1.0" encoding="UTF-8" ?>
>     
>     <configuration>
>         <environments default="development">
>             <environment id="development">
>                 <transactionManager type="JDBC"/>
>                 <dataSource type="UNPOOLED">
>                     <property name="driver" value="com.mysql.cj.jdbc.Driver" />
>                     <property name="url" value="jdbc:mysql://localhost:13306/powernode" />
>                     <property name="username" value="root" />
>                     <property name="password" value="abc123" />
>                 </dataSource>
>             </environment>
>         </environments>
>         <mappers>
>     
>             <mapper resource="UserMapper.xml"></mapper>
>         </mappers>
>     </configuration>
> 
>     <?xml version="1.0" encoding="UTF-8" ?>
>     
>     <configuration>
>         <environments default="development">
>             <environment id="development">
>                 <transactionManager type="JDBC"/>
>                 <dataSource type="UNPOOLED">
>                     <property name="driver" value="com.mysql.cj.jdbc.Driver" />
>                     <property name="url" value="jdbc:mysql://localhost:13306/powernode" />
>                     <property name="username" value="root" />
>                     <property name="password" value="abc123" />
>                 </dataSource>
>             </environment>
>         </environments>
>         <mappers>
>     
>             <mapper resource="UserMapper.xml"></mapper>
>         </mappers>
>     </configuration>

>     <?xml version="1.0" encoding="ISO-8859-1"?>
>     
>     <!DOCTYPE mapper
>             PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
>             "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
>     
>     <mapper namespace="abc">
>         <insert id="insertUser">
>             insert into t_user(id,name,age)
>             values(#{id},#{name},#{age});
>         </insert>
>         <select id="selectById" resultType="com.powernode.godbatis.pojo.User">
>             select * from t_user where id = #{id};
>         </select>
>     </mapper>
> 
>     <?xml version="1.0" encoding="ISO-8859-1"?>
>     
>     <!DOCTYPE mapper
>             PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
>             "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
>     
>     <mapper namespace="abc">
>         <insert id="insertUser">
>             insert into t_user(id,name,age)
>             values(#{id},#{name},#{age});
>         </insert>
>         <select id="selectById" resultType="com.powernode.godbatis.pojo.User">
>             select * from t_user where id = #{id};
>         </select>
>     </mapper>

>     <?xml version="1.0" encoding="UTF-8"?>
>     <project xmlns="http://maven.apache.org/POM/4.0.0"
>              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
>         <modelVersion>4.0.0</modelVersion>
>     
>         <groupId>org.god.ibatis</groupId>
>         <artifactId>godbatis</artifactId>
>         <version>1.0</version>
>         <packaging>jar</packaging>
>         <dependencies>
>             <dependency>
>                 <groupId>org.dom4j</groupId>
>                 <artifactId>dom4j</artifactId>
>                 <version>2.1.3</version>
>             </dependency>
>             <dependency>
>                 <groupId>jaxen</groupId>
>                 <artifactId>jaxen</artifactId>
>                 <version>1.2.0</version>
>             </dependency>
>             <dependency>
>                 <groupId>junit</groupId>
>                 <artifactId>junit</artifactId>
>                 <version>4.13.2</version>
>                 <scope>test</scope>
>             </dependency>
>             <dependency>
>                 <groupId>mysql</groupId>
>                 <artifactId>mysql-connector-java</artifactId>
>                 <version>8.0.30</version>
>             </dependency>
>         </dependencies>
>         <properties>
>             <maven.compiler.source>17</maven.compiler.source>
>             <maven.compiler.target>17</maven.compiler.target>
>             <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
>         </properties>
>     
>     </project>
> 
>     <?xml version="1.0" encoding="UTF-8"?>
>     <project xmlns="http://maven.apache.org/POM/4.0.0"
>              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
>         <modelVersion>4.0.0</modelVersion>
>     
>         <groupId>org.god.ibatis</groupId>
>         <artifactId>godbatis</artifactId>
>         <version>1.0</version>
>         <packaging>jar</packaging>
>         <dependencies>
>             <dependency>
>                 <groupId>org.dom4j</groupId>
>                 <artifactId>dom4j</artifactId>
>                 <version>2.1.3</version>
>             </dependency>
>             <dependency>
>                 <groupId>jaxen</groupId>
>                 <artifactId>jaxen</artifactId>
>                 <version>1.2.0</version>
>             </dependency>
>             <dependency>
>                 <groupId>junit</groupId>
>                 <artifactId>junit</artifactId>
>                 <version>4.13.2</version>
>                 <scope>test</scope>
>             </dependency>
>             <dependency>
>                 <groupId>mysql</groupId>
>                 <artifactId>mysql-connector-java</artifactId>
>                 <version>8.0.30</version>
>             </dependency>
>         </dependencies>
>         <properties>
>             <maven.compiler.source>17</maven.compiler.source>
>             <maven.compiler.target>17</maven.compiler.target>
>             <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
>         </properties>
>     
>     </project>