ibatis
瀛︿範绗旇
1
銆?/p>
鎼缓鐜锛?/p>
锛?/p>
1
锛?/p>
銆佸垱寤?/p>
ibatis_test
椤圭洰銆?/p>
锛?/p>
2
锛?/p>
銆佹坊鍔?/p>
SQL2000
椹卞姩鍖?/p>
msbase.jar
銆?/p>
mssqlserver.jar
銆?/p>
msutil.jar
鍜?/p>
ibatis-2.3.3.720.jar
鍖呫�?/p>
2
銆侀厤缃枃浠讹細
锛?/p>
1
锛?/p>
銆?/p>
JDBC
杩炴帴灞炴�ф枃浠讹細鍦?/p>
src
鐩綍涓嬫坊鍔?/p>
SqlMap.properties
灞炴�ф枃浠讹紝涓昏鍖呮嫭
JDBC
杩?
鎺ョ殑涓昏淇℃伅锛?/p>
driver=
锛?/p>
url=
锛?/p>
username=
锛?/p>
password=,
涔熷彲浠ヨ
JDBC
杩炴帴鐨?/p>
淇℃伅鐩存帴鍐欏埌鎬婚厤缃枃浠朵腑銆?/p>
锛?/p>
2
锛?/p>
銆侀厤缃瘡涓疄浣撶殑鏄犲皠鏂囦欢锛?/p>
map
鏂囦欢锛?/p>
锛?/p>
濡?/p>
Student.xml
鏂囦欢锛屽叾涓昏鏄寘鎷瀹炰綋杩涜
CURD
鎿嶄綔鐨?/p>
SQL
璇彞鐨勬槧灏勩�?/p>
锛?/p>
3
锛?/p>
銆佹坊鍔犳�婚厤缃枃浠讹細
锛堝弬瑙?/p>
SqlMapConfig.xml
鏂囦欢锛?/p>
鍏朵富瑕佸姛鑳芥槸瀵煎叆
SqlMap.properties
鍜?/p>
Student.xml
鏂囦欢锛岃繘琛岀粺涓�绠＄悊
3
銆佸垱寤虹浉搴旂殑绫伙細
锛?/p>
1
锛?/p>
銆佸缓绔嬪疄浣撶被
Student.java
绫汇�?/p>
锛?/p>
2
锛?/p>
銆佸缓绔嬬鐞嗙被鎺ュ彛
StudentDao
锛屽拰瀹炵幇绫?/p>
StudentDaoImpl
4
銆佹祴璇?/p>
CRUD
鎿嶄綔锛?/p>
锛?/p>
1
锛夈�佸湪
StudentDaoImpl
绫讳腑娣诲姞璇诲彇閰嶇疆
锛?/p>
2
锛?/p>
銆佹祴璇曟煡璇㈡墍鏈変俊鎭殑鏂规硶
queryAllStudent
锛堬級锛屽湪
Student.xml
鏂囦欢涓厤缃?/p>
SQL
璇彞鏄犲皠淇℃伅銆備緥濡傦細
<
鈥?/p>
--
鏌ユ壘鎵�鏈夌敤鎴?/p>
-->
<
select
id
=
"selectAllStudents"
resultClass
=
"Student"
>
select * from t_student;
</
select
>
鍦?/p>
queryAllStudent
锛堬級鏂规硶涓娇鐢?/p>
sqlMapClient
鐨?/p>
queryForList
锛堬級鏂规硶杩涜璋冪敤锛?/p>
public
List<Student> queryAllStudent() {
List<Student> studntList =
null
;
try
{
studntList=
sqlMapClient
.queryForList(
"selectAllStudents"
);
}
catch
(SQLException e) {