operatorbean.java

购物系统~含其他会员下载一次您上载的源码

package com.beans;

import java.sql.*;

import com.utils.DBConnection;

public class OperatorBean {

	public static boolean isRegister(RegisterBean bean){
		Connection con=null;
		PreparedStatement stm=null;
		try{
			con=DBConnection.getConnection();
			stm=con.prepareStatement("insert into regInfo values(?,?,?,?,?,?,?)");
			stm.setString(1,bean.getLogin());
			stm.setString(2,bean.getPass());
			stm.setString(3,bean.getName());
			String sex=null;
			if(bean.getSex().equals("1"))
				sex="男";
			else
				sex="女";
			stm.setString(4,sex);
			stm.setString(5,bean.getAge());
			stm.setString(6,bean.getPhone());
			stm.setString(7,bean.getEmail());
			stm.execute();
			System.out.println("注册成功！");
			con.close();
			return true;
		}
		catch(SQLException sqle){
			sqle.printStackTrace();
		}
		finally{
			try{
				stm.close();
				con.close();
			}
			catch(Exception e){
				e.printStackTrace();
			}
		}
		return false;
	}
	
	public static boolean isLogin(LoginBean bean){
		Connection con=null;
		PreparedStatement stm=null;
		boolean isSuccess=false;
		try{
			con=DBConnection.getConnection();
			stm=con.prepareStatement("select * from reginfo where login=? and pass=?");
			stm.setString(1,bean.getUsername());
			stm.setString(2,bean.getPassword());
			ResultSet rs=stm.executeQuery();
			if(rs.next()){
				System.out.println("登陆成功！");
				isSuccess=true;
			}
			else
				System.out.println("登陆失败！");
			return isSuccess;
		}
		catch(SQLException sqle){
			sqle.printStackTrace();
		}
		finally{
			try{
				stm.close();
				con.close();
			}
			catch(Exception e){
				e.printStackTrace();
			}
		}
		return false;
	}
	
	
}