e.printStackTrace();
System.out.println("读取Mybatils.xml文件失败");
}
SqlSession session = factory.openSession();
Student s = new Student();
s.setName("小张");
s.setAge(26);
s.setBirthday(new Date());
s.setMoney(5100.0);
try{
session.insert("org.leadfar.Student.insert",s);
session.commit();
}catch(Exception e){
e.printStackTrace();
session.rollback();
}
finally{
session.close();
}
}
public void testupdate() {
SqlSessionFactory factory = null;
Reader reader = null;
try {
reader = Resources.getResourceAsReader("Mybatils.xml");
factory =new SqlSessionFactoryBuilder().build(reader);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("读取Mybatils.xml文件失败");
}
SqlSession session = factory.openSession();
Student s = new Student();
s.setId(1);
s.setName("小sa");
s.setAge(23);
s.setBirthday(new Date());
s.setMoney(6100.20);
try{
session.insert("org.leadfar.Student.update",s);
}catch(Exception e){
e.printStackTrace();
session.rollback();
}
finally{
session.close();
}
}
public void testdelete() {
SqlSessionFactory factory = null;
Reader reader = null;
try {
reader = Resources.getResourceAsReader("Mybatils.xml");
factory =new SqlSessionFactoryBuilder().build(reader);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("读取Mybatils.xml文件失败");
}
SqlSession session = factory.openSession();
Student s = new Student();
s.setId(2);
try{
session.insert("org.leadfar.Student.delete",s);
session.commit();
}catch(Exception e){
e.printStackTrace();
session.rollback();
}
finally{
session.close();
}
}
public void testselectone() {
SqlSession session = factory.openSession(true);
//Student p=(Student)session.selectOne("org.leadfar.Student.selectone",1);
Student p=(Student)session.selectOne(Student.class.getName()+".selectone", 1);
System.out.println(p);
}
}