package com.java.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.java.model.Admin;

public class AdminDao {

	public static Admin login(Connection con,Admin admin)throws Exception{
		Admin resultUser=null;
		//数据库查询语句
		String sql="select * from admin where username=? and password=?";
		//创建pstmt
		PreparedStatement pstmt=con.prepareStatement(sql);
		//给第一个问号赋值
		pstmt.setString(1,admin.getUsername());
		//给第二个问号赋值
		pstmt.setString(2,admin.getPassword());
		//执行查询语句
		ResultSet rs=pstmt.executeQuery();
		//判断有没有下一条记录
		if(rs.next()){
			resultUser=new Admin();
			resultUser.setUsername(rs.getString("username"));
			resultUser.setPassword(rs.getString("password"));
		}
		return resultUser;
	}
}