public static SqlSession getSqlSession() throws IOException{
SqlSession sqlSession;
//获取配置的资源文件
Reader reader= Resources.getResourceAsReader("mybatis.xml");
SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(reader);
//sqlsession就能够执行配置文件的sql语句
sqlSession= factory.openSession();
return sqlSession;
}
mybatis-XML文件配置:
<configuration>
<!-- 注册对象的空间命名 -->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<!-- 1.加载数据库驱动 -->
<property name="driver" value="com.mysql.jdbc.Driver"/>
<!-- 2.数据库连接地址 -->
<property name="url" value="jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=utf8"/>
<!-- 数据库用户... -->
<property name="username" value="root"/>
<!-- 数据库密码... -->
<property name="password" value="12345678"/>
</dataSource>
</environment>
</environments>
<!-- 注册映射文件:java对象与数据库之间的xml文件路径! -->
<mappers>
<mapper resource="mapper/SqlMapper.xml"/>
</mappers>
</configuration>
mapper的xml文件配置:
<mapper namespace="com.course">
<select id="getUserCount" resultType="Integer">
select count(*) from student;
</select>
<insert id="addUser" parameterType="controller.User">
insert into user(userName,password) values(#{userName},#{password})
</insert>
<update id="updateUser" parameterType="controller.User">
update student set name=#{name} where id=#{id};
</update>
<delete id="deleteUser" parameterType="Integer">
delete from student where id=#{id}
</delete>
</mapper>