istudentdaoimpl.java

ibatis + sqlserver 学生成绩管理

package dao;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;

import bean.Student;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class IStudentDAOImpl implements IStudentDAO {

	private static SqlMapClient sqlMapClient = null;

	static {
		try {
			Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
			reader.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	public void addStudent(Student student) {
		try {
			sqlMapClient.insert("insertStudent", student);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void addStudentBySequence(Student student) {
		try {
			sqlMapClient.insert("inserStudentBySequence", student);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void deleteStudentById(String id) {
		try {
			sqlMapClient.delete("deletStudentById", id);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	@SuppressWarnings("unchecked")
	public List<Student> queryAllStudent() {
		List<Student> sList = null;
		try {
			sList = sqlMapClient.queryForList("selectAllStudents");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return sList;
	}

	public Student queryAllStudentById(String sid) {
		Student student = null;
		try {
			student = (Student) sqlMapClient.queryForObject(
					"selectAllStudentById", sid);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return student;
	}

	@SuppressWarnings("unchecked")
	public List<Student> queryAllStudentByName(String name) {
		List<Student> list = null;
		try {
			list = sqlMapClient.queryForList("selectStudentByName", name);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}

	public void updateStudentById(Student student) {
		try {
			sqlMapClient.update("updateStudentById", student);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}