hintsdao.java

来自「基于J2EE的办公自动化系统。实现流程定义流程办理等。运用了hibernate+」· Java 代码 · 共 42 行

package com.oa.module.hints;

import java.util.Map;

import org.springframework.jdbc.core.JdbcTemplate;

public class HintsDAO {
	
	private JdbcTemplate jdbcTemplate;
	
	public Map getHintsByUserId(String uno) {
		String sql = "select * from thints t where uno ="+uno;
		try {
			Map map = this.jdbcTemplate.queryForMap(sql);
			return map;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}

	public boolean updateHints(HintForm hintForm) {
		String sql = "update thints set hshowtype=?, haffair=?, hmeeting=?, hemail=?, hshowtime=? where uno=?";
		try {
			this.jdbcTemplate.update(sql,new Object[]{hintForm.getHshowtype(),hintForm.getHaffair(),hintForm.getHmeeting(),
									hintForm.getHemail(),hintForm.getHshowtime(),hintForm.getUno()});
			return true;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return false;
	}
	
	public JdbcTemplate getJdbcTemplate() {
		return jdbcTemplate;
	}

	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
}