记录连接数据库以及mybatis入门

前提：数据库建表
idea连接mysql
idea具体操作
下面展示一些 具体代码。

pom.xml

<?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>com.baizhi.www</groupId>
  <artifactId>hospital</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>jar</packaging>

  <name>hospital Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
  </properties>

  <dependencies>
    <!--配置mybatis-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>

    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.4</version>
    </dependency>

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.19</version>
    </dependency>

    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.12</version>
    </dependency>

  </dependencies>

  <build>
    <finalName>hospital</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

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>
    <!--配置mybatis运行环境，若需要多个数据库，则需要多个environment标签-->
    <environments default="mysql">
        <!--配置一个mybatis的运行环境，id属性是这个环境唯一标识-->
        <environment id="mysql">
            <!--设置Mybatis完成数据库操作时事务的提交策略，type属性值为"JDBC"，表示用JDBC事务提交方式提交-->
            <transactionManager type="JDBC"/>
            <!--配置数据库连接，type属性值为"POOLED",表示用mybatis内置连接池-->
            <dataSource type="POOLED">
                <!--配置连接数据库的四个基本信息-->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/hospital?charset=utf-8&amp;useSSL=false&amp;serverTimezone=GMT%2B8&amp;allowPublicKeyRetrieval=true"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <!--指定映射配置文件的位置，映射配置文件指的是每个dao独立的配置文件
        如果是用注解来配置，此处应该使用class属性指定被注解的dao全限定类名-->
    <mappers>
        <mapper class="com.baizhi.dao.IPatientDao"/>
    </mappers>
</configuration>

这里我已经改成了class属性，所以IPatientDao.xml文件就可以不用了(这里只是记录一下IPatientDao.xml是怎么配置的)

IPatientDao.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.baizhi.dao.IPatientDao">

    <!--配置查询所有 id为IPatientDao中的方法名 一定要加上返回值类型！！把结果集封装到patient对象中-->
    <select id="findAll" resultType="com.baizhi.entity.Patient">
        <!--sql语句-->
        select* from Patient
    </select>
</mapper>

用注解的方式，因此要在方法前加上@Select里面执行sql语句（如果用xml方式则无需添加注解@）

IPatientDao.java

package com.baizhi.dao;

import com.baizhi.entity.Patient;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/*
* 用户持久层接口
* */
public interface IPatientDao {
    /*
    * 查询所有操作
    * */
    @Select("select * from Patient")
    List<Patient> findAll();
}

Patient实体类

package com.baizhi.entity;

import java.io.Serializable;

public class Patient implements Serializable {

    private Integer id;
    private String username;
    private String password;
    private String name;
    private String sex;
    private Integer age;
    private String idnumber;
    private String telephone;
    private String email;
    private String diseasediscription;
    private String appointment;

    public Patient(){
        super();
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getIdnumber() {
        return idnumber;
    }

    public void setIdnumber(String idnumber) {
        this.idnumber = idnumber;
    }

    public String getTelephone() {
        return telephone;
    }

    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getDiseasediscription() {
        return diseasediscription;
    }

    public void setDiseasediscription(String diseasediscription) {
        this.diseasediscription = diseasediscription;
    }

    public String getAppointment() {
        return appointment;
    }

    public void setAppointment(String appointment) {
        this.appointment = appointment;
    }

    @Override
    public String toString() {
        return "Patient{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", name='" + name + '\'' +
                ", sex='" + sex + '\'' +
                ", age=" + age +
                ", idnumber='" + idnumber + '\'' +
                ", telephone='" + telephone + '\'' +
                ", email='" + email + '\'' +
                ", diseasediscription='" + diseasediscription + '\'' +
                ", appointment='" + appointment + '\'' +
                '}';
    }
}

日志log4j.properties

### 设置###

log4j.rootLogger = debug,stdout,D,E



### 输出信息到控制抬 ###

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} method:%l%n%m%n



### 输出DEBUG 级别以上的日志到=c://logs/error.log ###

log4j.appender.D = org.apache.log4j.DailyRollingFileAppender

log4j.appender.D.File = C://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}  [ %t:%r ] - [ %p ]  %m%n



### 输出ERROR 级别以上的日志到=C://logs/error.log ###

log4j.appender.E = org.apache.log4j.DailyRollingFileAppender

log4j.appender.E.File =C://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}  [ %t:%r ] - [ %p ]  %m%n

下面展示 测试类。

Test类

package com.baizhi.test;

import com.baizhi.dao.IPatientDao;
import com.baizhi.entity.Patient;
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 java.io.IOException;
import java.io.InputStream;
import java.util.List;

/**
 *psvm快捷方式创建main函数
 */
public class Test {
    public static void main(String[] args) throws IOException {
        //读取配置文件
        InputStream in = Resources.getResourceAsStream("Mybatis-config.xml");
        //创建sqlSessionFactory工厂
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        SqlSessionFactory factory = builder.build(in);//接口不可以实例化对象，因此需要用sqlSessionBuilder来实例化一个builder对象,通过builder对象调用build方法把in传进去
        //使用工厂生产一个sqlSession对象
        SqlSession session = factory.openSession();
        //使用sqlSession创建Dao接口的代理对象
        IPatientDao patientDao = session.getMapper(IPatientDao.class);
        //使用代理对象执行方法
        List<Patient> patients = patientDao.findAll();
        for(Patient patient : patients){
            System.out.println(patient);
        }
        //释放资源
        session.close();
        in.close();
    }
}

目录结构如下：

控制台输出：

JDBC基础