mybatis连接oracle实例

package org.mybatis.test; import org.mybatis.test.util; import org.mybatis.test.test; import org.apache.ibatis.session.SqlSession; public class getTest { public test getvalue(int id) { SqlSession session = util.getSqlSessionFactory().openSession(); //session.s test ts = null; try { ts = (test) session.selectOne("testmapper.selectbyid", id);// 为第三步中配置文件中的select } catch (Exception e) { e.printStackTrace(); } finally { session.commit(); session.close(); } return ts; } public void insertvalue(int id, int age, String username, String password) { SqlSession session = util.getSqlSessionFactory().openSession(); test ts = new test(); ts.SetID(id); ts.SetUserName(username); ts.SetPassWord(password); ts.SetAge(age); try { session.insert("testmapper.insertvalues", ts);// 为第三步中配置文件中的insert // id } catch (Exception e) { e.printStackTrace(); } finally { session.commit(); session.close(); } } public void updatevalue(int id, String username) { SqlSession session = util.getSqlSessionFactory().openSession(); test ts = new test(); ts.SetID(id); ts.SetUserName(username); try { session.update("testmapper.updatevalue", ts);// 为第三步中配置文件中的update // id } catch (Exception e) { e.printStackTrace(); } finally { session.commit(); session.close(); } } public void deletesomthing(int id) { SqlSession session = util.getSqlSessionFactory().openSession(); try { session.delete("testmapper.deletesomthing", id); } catch (Exception e) { e.printStackTrace(); } finally { session.commit(); session.close(); } } public void xmltest(int id) { SqlSession session = util.getSqlSessionFactory().openSession(); try { session.selectOne("testmapper.gettest", 1); } catch (Exception e) { e.printStackTrace(); } finally { session.commit(); session.close(); } } }