实验4 Mybatis基础代码

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 javax.imageio.IIOException; import java.io.IOException; import java.io.InputStream; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Scanner; public class MyBatisTest { public static void main(String[] args) throws Exception{ //插入操作,通过测试方法运行不了，只能通过主方法 insertTest(); } //插入操作 public static void insertTest() throws IOException { Car car = new Car(); //while循环，然后控制台手动输入数据，不然代码冗余 Scanner sc = new Scanner(System.in); while (true){ System.out.println("请选择操作选项：1.添加汽车属性，2.退出"); String str = sc.next(); if (str.equals("2")) { System.out.println("退出成功！"); break; }else if (str.equals("1")) { System.out.println("请输入汽车属性!"); System.out.println("请输入车牌号："); String carNumber = sc.next(); System.out.println("请输入品牌："); String brand = sc.next(); System.out.println("请输入车主名："); String owner = sc.next(); String purchaseDate = null; while (true){ System.out.println("请输入购置日期(ep:2013-04-17)："); purchaseDate = sc.next(); SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); try { Date date = format.parse(purchaseDate); break; } catch (ParseException e) { System.out.println("不合法的输入，请重新输入！"); e.printStackTrace(); } } System.out.println("请输入车主电话："); String telephone = sc.next(); car.setCarNumber(carNumber); car.setBrand(brand); car.setOwner(owner); car.setPurchaseDate(purchaseDate); car.setTelephone(telephone); }else { System.out.println("输入错误,请重新输入！"); continue; } //获取核心配置文件 InputStream in = Resources.getResourceAsStream("mybatis-config.xml"); //获取session工厂对象 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); //获取session回话对象 SqlSession sqlSession = sqlSessionFactory.openSession(true);//有参数true，下面就不需要手动提交事务了 //执行操作 参数：namespace + id sqlSession.insert("carMapper.add", car); //mybatis执行更新操作，提交事务 //sqlSession.commit(); //释放资源 sqlSession.close(); } } @Test public void selectCarNumberTest() throws IOException{ //获取核心配置文件 InputStream in = Resources.getResourceAsStream("mybatis-config.xml"); //获取session工厂对象 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); //获取session回话对象 SqlSession sqlSession = sqlSessionFactory.openSession(); //执行操作 参数：namespace + id Car car = sqlSession.selectOne("carMapper.findByCarNumber", "1"); //打印数据 System.out.println(car); //释放资源 sqlSession.close(); } @Test public void selectOwnerNameTest() throws IOException{ //获取核心配置文件 InputStream in = Resources.getResourceAsStream("mybatis-config.xml"); //获取session工厂对象 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); //获取session回话对象 SqlSession sqlSession = sqlSessionFactory.openSession(); //执行操作 参数：namespace + id Car car = sqlSession.selectOne("carMapper.findByOwnerName", "张%"); //打印数据 System.out.println(car); //释放资源 sqlSession.close(); } @Test public void updateTelephone() throws IOException{ //模拟car对象 Car car = new Car(); car.setTelephone("12345678910"); car.setOwner("张三"); //获取核心配置文件 InputStream in = Resources.getResourceAsStream("mybatis-config.xml"); //获取session工厂对象 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); //获取session回话对象 SqlSession sqlSession = sqlSessionFactory.openSession(); //执行操作 参数：namespace + id sqlSession.update("carMapper.update", car); //mybatis执行更新操作，提交事务 sqlSession.commit(); //释放资源 sqlSession.close(); } @Test public void delete() throws IOException{ //获取核心配置文件 InputStream in = Resources.getResourceAsStream("mybatis-config.xml"); //获取session工厂对象 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); //获取session回话对象 SqlSession sqlSession = sqlSessionFactory.openSession(); //执行操作 参数：namespace + id sqlSession.delete("carMapper.delete", "3"); //mybatis执行更新操作，提交事务 sqlSession.commit(); //释放资源 sqlSession.close(); } }