iBatis_学习笔记.doc

iBatis学习笔记Author:meetwebmail:[e-mail]
PAGE\*MERGEFORMAT14

环境配置
导入ibatis-2.3.4.726.jarmysql-connector-java-5.1.6-bin.jar
导入配置文件SqlMapConfig.xml
<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEsqlMapConfigPUBLIC"-//ibatis.apache.org//DTDSQLMapConfig2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
<propertiesresource="com/itcast/SqlMap.properties"/>

<transactionManagertype="JDBC">
<dataSourcetype="SIMPLE">
<propertyvalue="${driver}"name="JDBC.Driver"/>
<propertyvalue="${url}"name="JDBC.ConnectionURL"/>
<propertyvalue="${username}"name="JDBC.Username"/>
<propertyvalue="${password}"name="JDBC.Password"/>
</dataSource>
</transactionManager>

<sqlMapresource="com/it/Note.xml"/>
</sqlMapConfig>

SqlMap.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1/test
username=root
password=admin

Student.xml
<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEsqlMapPUBLIC"-//ibatis.apache.org//DTDSQLMap2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap>
<typeAliasalias="Note"type="com.it.Student"/>

<selectid="selectAllNote”resultClass="Note">
select*
fromstudent
</select>
</sqlMap>

建立对应表-类文件
packagecom.it;

importjava.sql.Date;

publicclassNote{
privateintsid=0;
privateStringsname=null;
privateStringmajor=null;
privateDatebirth=null;
}

执行文件

packagecom.it;

importjava.io.IOException;
importjava.io.Reader;
importjava.sql.SQLException;
importjava.util.List;

importcom.ibatis.sqlmap.client.SqlMapClient;

publicclassIStudentDAOImplimplementsIStudentDao{

privatestaticSqlMapClientsqlMapClinet=null;
static{
Readerreader;
try{

reader=com.ibatis.common.resources.Resources.getResourceAsReader("com/it/SqlMapConfig.xml");
sqlMapClinet=com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close();
}catch(IOExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}

publicList<Note>queryAllN(){
//TODOAuto-generatedmethodstub
List<Note>studentList=null;