2020.10.12 게시판만들기 기본 : UserDao

 package dao;

import java.util.ArrayList;

import java.util.List;

import java.util.Map;

import service.UserService;

import util.JDBCUtil;

public class UserDao {

//싱글톤 패턴 

private UserDao(){} 

private static UserDao instance; 

public static UserDao getInstance(){ 

if(instance == null ) { 

instance = new UserDao(); 

}

return instance;

}

private JDBCUtil jdbc = JDBCUtil.getInstance();

public int insertUser(Map<String, Object> p){ 

String sql = "INSERT INTO TB_JDBC_USER VALUES (?, ? , ? ) "; 

List<Object> param = new ArrayList<>(); 

param.add(p.get("USER_ID")); 

param.add(p.get("PASSWORD")); 

param.add(p.get("USER_NAME")); 

return jdbc.update(sql, param);

}

public Map<String, Object> selectUser(String userId, String password) {

String sql = "SELECT USER_ID , USER_NAME " 

+ "FROM TB_JDBC_USER " 

+ "WHERE USER_ID = ? "

+ "AND PASSWORD = ? "; 

List<Object> param = new ArrayList<>(); 

param.add(userId); 

param.add(password); 

return jdbc.selectOne(sql, param);

}

}