/*****************************/
package com.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import com.DAO.PatientDAO;
import com.IDAO.IPatientDAO;
import com.domain.UserSignup;

import com.repo.usersigninRepository;

@RestController
@RequestMapping("/user")
public class usersigninController {

	@Autowired
	private usersigninRepository patientDAO;
	@RequestMapping("/login")
	 @ResponseBody
	 public UserSignup findByName(@RequestParam("username") String username,@RequestParam("password") String password){
		 	return patientDAO.find(username,password);
	 }

}

/***********************/
package com.repo;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import com.domain.UserSignup;

@Repository
public interface usersigninRepository extends JpaRepository<UserSignup, Integer> {

	//UserSignup findById(int userid);

	@Query("SELECT p FROM UserSignup p WHERE p.username = :username AND p.password = :password")
    public UserSignup find(@Param("username") String username,@Param("password") String password);

}