accountdao.java

用户可以添加商品

package product.db;
import java.sql.*;
import java.util.*;

public class AccountDAO{

	Connection con; //数据库连接	
	String signon = "SELECT * FROM Account1 WHERE uid=? AND pw=?";
	String updatePw = "UPDATE Account1 SET pw=? WHERE uid=? AND pw=?";
	
	public AccountDAO(){}
	
	public boolean signon(String uid,String pw){
		boolean validate = false;
		try{
			con = DatabaseConnection.getConnection();
			PreparedStatement pstmt = con.prepareStatement(signon);
			pstmt.setString(1,uid);
			pstmt.setString(2,pw);
			ResultSet rst=pstmt.executeQuery();
			if(rst.next()){
				validate=true;
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try{
				if(con!=null)
				con.close();
			}catch(Exception e2){}
		}
		return validate;
	}
	
	public void updatePw(String uid,String oldPw,String newPw){
		try{
			con = DatabaseConnection.getConnection();
			PreparedStatement pstmt = con.prepareStatement(updatePw);
			pstmt.setString(1,newPw);
			pstmt.setString(2,uid);
			pstmt.setString(3,oldPw);
			pstmt.executeUpdate();
		}catch(Exception e){
		}finally{
			try{
				if(con!=null)
				con.close();
			}catch(Exception e2){}
		}
	}
	
}