editbean.java

来自「该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索」· Java 代码 · 共 56 行

package ynuBean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class EditBean {
	
	String msg="";
	public EditBean() {

	}

	public String editpassword(String oldpwd,String newpwd,String repwd,String username) 
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			// 查找用户的余额
			String query = "select * from login where username='"+username+"'";
			ResultSet rs = sqlstatement.executeQuery(query);
			
			String old="";
			while(rs.next())
			{
				old = rs.getString("password");
			}
			
			if(old.equals(oldpwd)&&newpwd.equals(repwd))
			{
				String update = "update login set password="+newpwd+"";
				sqlstatement.executeUpdate(update);
				msg="修改成功";
			}
			else if(!newpwd.equals(repwd))
			{
				msg="两次输入密码不一样";
			}
			else
			{
				msg="原始密码输入不正确";
			}
			con.close();
		} catch (SQLException e) {
			System.out.println(e.toString());		
		} catch (Exception e) {
			System.out.println(e.toString());
		}
		
		return msg;
	}
}