modifypwddao.java

来自「C语言小型分析器实验报告1） 待分析的简化C语言的词法说明； 2） 单词符号的」· Java 代码 · 共 31 行

package dao;

import java.sql.SQLException;

public class ModifyPwdDao {
	private String account;
	private String oldpwd;
	private String newpwd;
	private BasicDao dao;
	
	public ModifyPwdDao(String account, String oldpwd, String newpwd){
		this.account = account;
		this.oldpwd = oldpwd;
		this.newpwd = newpwd;
		dao = new BasicDao();
	}
	
	public int modifyPwd(){
		String sql = "update user set password='" + newpwd + "' where account='" + account + "' and password='" + oldpwd + "'";
		int result = 0;
		try {
			result = dao.executeString(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			dao.closeAll();
		}
		return result;
	}
}