mybatis所用的加包
核心文件:
1.jdbc.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://localhost\:3306/liaocheng2019
jdbc.username=root
jdbc.password=root
2.log4j.properties
# Global logging configuration,建议开发环境中要用debug
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
下面配置mapper
<?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的 但是后期会有其他作用-->
<mapper namespace="test">
//查询全部
<select id="findAll" resultType="pojo.User">
select * from day1018
</select>
//按照id查询
<select id="findById" resultType="pojo.User" parameterType="int">
select * from day1018 where id=#{id} </select>
//模糊查询
<select id="findName" resultType="pojo.User" parameterType="String">
select * from day1018 where username like #{nameuser} </select>
//删除
<delete id="delById" parameterType="int">
delete from day1018 where id=#{id} </delete>
//更新 <update id="updel" parameterType="pojo.User">
update day1018 set username=#{username} where id=#{id}
</update>
//添加并且返回Id
<insert id="tianjia" parameterType="pojo.User">
<selectKey keyProperty="id" resultType="int" order="AFTER">
SELECT LAST_INSERT_ID()
</selectKey>
insert into day1018 set username=#{username},password=#{password} </insert>
//count
<select id="count" resultType="int">
select count(*) from day1018
</select></mapper>
属性名称讲解:id:唯一的,在调用时使用
resultType:返回类型
parameterType:所需类型
再写接口方法,接口方法必须要和xml中id的名字一样