package user;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class UserDAO {
	private Connection con;
	private PreparedStatement pstmt;
	private ResultSet rs;
	
	public UserDAO (){
		try {
			String dburl="jdbc:mysql://localhost:3306/shift";
			String dbId ="shift";
			String dbPassword = "shift";
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(dburl, dbId, dbPassword);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public int login (String userId, String userPassword) {
		String SQL = "SELECT userPassword FROM USER WHERE userId=? " ;
		try {
			pstmt = con.prepareStatement(SQL);
			pstmt.setString(1, userId);
			rs = pstmt.executeQuery();
			if (rs.next() ) {
				if(rs.getString(1).equals(userPassword))
					return 1;
				else return 0;
					
				
			}
			return -1;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return 	-2;
	}
	
	public int join(User user){
		String SQL = "INSERT INTO USER VALUES (?, ?, ?, ?, ?)";
		try {
			pstmt = con.prepareStatement(SQL);
			pstmt.setString(1, user.getUserId());
			pstmt.setString(2, user.getUserPassword());
			pstmt.setString(3, user.getUserName());
			pstmt.setString(4, user.getUserGender());
			pstmt.setString(5, user.getUserEmail());
			return pstmt.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return -1;
	}
	
	
}