iuserdaoimpl.java

ibatis + sqlserver 学生成绩管理

package dao;

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

import bean.User;

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

public class IUserDAOImpl implements IUserDAO {

	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 addUser(User User) {
		try {
			sqlMapClient.insert("insertUser", User);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void addUserBySequence(User User) {
		try {
			sqlMapClient.insert("inserUserBySequence", User);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

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