eclipse + mybits 操作mysql数据库

package com.zong.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 org.apache.ibatis.session.SqlSessionFactory; import com.zong.model.Person; import com.zong.dao.*; 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 void getOne() { SqlSession session = sqlSessionFactory.openSession(); try { IPersonDao person=session.getMapper(IPersonDao.class); //IPersonDao Person user = person.selectUserByID(1); System.out.println(user.getAddress()); System.out.println(user.getName()); } finally { session.close(); } } public void getUserList(String userName) { SqlSession session = sqlSessionFactory.openSession(); try { IPersonDao userOperation=session.getMapper(IPersonDao.class); List<Person> users = userOperation.selectUsers(userName); for(Person user:users) { System.out.println(user.getId()+":"+user.getName()+":"+user.getAddress()); } } finally { session.close(); } } public void add() { Person user=new Person(); user.setAddress("人民广场"); user.setName("飞鸟"); user.setAge("80"); SqlSession session = sqlSessionFactory.openSession(); try { IPersonDao userOperation=session.getMapper(IPersonDao.class); userOperation.add(user); session.commit(); System.out.println("当前增加的用户 id为:"+user.getId()); } finally { session.close(); } } public void update() { //先得到用户,然后修改，提交。 SqlSession session = sqlSessionFactory.openSession(); try { IPersonDao person=session.getMapper(IPersonDao.class); Person user = person.selectUserByID(4); user.setAddress("原来是魔都的浦东创新园区"); person.update(user); session.commit(); } finally { session.close(); } } public void delete(int id) { SqlSession session = sqlSessionFactory.openSession(); try { IPersonDao userOperation=session.getMapper(IPersonDao.class); userOperation.delete(id); session.commit(); } finally { session.close(); } } public static void main(String[] args) { Test t = new Test(); //t.getOne(); //t. getUserList("a"); //t.add(); //t.update(); t.delete(3); } }