文章目录提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档
- 什么是maven
- maven的配置
- 如何使用mybatis.
- 使用mybatis完成crud
什么是maven
Maven项目对象模型(POM),可以通过一小段描述信息来管理项目的构建,报告和文档的项目管理工具软件。
maven可以通过一段描述,帮你构建项目并且可以帮你引入相关的依赖jar
一、maven的配置
1)配置环境变量:
选择计算机右键--->属性---->高级----->环境变量
选择新建
MAVEN_HOME: maven的解压路径
path:%MAVEN_HOME%lbin
校验maven是否配置成功:cmd-------mvn -version
如何使用mybatis.1)引入mybatis和mysql的jar包
4.0.0 org.example mybatis021.0-SNAPSHOT org.mybatis mybatis3.4.6 mysql mysql-connector-java8.0.28 org.projectlombok lombok1.18.24 junit junit4.12 test log4j log4j1.2.17
2) 创建mybatis的配置文件
3) 创建实体类
package com.zsb.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private int id;
private String name;
private String age;
}
4) 创建mybatis和数据库的映射文件
5)注册映射文件
使用mybatis完成crud
1.pom.xml
4.0.0 org.example mybatis021.0-SNAPSHOT org.mybatis mybatis3.4.6 mysql mysql-connector-java8.0.28 org.projectlombok lombok1.18.24 junit junit4.12 test log4j log4j1.2.17
2.mybatis.xml
3.User
package com.zsb.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private int id;
private String name;
private String age;
}
4.UserMapper.xml
insert into users(name,age) values (#{name},#{age}) delete from users where id=#{id} update users set name=#{name},age=#{age} where id=#{id}
5.Test
package com.zsb.test;
import com.zsb.dao.UserDao;
import com.zsb.entity.User;
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.Test;
import java.io.Reader;
import java.util.List;
public class Test02 {
//查询所有
@Test
public void testFindAll() throws Exception{
Reader reader = Resources.getResourceAsReader("mybatis.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = factory.openSession();
UserDao userDao = session.getMapper(UserDao.class);
List list = userDao.findAll();
System.out.println(list);
session.commit();
session.close();
}
//修改
@Test
public void testUpdate() throws Exception{
Reader reader = Resources.getResourceAsReader("mybatis.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = factory.openSession();
UserDao userDao = session.getMapper(UserDao.class);
User user = new User(6,"张三丰","66");
userDao.update(user);
System.out.println(user);
session.commit();
session.close();
}
//删除
@Test
public void testDelete() throws Exception{
Reader reader = Resources.getResourceAsReader("mybatis.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = factory.openSession();
UserDao userDao = session.getMapper(UserDao.class);
userDao.delete(10);
session.commit();
session.close();
}
//添加
@Test
public void testAdd() throws Exception{
Reader reader = Resources.getResourceAsReader("mybatis.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = factory.openSession();
UserDao userDao = session.getMapper(UserDao.class);
User user = new User();
user.setName("五十");
user.setAge("19");
System.out.println("前"+user);
userDao.add(user);
System.out.println("后"+user);
session.commit();
session.close();
}
}



