如何使用MyBatis高效实现数据库的增删改查操作？

本文共计275个文字，预计阅读时间需要2分钟。

javapublic static void main(String[] args) throws Exception { String resource=mybatis.xml; InputStream inputStream=Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);}

public static void main(String[] args) throws Exception{ String resource="mybatis.xml"; InputStream inputStream=Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream); SqlSession session=sqlSessionFactory.openSession(); System.out.println(session); UserInfo info=session.selectOne("user.getUsersById",101); info.setPwd("a"); session.update("user.update",info); System.out.println(info); UserInfo info2=new UserInfo(105,"abc","123",2); session.insert("user.add",info2); session.update("user.update",info); session.delete("user.deleteById",105); // Map map=new HashMap (); // map.put("id", 104); // map.put("name", "aaa"); // map.put("pwd", "123"); // map.put("rolesid", 2); //// session.insert("user.add",map); // System.out.print(session.insert("user.selectBySql",map)); System.out.println(session.selectOne("user.getUsersById",104)); // Map map=new HashMap (); map.put("sql", "select * from userinfo"); List list=session.selectList("user.selectBySql", map); for (UserInfo userInfo : list) { System.out.println(userInfo); } session.commit(); session.close(); } } mapper.xml

select * from userinfo select * from userinfo where id=#{id} insert into userinfo values(#{id},#{name},#{pwd},#{rolesid}) delete userinfo where id=#{id} update userinfo set name=#{name},pwd=#{pwd},rolesid=#{rolesid} where id=#{id} ${sql}