登录方法测试

package com.hopetesting.dao;

import com.hopetesting.domain.User;
import com.hopetesting.util.JDBCUtil;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

/**
 * @author newcityman
 * @date 2019/8/31 - 23:32
 */
public class UserDao {
private JdbcTemplate temp = new JdbcTemplate(JDBCUtil.getDataSource());

 /**
 * 登录方法
 *
 * @param loginUser
 * @return
 */
 public User login(User loginUser) {

try {
 String sql = "select * from user where username=? and password=?";
 User user = temp.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class),
 loginUser.getUsername(), loginUser.getPassword());
 return user;
 } catch (Exception e) {
 e.printStackTrace();
 return null;
 }
 }
}

package com.hopetesting.test;

import com.hopetesting.dao.UserDao;
import com.hopetesting.domain.User;
import com.sun.scenario.effect.impl.sw.sse.SSEBlend_SRC_OUTPeer;
import org.junit.Test;

/**
 * @author newcityman
 * @date 2019/9/1 - 0:10
 */
public class UserDaoTest {
@Test
 public void testLogin(){
 User loginUser= new User();
 loginUser.setUsername("light");
 loginUser.setPassword("123");

 UserDao ud = new UserDao();
 User user = ud.login(loginUser);
 System.out.println(user);
 }
}

转载于:https://www.cnblogs.com/newcityboy/p/11441178.html