ss和ibatis框架，连接oracle的配置文件该怎么配

1.下载ibatis Jar包，我用的是ibatis-2.3.0.677.jar
2.添加iBatis的config配置文件
com.lubby.bean.SqlMapConfig.xml

[html] view plain copy

"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">


















3.添加实体类
com.lubby.bean.Student.java

[html] view plain copy
public class Student {
private String sid;
private String name;
private int age;

public Student() {
super();
}
public Student(String sid, String name, int age) {
super();
this.sid = sid;
this.name = name;
this.age = age;
}
public String getSid() {
return sid;
}
public void setSid(String sid) {
this.sid = sid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
@Override
public String toString() {
return "Student [sid=" + sid + ", name=" + name + ", age=" + age + "]";
}
}

4.添加实体类的Maping文件
com.lubby.bean.Student.xml

[html] view plain copy

"http://ibatis.apache.org/dtd/sql-map-2.dtd">








select * from student





select * from student where sid=#id#




5.DAO以及实现DAO

com.lubby.dao.StudentDAO.java

[java] view plain copy
public interface StudentDAO {
/**
* 获取所有学生
* @return 所有学生信息列表
*/
public List getAllStudent();
/**
* 根据学生ID查询信息
* @return 所查学生信息
*/
public Student getStudentById(String id);

}
com.lubby.daoimpl.StudentDAOImpl.java

[java] view plain copy
package com.lubby.daoimpl;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import com.lubby.bean.Student;
import com.lubby.dao.StudentDAO;

public class StudentDAOImpl implements StudentDAO {
private static SqlMapClient sqlMapClient = null;

// 读取配置文件
static {
try {
Reader reader = Resources.getResourceAsReader("com/lubby/bean/SqlMapConfig.xml");
sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close();
} catch (IOException e) {
e.printStackTrace();
}

}

@Override
public List getAllStudent() {
List list = null;
try {
list = sqlMapClient.queryForList("getAllStudent");
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}

@Override
public Student getStudentById(String id) {
Student student = null;
try {
student = (Student) sqlMapClient.queryForObject("getStudentById", id);
} catch (SQLException e) {
e.printStackTrace();
}
return student;
}

}

6.调用DAO查询

com.lubby.test.IbatisTest.java

[java] view plain copy
public class IbatisTest {
public static void main(String[] args) {
StudentDAO stuDaoImpl = new StudentDAOImpl();
List list = new ArrayList<>();

list = stuDaoImpl.getAllStudent();
for (Student stu : list) {
System.out.println(stu);
}

Student student = stuDaoImpl.getStudentById("003");
System.out.println("ID为004的学生信息：" + student);
}
}

7.结果显示

[plain] view plain copy
Student [sid=001, name=Tom, age=22]
Student [sid=002, name=Jack, age=23]
Student [sid=003, name=Tom, age=20]
Student [sid=004, name=Alice, age=18]
ID为004的学生信息：Student [sid=003, name=Tom, age=20]