然后点击Next
继续点击Next
点击Finish
然后去预先保存在硬盘中的文件夹里Copy一些必要的文件,再拿去Paste到建立好的项目中的lib文件夹里面,接下来纸画我具体演示一下:
(1)打开mybatis-3.4.4文件夹,可以看到
将mybatis-3.4.4.jar和lib文件夹里的文件和mysql-connector-java-5.1.44文件夹中mysql-connector-java-5.1.44-bin.jar Copy一下,再拿去Paste到建立好的项目中的lib文件夹里面
lib文件夹里的文件如图所示
得到的已建立好的项目里lib目录的内容如下
准备好log4j.properties日志文件,其内容如下
### \u8BBE\u7F6E###
log4j.rootLogger = debug,stdout,D,E
log4j.logger.httpclient.wire.header=WARN
log4j.logger.httpclient.wire.content=WARN
### \u8F93\u51FA\u4FE1\u606F\u5230\u63A7\u5236\u62AC ###
log4j.appender.stdout = org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target = System.out
log4j.appender.stdout.layout = org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern = [%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} %m%n
### \u8F93\u51FADEBUG \u7EA7\u522B\u4EE5\u4E0A\u7684\u65E5\u5FD7\u5230=E://logs/log.log ###
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
log4j.appender.D.File = ./logs/log.log
log4j.appender.D.Append = true
log4j.appender.D.Threshold = DEBUG
log4j.appender.D.layout = org.apache.log4j.PatternLayout
log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [ %p ] [ method:%l ] %m%n
### \u8F93\u51FAERROR \u7EA7\u522B\u4EE5\u4E0A\u7684\u65E5\u5FD7\u5230=E://logs/error.log ###
log4j.appender.E = org.apache.log4j.DailyRollingFileAppender
log4j.appender.E.File = ./logs/error.log
log4j.appender.E.Append = true
log4j.appender.E.Threshold = ERROR
log4j.appender.E.layout = org.apache.log4j.PatternLayout
log4j.appender.E.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [ %p ] [ method:%l ] %m%n
然后Copper下,再直接往config里Paste下,得到结果如图
在此之前,所有的准备工作都做完了
接下来看看纸画的微操作
在src建立3个包cn.sm1234.dao,cn.sm1234.domain,cn.sm1234.test
(1)cn.sm1234.domain里写r实体类Customer,其内容如下:
package cn.sm1234.domain;
public class Customer {
private Integer id;
private String name;
private String gender;
private String telephone;
private String address;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getTelephone() {
return telephone;
}
public void setTelephone(String telephone) {
this.telephone = telephone;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
}
(2)cn.sm1234.dao里写CustomerMapper接口,其内容如下:
package cn.sm1234.dao;
import cn.sm1234.domain.Customer;
public interface CustomerMapper {
/**
* 添加客户
*/
public void saveCustomer(Customer customer);
}
(3)cn.sm1234.test里下写测试类MybatisTest来调试一下项目,其内容如下:
package cn.sm1234.test;
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;
import org.junit.jupiter.api.Test;
import cn.sm1234.dao.CustomerMapper;
import cn.sm1234.domain.Customer;
public class MybatisTest {
@Test
public void test() throws Exception {
//1.创建SqlSessionFactoryBuilder
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
//加载sqlMapConfig.xml文件
InputStream in = Resources.getResourceAsStream("sqlMapConfig.xml");
//2.创建sqlSessionFactory
SqlSessionFactory factory = builder.build(in);
//3.打开SqlSession
SqlSession sqlSession = factory.openSession();
//4.获取Mapper接口的对象
CustomerMapper mapper = sqlSession.getMapper(CustomerMapper.class);
//5.操作
Customer customer = new Customer();
customer.setId(3);
customer.setName("Mike");
customer.setGender("B");
customer.setTelephone("18879736220");
customer.setAddress("Hrbligondaxue");
mapper.saveCustomer(customer);
//6.提交事务
sqlSession.commit();
//7.关闭资源
sqlSession.close();
}
}
那么到这里,src里的代码完成了,如图
接下来,纸画要对config目录做后续操作了
(1)先建立一个名为mapper的包,然后在包里写数据库的映射文件customerMapper.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">
<!-- 该文件编写mybatis中的mapper接口里面的方法提供对应的sql语句 -->
<mapper namespace = "cn.sm1234.dao.CustomerMapper">
<!-- 添加客户 -->
<insert id="saveCustomer" parameterType="cn.sm1234.domain.Customer">
INSERT INTO mybatis_customer.t_customer
(
id,
NAME,
gender,
telephone,
address
)
VALUES
(
#{id},
#{name},
#{gender},
#{telephone},
#{address}
)
</insert>
</mapper>
(2)直接往config目录新建一个名为sqlMapConfig.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://localhost:3306/mybatis_customer" />
<property name="username" value="root" />
<property name="password" value="yuyang678" />
</dataSource>
</environment>
</environments>
<mappers>
<!-- 注册customerMapper.xml文件,
customerMapper.xml位于mapper这个包下,所以resource写成mapper/customerMapper.xml-->
<mapper resource="mapper/customerMapper.xml"/>
</mappers>
</configuration>
到此为止,该项目基本完成了(重要提醒一下我用的编辑器是eclipse javaee版的,建好项目时用自己装的1.8.0版的jre,Mysql是5.7版的,Tomcat服务器是9.0.17版的,这些东西自己可以在百度上学习配置)
接下来创建数据库mybatis_customer,表名为t_customer,表中各属性为
id,NAME, gender,telephone, address
先打开mysql客户端(操作方便,其他方式也行)
然后保存,输入表名t_customer
ok,建好了所需要的数据库
然后通过运行MybatisTest就可以往表中自动填写信息了,最后刷新一下表,就可
得到结果如下图所示: