基于maven的springmvc+mybatis+jqury的框架搭建附数据库脚本

package com.mybatis.test; import java.io.Reader; import java.util.List; 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 com.mybatis.dao.UserMapper; import com.mybatis.model.Article; import com.mybatis.model.User; public class Test { private static SqlSessionFactory sqlSessionFactory; private static Reader reader; static { try { reader = Resources.getResourceAsReader("Configuration.xml"); sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader); } catch (Exception e) { e.printStackTrace(); } } public static SqlSessionFactory getSession() { return sqlSessionFactory; } public User getUser(int id){ SqlSession session = sqlSessionFactory.openSession(); UserMapper userOperation=session.getMapper(UserMapper.class); User user = userOperation.selectUserByID(id); return user; } /** * 测试获取用户列表 */ public void getUserList(){ SqlSession session = sqlSessionFactory.openSession(); try { UserMapper userOperation=session.getMapper(UserMapper.class); List<User> userList = userOperation.selectUsers("summer"); for(User u : userList){ System.out.println(u.getId()+"|"+u.getUserName()+"|"+u.getUserAge()+"|"+u.getUserAddress()); } } finally { session.close(); } } public void insertUser(){ SqlSession session = sqlSessionFactory.openSession(); try { UserMapper userOperation =session.getMapper(UserMapper.class); User user = new User(); user.setUserName("long"); user.setUserAge("12"); user.setUserAddress("hangzhou"); userOperation.addUser(user); session.commit(); System.out.println("当前插入的用户的主键id为："+user.getId()); } finally{ session.close(); } } public void updateUser(){ SqlSession session = sqlSessionFactory.openSession(); try { UserMapper userOperation = session.getMapper(UserMapper.class); User user = this.getUser(5); user.setUserAge("101"); user.setUserName("longwang"); user.setUserAddress("原来是魔都的浦东创新园区"); userOperation.updateUser(user); session.commit(); } finally { session.close(); } } public void deleterUser(int id){ SqlSession session = sqlSessionFactory.openSession(); try { UserMapper userOperation = session.getMapper(UserMapper.class); userOperation.deleteUser(id); session.commit(); } finally { session.close(); } } public void selectUserArticle(int userid){ SqlSession session = sqlSessionFactory.openSession(); try { UserMapper userOperation = session.getMapper(UserMapper.class); List<Article> artcles = userOperation.getUserArticles(userid); for(Article article:artcles){ System.out.println("书籍"+article.getTitle()+":"+article.getContent()+":作者是:"+ article.getUser().getUserName()+"的地址是:"+article.getUser().getUserAddress()); } System.out.println(); } finally { session.close(); } } public static void main(String[] args) { Test t = new Test(); t.selectUserArticle(1); } }