初识Mybatis
来源:互联网 发布:淘宝访客其他来源 编辑:程序博客网 时间:2024/06/05 11:00
新建maven项目,在pom.xml导入mybatis jar包 和mysql jar包
mybatis jar包
mysql jar包
在resources建大配置
<?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"><!--根节点,xml只能有一个--><configuration> <properties resource="jdbc.properties"> </properties> <!--别名--><typeAliases> <!-- <typeAlias type="cn.bdqn.entity.Studentinfo" alias="Studentinfo"></typeAlias>--><package name="cn.bdqn.entity"></package></typeAliases> <!--一个environments有N个environments--> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"></transactionManager> <dataSource type="POOLED"> <property name="driver" value="${jdbc.driver}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value=""/> </dataSource> </environment> </environments> <mappers> <mapper resource="cn/bdqn/dao/IStudentDao.xml"></mapper> </mappers></configuration>
DAO下建小配置
<?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="cn.bdqn.dao.IStudentDao"> <select id="getAll" resultType="Studentinfo">SELECT * FROM studentinfo </select> <!--getstudentByid--> <select id="getstudentByid" resultType="Studentinfo"> SELECT * FROM studentinfo WHERE stuid=#{stuId} </select> <insert id="insert"> INSERT INTO studentinfo(stuName,stuAge) values(#{stuName},#{stuAge}) </insert> <!--//修改--> <update id="upd"> UPDATE studentinfo SET stuName=#{stuName}, stuAge=#{stuAge} where stuId=#{stuId} </update> <!--删除--> <delete id="del"> DELETE FROM studentinfo WHERE stuid=#{studentId} </delete></mapper>
工具类mybatisutil
public class MyBatisUtil { private static SqlSessionFactory Factory; private static String path= "Mybatis-config.xml"; public SqlSession getsql(){ try { InputStream is= Resources.getResourceAsStream(path); Factory= new SqlSessionFactoryBuilder().build(is); } catch (IOException e) { e.printStackTrace(); } return Factory.openSession(); }}
测试类
@Testpublic void TestAll(){ String path= "Mybatis-config.xml"; try { InputStream is= Resources.getResourceAsStream(path); SqlSessionFactory factory= new SqlSessionFactoryBuilder().build(is); SqlSession session=factory.openSession(); List<Studentinfo> list = session.selectList("getAll"); for (Studentinfo item: list) { System.out.println(item.getStuName()); } session.close(); } catch (IOException e) { e.printStackTrace(); }}
阅读全文
1 0
- 初识mybatis
- 初识Mybatis
- 初识MyBatis
- 初识MyBatis
- 初识Mybatis
- 初识mybatis
- Mybatis初识
- Mybatis初识
- 初识MyBatis
- 初识MyBatis
- 初识MyBatis
- 初识Mybatis
- Mybatis初识
- 初识mybatis
- 初识mybatis
- MyBatis初识
- 初识MyBatis
- MyBatis初识
- 总结几种常见web攻击手段及其防御方式
- 引用变量二
- iOS之命名规范+编码规范
- JAVA学习札记01
- 牛客网---2016---小米Git
- 初识Mybatis
- jsp的四个作用域1
- mybatis上课内容
- 在Delphi中制作以浏览器为界面的程序
- CSS盒模型(margin、padding、border)
- Qt在windows下杀死进程:QProcess和系统API两种方式
- MFC对话框里利用CHtmlView加载界面(一)————加载网页
- windows 设置路由表
- Python自动操作脚本