本人使用MYSQL数据库做为测试例子 ,香港服务器,香港虚拟主机,因为本例子简单,故没有将生成表的代码贴上
环境配置
1. 导入ibatis-2.3.4.726.jar mysql-connector-java-5.1.6-bin.jar
导入配置文件SqlMapConfig.xml
“1.0” encoding=”UTF-8″?>
“http://ibatis.apache.org/dtd/sql-map-config-2.dtd”>
“com/itcast/SqlMap.properties”/>
“JDBC”>
“SIMPLE”>
“${driver}” name=”JDBC.Driver”/>
“${url}” name=”JDBC.ConnectionURL”/>
“${username}” name=”JDBC.Username”/>
“${password}” name=”JDBC.Password”/>
“com/it/Note.xml”/>
SqlMap.properties
driver=com.mysql.jdbc.Driver
username=root
password=admin
Student.xml
“1.0” encoding=”UTF-8″?>
“http://ibatis.apache.org/dtd/sql-map-2.dtd”>
“Note” type=”com.it.Student”/>
“selectAllNote” resultClass=” Note”>
select *
from student
2. 建立对应表-类文件
3.package com.it;
4.
5.import java.sql.Date;
6.//Author:meetweb@sohu.com
7.public class Note {
8.private int sid=0;
9.private String sname=null;
10.private String major=null;
11.private Date birth=null;
12. }
执行文件
package com.it;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;
import com.ibatis.sqlmap.client.SqlMapClient;
public class IStudentDAOImpl implements IStudentDao {
private staticSqlMapClient sqlMapClinet=null;
static {
Reader reader;
try {
reader = com.ibatis.common.resources.Resources.getResourceAsReader(“com/it/SqlMapConfig.xml”);
sqlMapClinet=com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close();
} catch (IOException e) {
自己变得跟水晶一般透明,