01_2_查询所有的对象
1. 实体类
package entity;
import java.util.Date;
public class Student {
private int sid = 0;
private String name = null;
private String major = null;
private Date birth = null;
private float score = 0;
public int getSid() {
return sid;
}
public void setSid(int sid) {
this.sid = sid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getMajor() {
return major;
}
public void setMajor(String major) {
this.major = major;
}
public Date getBirth() {
return birth;
}
public void setBirth(Date birth) {
this.birth = birth;
}
public float getScore() {
return score;
}
public void setScore(float score) {
this.score = score;
}
public String toString(){
return "[sid:" + sid + ", name:" + name + ", major:" + major + ", birth:" + birth + ", score:" + score +"]";
}
}
2. DAO接口
package dao;
import java.util.List;
import entity.Student;
public interface IStudentDAO {
public void addStudent(Student student);
public void addStudentBySequence(Student student);
public void deleteStudentById(int id);
public void updateStudentById(int id);
public List<Student> queryAllStudent();
public List<Student> queryStudentByName(String name);
public Student queryStudentById(int id);
}
3. 实现类
package dao.impl;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import dao.IStudentDAO;
import entity.Student;
public class IStudentDAOImpl implements IStudentDAO {
private static SqlMapClient sqlMapClient = null;
static {
try {
//将配置文件读入到字符流
Reader reader = Resources.getResourceAsReader("config/SqlMapConfig.xml");
//创建SqlMapClient对象
sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
//关闭字符流
reader.close();
} catch (IOException e) {
e.printStackTrace();
}
}
public void addStudent(Student student) {
// TODO Auto-generated method stub
}
public void addStudentBySequence(Student student) {
// TODO Auto-generated method stub
}
public void deleteStudentById(int id) {
// TODO Auto-generated method stub
}
public void updateStudentById(int id) {
// TODO Auto-generated method stub
}
public List<Student> queryAllStudent() {
List<Student> studentList = null;
try {
studentList = sqlMapClient.queryForList("selectAllStudent");
} catch (SQLException e) {
e.printStackTrace();
}
return studentList;
}
public List<Student> queryStudentByName(String name) {
// TODO Auto-generated method stub
return null;
}
public Student queryStudentById(int id) {
// TODO Auto-generated method stub
return null;
}
/**
* @param args
*/
public static void main(String[] args) {
IStudentDAO dao = new IStudentDAOImpl();
for(Student student : dao.queryAllStudent()) {
System.out.println(student);
}
}
}
4. 运行结果展示
[sid:1, name:李明, major:语文, birth:Tue Mar 27 00:00:00 CST 2018, score:100.0]
[sid:2, name:可可, major:英语, birth:Mon Mar 12 00:00:00 CST 2018, score:120.0]
[sid:3, name:天天, major:数学, birth:Thu Mar 22 00:00:00 CST 2018, score:80.0]