systemusermoddao.java

来自「用JAVA环境开发的人力资源管理系统」· Java 代码 · 共 14 行

package com.liyu.dao;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

public class SystemUserModDao extends JdbcDaoSupport{
	
	public static final String MOD_USERINFO_SQL ="UPDATE USER_INFO SET USER_NAME =?,USER_PASSWORD=?,USER_ROLE=? WHERE USER_NAME =? AND USER_PASSWORD=? AND USER_ROLE=?";
	
	public int updUserInfo(String USER_NAME,String USER_PASSWORD,String USER_ROLE,String USER_NAME1,String USER_PASSWORD1,String USER_ROLE1){
		return this.getJdbcTemplate().update
		(MOD_USERINFO_SQL,new Object[]{USER_NAME,USER_PASSWORD,USER_ROLE,USER_NAME1,USER_PASSWORD1,USER_ROLE1});
	}
}