Mybitas配置

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">第一次写博客不好的地方还请大家指点</span>

首先创建一个java项目名字自定义结构如下

导入jar包

创建数据库

不想手动创建的话也可以将下面的sql脚本保存成*.sql文件还原到数据库中例如mybitas.sql

/*
SQLyog Ultimate v11.27 (32 bit)
MySQL - 5.6.29 : Database - mybitas
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`mybitas` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `mybitas`;

/*Table structure for table `student` */

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  `sex` varchar(2) DEFAULT NULL,
  `age` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `student` */

LOCK TABLES `student` WRITE;

insert  into `student`(`id`,`name`,`sex`,`age`) values (1,'小明','男',12),(2,'小红','女',13);

UNLOCK TABLES;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

准备工作完成！

现在开始~~~

mappings里面存放的都是xml映射文件为了目录结构看着更加清晰在mappings下面创建的文件夹

与com下面的文件夹是一一对应的。

编写sys-dao-StudentDao

package com.sys.dao;

import com.sys.entity.Student;

public interface StudentDao {

	public Student queryById(int id);
	public Student queryByName(String name);
	public void insert(Student student);
	public void update(Student student);
	public void delete(int id);
}

编写sys-entity-Student

package com.sys.entity;

public class Student {
	
	//学生 id
	private int id;
	//姓名
	private String name;
	//性别
	private String sex;
	//年龄
	private int age;
	
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	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 int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	@Override
	public String toString() {
		return "Student [id=" + id + ", name=" + name + ", sex=" + sex
				+ ", age=" + age + "]";
	}
	
	
	
	
}

编写sys-service-StudentService

package com.sys.service;

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;

import com.sys.dao.StudentDao;
import com.sys.entity.Student;

public class StudentService {

	public StudentService() {

	}

	private static SqlSessionFactory sqlSessionFactory;
	private static Reader reader;
	//private StudentDao studentDao;

	static {
		try {
			reader = Resources.getResourceAsReader("com/mybitas_config.xml");
			sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public static SqlSessionFactory getSession() {
		return sqlSessionFactory;
	}

	/**
	 * 按ID查询
	 * 
	 * @param id
	 * @return
	 */
	public Student queryById(int id) {
		SqlSession session = sqlSessionFactory.openSession();
		Student student = null;
		StudentDao studentDao = session.getMapper(StudentDao.class);
		
		student = studentDao.queryById(id);
		session.close();
		System.out.println("查询完毕");
		return student;
	}
	
	/**
	 * 按名称查找
	 * 
	 * @param id
	 * @return
	 */
	public Student queryByName(String name) {
		SqlSession session = sqlSessionFactory.openSession();
		Student student = null;
		StudentDao studentDao = session.getMapper(StudentDao.class);
		
		student = studentDao.queryByName(name);
		session.close();
		System.out.println("查询完毕");
		return student;
	}
	

	/**
	 * 添加
	 * 
	 * @param student
	 * @return
	 */
	public void insert(Student student) {
		SqlSession session = sqlSessionFactory.openSession();
		StudentDao studentDao = session.getMapper(StudentDao.class);
		studentDao.insert(student);
		session.commit();
		session.close();
		System.out.println("添加完毕");
	}

	/**
	 * 更新
	 * 
	 * @param student
	 * @return
	 */
	public void update(Student student) {
		SqlSession session = sqlSessionFactory.openSession();
		StudentDao studentDao = session.getMapper(StudentDao.class);
		studentDao.update(student);
		session.commit();
		session.close();
		System.out.println("更新完毕");
	}

	/**
	 * 删除
	 * 
	 * @param id
	 * @return
	 */
	public void delete(int id) {
		SqlSession session = sqlSessionFactory.openSession();
		StudentDao studentDao = session.getMapper(StudentDao.class);
		studentDao.delete(id);
		session.commit();
		session.close();
		System.out.println("删除完毕");
	}

}

编写sys-web-StudentController

package com.sys.web;

import com.sys.entity.Student;
import com.sys.service.StudentService;

public class StudentController {
	
	public static void main(String[] args) {
		
		StudentService studentService = new StudentService();
		//查询
		Student student = new Student();
		student = studentService.queryById(1);
		System.out.println(student);
		
		//添加
//		Student student = new Student();
//		student.setName("大仙");
//		student.setSex("男");
//		student.setAge(22);
//		studentService.insert(student);
//		System.out.println(studentService.queryByName("大仙"));
		
		//修改
//		Student student = new Student();
//		student = studentService.queryById(1);
//		System.out.println(student);
//		student.setAge(40);
//		studentService.update(student);
//		student = studentService.queryById(1);
//		System.out.println(student);
		
		//删除
//		Student student = new Student();
//		student = studentService.queryByName("大仙");
//		System.out.println(student);
//		studentService.delete(3);
//		student = studentService.queryByName("大仙");
//		System.out.println(student);
		
		
		
	}
	
}

创建mappings-sys-StudentMapping.xml

然后将dao与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.sys.dao.StudentDao">
	
	<select id="queryById" parameterType="int" resultType="Student">
		SELECT * FROM student
		WHERE id=#{id}
	</select>
	
	<select id="queryByName" parameterType="String" resultType="Student">
		SELECT * FROM student
		WHERE name=#{name}
	</select>
	
	
	<insert id="insert" parameterType="Student">
		INSERT INTO student(
			name, 
			sex, 
			age
		) VALUES (
			#{name}, 
			#{sex}, 
			#{age}
		)
	</insert>
	
	<update id="update" parameterType="Student">
		UPDATE student SET 
		name = #{name}, 
		sex = #{sex},
		age = #{age}
		WHERE id = #{id}
	
	</update>
	
	<delete id="delete" parameterType="int">
		DELETE * FROM student 
		WHERE id = #{id}
	</delete>
	

</mapper>

到此已经完成了一大部分了

咱们继续

创建jdbc.properties和mybitas_config.xml

jdbc.properties

#jdbc Driver
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybitas?useUnicode=true&characterEncoding=utf-8
username=root
password=root

mybitas_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">

<configuration>
	<properties resource="com/jdbc.properties"></properties>
	
	<typeAliases> 
        <typeAlias alias="Student" type="com.sys.entity.Student"/> 
    </typeAliases> 
	
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="${driver}" />
				<property name="url" value="${url}" />
				<property name="username" value="${username}" />
				<property name="password" value="${password}" />
			</dataSource>
		</environment>
	</environments>

	<mappers>
		<mapper resource="com/mappings/sys/StudentMapping.xml" />
	</mappers>

</configuration> 

然后运行StudentController
测试一下

大功告成