목록JSP (284)
WON.dev
package org.joonzis.service; import java.util.List; import java.util.Map; import org.joonzis.vo.EmployeeVO; public interface EmployeeService { public List getALL(); public List getOne(int department_id);//dept public List gettwo(Map map); }
SELECT * FROM EMPLOYEES ORDER BY EMPLOYEE_ID SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = #{department_id} SELECT * FROM EMPLOYEES where employee_id = #{value} first_name = #{value} DEPARTMENT_ID = #{value}
package org.joonzis.mybatis.config; import java.io.InputStream; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; public class DBService {// factory를 만드는게 목적 // 필드 private static SqlSessionFactory factory = null; // 싱글톤 static { try { String resource = "org/joonzis/mybatis/config/sqlmap.xml"; Inpu..
package org.joonzis.dao; import java.util.List; import java.util.Map; import org.apache.ibatis.session.SqlSession; import org.joonzis.mybatis.config.DBService; import org.joonzis.vo.EmployeeVO; public class EmployeeDaoImpl implements EmployeeDao { //DAO 객체 생성 private static EmployeeDaoImpl instace = null; public EmployeeDaoImpl() {} public static EmployeeDaoImpl GetInstance() { if(instace == nul..
package org.joonzis.dao; import java.util.List; import java.util.Map; import org.joonzis.vo.EmployeeVO; public interface EmployeeDao { public List getALLEmployees(); public List search_dept(int department_id); public List getList(Map map); }
package org.joonzis.controller; import java.io.IOException; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.joonzis.service.EmployeeService; import o..
${result }
안녕 Hello