資源簡介
這是一個用mybatis框架連接oracle數據庫的例子,可在eclipse上運行,需要在oral建test表包涵(id,age,username,password)字段,
代碼片段和文件信息
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();
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????477??2011-06-24?16:56??oracle\.classpath
?????文件????????382??2011-06-24?14:50??oracle\.project
?????文件????????629??2011-06-24?14:50??oracle\.settings\org.eclipse.jdt.core.prefs
?????文件????????723??2011-06-24?18:19??oracle\bin\org\mybatis\test\config.xm
?????文件???????3044??2011-06-27?16:20??oracle\bin\org\mybatis\test\getTest.class
?????文件????????825??2011-06-27?16:34??oracle\bin\org\mybatis\test\Main.class
?????文件???????1099??2011-06-27?15:37??oracle\bin\org\mybatis\test\test.class
?????文件????????933??2011-06-27?18:26??oracle\bin\org\mybatis\test\testmapper.xm
?????文件???????1135??2011-06-27?11:02??oracle\bin\org\mybatis\test\util.class
?????文件????????723??2011-06-24?18:19??oracle\src\org\mybatis\test\config.xm
?????文件???????2036??2011-06-27?16:20??oracle\src\org\mybatis\test\getTest.java
?????文件????????502??2011-06-27?16:34??oracle\src\org\mybatis\test\Main.java
?????文件????????667??2011-06-27?15:37??oracle\src\org\mybatis\test\test.java
?????文件????????933??2011-06-27?18:26??oracle\src\org\mybatis\test\testmapper.xm
?????文件????????695??2011-06-23?15:23??oracle\src\org\mybatis\test\util.java
?????目錄??????????0??2011-06-28?10:16??oracle\bin\org\mybatis\test
?????目錄??????????0??2011-06-28?10:16??oracle\src\org\mybatis\test
?????目錄??????????0??2011-06-28?10:16??oracle\bin\org\mybatis
?????目錄??????????0??2011-06-28?10:16??oracle\src\org\mybatis
?????目錄??????????0??2011-06-28?10:16??oracle\bin\org
?????目錄??????????0??2011-06-28?10:16??oracle\src\org
?????目錄??????????0??2011-06-28?10:16??oracle\.settings
?????目錄??????????0??2011-06-28?10:16??oracle\bin
?????目錄??????????0??2011-06-28?10:16??oracle\src
?????目錄??????????0??2011-06-28?10:16??oracle
-----------?---------??----------?-----??----
????????????????14803????????????????????25
- 上一篇:連續hopfield神經網絡解決TSP問題
- 下一篇:壓力球罐設計
評論
共有 條評論