www.pudn.com > BeiJie.rar > UserModifyOperation.java

package operation; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.Date; 
 
import dataBase.DataBase; 
import entity.OrderListCheck; 
 
public class UserModifyOperation 
{ 
	private ResultSet rs = null; 
 
	private ArrayList list = null; 
 
	private String sql = ""; 
 
	private DataBase db = null; 
 
	public UserModifyOperation() 
	{ 
		db = new DataBase(); 
	} 
 
	public String PasswordModify(String CustomerID, String oldpassword, 
			String newpassword) 
	{ 
		sql = "select * from employeeinfo where EmployeeName = '" + CustomerID+ "' and Password = '" + oldpassword + "'"; 
		System.out.println(sql); 
		try 
		{ 
			rs = db.getResult(sql); 
			while (rs.next()) 
			{ 
				String sql1="update employeeinfo set Password='"+newpassword+"' where EmployeeName = '" + CustomerID+ "' and Password = '" + oldpassword + "'"; 
				System.out.println(sql1); 
				db.ExeQuery(sql1); 
				return "ÃÜÂëÒѾ­ÐÞ¸Ä"; 
			} 
			rs.close(); 
			db.close();// 
 
		} catch (SQLException e) 
		{ 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
			System.out.println("customerpasswordmodify ´íÎó"); 
		} 
		return "ÃÜÂëÐÞ¸Ä**´íÎó"; 
	} 
 
}