1.加入mybatis的jar包
2.orm:操作数据库(crud->连接)
2.1编写配置文件mybatis.xml放到src下面
2.1.1配置JDBC的数据源
<?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>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url"
value="jdbc:mysql://localhost/jingteng?useUnicode=true&characterEncoding=utf-8" />
<property name="username" value="root" />
<property name="password" value="jingteng" />
</dataSource>
</environment>
</environments>
2.2.2加入映射文件地址,相当于配置接口类UserMapper
<mappers>
<mapper resource="domain/Userinfo.xml" />
</mappers>
</configuration>
3.配置UserMapper.xml文件 (主要做添加修改删除查询)
<mapper namespace="接口地址">
<insert id="接口方法名" parameterType="接口参数类型一般是javabean,类的全称" resultType="返回值">
insert into userinfo(id,username,userage,useraddress)
values(#{任意名字},#{任意名字},#{任意名字},#{任意名字})
</insert>
</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 namespace="dao.UserinfoDao">
<insert id="saveUserinfo" parameterType="domain.Userinfo" >
insert into userinfo(userid,userpwd,userage)
values(#{userid},#{userpwd},#{userage})
</insert>
</mapper>
------------------------------------------
4.添加,修改,删除,按主键查询,查询所有:
UserinfoMapper.java:
package mapper;
import java.util.List;
import domain.Userinfo;
public interface UserinfoMapper {
//添加
public void saveUserinfo(Userinfo userinfo);
//修改
public void updateUserinfo(Userinfo userinfo);
//删除
public void deleteUserinfo(String userid);
//按住键查询
public Userinfo getUserinfo(String userid);
//查询集合
public List<Userinfo> getUserinfos();
}
---------------------------------------------
UserinfoMapper.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="mapper.UserinfoMapper">
<!-- 添加 -->
<insert id="saveUserinfo" parameterType="Userinfo">
insert into userinfo(userid,userpwd,userage)
values(#{userid},#{userpwd},#{userage})
</insert>
<!-- 修改 -->
<update id="updateUserinfo" parameterType="Userinfo">
update userinfo set userpwd = #{userpwd},userage = #{userage}
where userid = #{userid}
</update>
<!-- 删除 -->
<delete id="deleteUserinfo" parameterType="String">
delete from userinfo where userid = #{userid}
</delete>
<!-- 按住键查询 -->
<select id="getUserinfo" parameterType="Userinfo" resultType="Userinfo">
select * from userinfo where userid =#{userid}
</select>
<!-- 查询所有 -->
<resultMap type="Userinfo" id="userinfoList">
<id property="userid" column="userid"/>
<result property="userpwd" column="userpwd"/>
<result property="userage" column="userage"/>
</resultMap>
<select id="getUserinfos" resultMap="userinfoList">
select * from userinfo
</select>
</mapper>
--------------------------------------------------------------------------
测试 Test.java:
package test;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
import mapper.UserinfoMapper;
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 domain.Userinfo;
public class Test {
public static void main(String[] args) throws IOException {
Reader reader = Resources.getResourceAsReader("mybatis.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sqlSessionFactory.openSession();
//添加
Userinfo userinfo = new Userinfo();
userinfo.setUserid("9");
userinfo.setUserpwd("9999");
userinfo.setUserage(2799);
//实例化mapper类
UserinfoMapper mapper = session.getMapper(UserinfoMapper.class);
//mapper.saveUserinfo(userinfo);//添加
//mapper.updateUserinfo(userinfo);//修改
//mapper.deleteUserinfo("9");//删除
//按主键查询
// Userinfo u2 = mapper.getUserinfo("888");
// System.out.println(u2.getUserage());
//
//查询所有
List<Userinfo> userinfos = mapper.getUserinfos();
System.out.println(userinfos.size());
session.commit();
}
}
2.orm:操作数据库(crud->连接)
2.1编写配置文件mybatis.xml放到src下面
2.1.1配置JDBC的数据源
<?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>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url"
value="jdbc:mysql://localhost/jingteng?useUnicode=true&characterEncoding=utf-8" />
<property name="username" value="root" />
<property name="password" value="jingteng" />
</dataSource>
</environment>
</environments>
2.2.2加入映射文件地址,相当于配置接口类UserMapper
<mappers>
<mapper resource="domain/Userinfo.xml" />
</mappers>
</configuration>
3.配置UserMapper.xml文件 (主要做添加修改删除查询)
<mapper namespace="接口地址">
<insert id="接口方法名" parameterType="接口参数类型一般是javabean,类的全称" resultType="返回值">
insert into userinfo(id,username,userage,useraddress)
values(#{任意名字},#{任意名字},#{任意名字},#{任意名字})
</insert>
</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 namespace="dao.UserinfoDao">
<insert id="saveUserinfo" parameterType="domain.Userinfo" >
insert into userinfo(userid,userpwd,userage)
values(#{userid},#{userpwd},#{userage})
</insert>
</mapper>
------------------------------------------
4.添加,修改,删除,按主键查询,查询所有:
UserinfoMapper.java:
package mapper;
import java.util.List;
import domain.Userinfo;
public interface UserinfoMapper {
//添加
public void saveUserinfo(Userinfo userinfo);
//修改
public void updateUserinfo(Userinfo userinfo);
//删除
public void deleteUserinfo(String userid);
//按住键查询
public Userinfo getUserinfo(String userid);
//查询集合
public List<Userinfo> getUserinfos();
}
---------------------------------------------
UserinfoMapper.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="mapper.UserinfoMapper">
<!-- 添加 -->
<insert id="saveUserinfo" parameterType="Userinfo">
insert into userinfo(userid,userpwd,userage)
values(#{userid},#{userpwd},#{userage})
</insert>
<!-- 修改 -->
<update id="updateUserinfo" parameterType="Userinfo">
update userinfo set userpwd = #{userpwd},userage = #{userage}
where userid = #{userid}
</update>
<!-- 删除 -->
<delete id="deleteUserinfo" parameterType="String">
delete from userinfo where userid = #{userid}
</delete>
<!-- 按住键查询 -->
<select id="getUserinfo" parameterType="Userinfo" resultType="Userinfo">
select * from userinfo where userid =#{userid}
</select>
<!-- 查询所有 -->
<resultMap type="Userinfo" id="userinfoList">
<id property="userid" column="userid"/>
<result property="userpwd" column="userpwd"/>
<result property="userage" column="userage"/>
</resultMap>
<select id="getUserinfos" resultMap="userinfoList">
select * from userinfo
</select>
</mapper>
--------------------------------------------------------------------------
测试 Test.java:
package test;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
import mapper.UserinfoMapper;
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 domain.Userinfo;
public class Test {
public static void main(String[] args) throws IOException {
Reader reader = Resources.getResourceAsReader("mybatis.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sqlSessionFactory.openSession();
//添加
Userinfo userinfo = new Userinfo();
userinfo.setUserid("9");
userinfo.setUserpwd("9999");
userinfo.setUserage(2799);
//实例化mapper类
UserinfoMapper mapper = session.getMapper(UserinfoMapper.class);
//mapper.saveUserinfo(userinfo);//添加
//mapper.updateUserinfo(userinfo);//修改
//mapper.deleteUserinfo("9");//删除
//按主键查询
// Userinfo u2 = mapper.getUserinfo("888");
// System.out.println(u2.getUserage());
//
//查询所有
List<Userinfo> userinfos = mapper.getUserinfos();
System.out.println(userinfos.size());
session.commit();
}
}