<Resource name="jdbc/itemfarm" auth="Container" type="javax.sql.DataSource"
maxTotal="100" maxIdle="30" maxWaitMillis="10000"
username="itemfarm" password="1234" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://IP주소:3306/itemfarm"/>
<!-- 변경 전 -->
<td>${company.company_status == "Y" ? "활성" : "비활성"}</td>
<!-- 변경 후 -->
<td>${company.company_status == "Y".charAt(0) ? "활성" : "비활성"}</td>
<a href="#" data-companyid="${company.company_id}"> </a>
commonCSS.jsp, commonJS.jsp
footer.jsp, nav.jsp, footer.jsp, commonBtn.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<%@ include file="../common/commonCSS.jsp" %>
<title>Insert title here</title>
</head>
<body>
<div id="wrapper">
<%@ include file="../common/nav.jsp" %>
<div id="content-wrapper" class="d-flex flex-column">
<div id="content">
<%@ include file="../common/header.jsp" %>
<div class="container-fluid">
<h1>내용</h1>
</div>
</div>
<%@ include file="../common/footer.jsp" %>
</div>
</div>
<%@ include file="../common/commonBtn.jsp" %>
<%@ include file="../common/commonJS.jsp" %>
</body>
</html>
주소창을 읽어 폴더 포함 여부에 따라 클래스를 추가한다.
var myFolder = "/" + $(location).attr("pathname").split("/")[1];
$(".nav-item").each(function (idx, item) {
var path1 = $(this).find("a").attr("href");
var path2 = $(this).find("div:last").find("a").attr("href");
if(myFolder == "/") {
$(this).removeClass("active");
}
else if(path1.includes(myFolder)) {
$(this).addClass("active");
}
else if(path2 != undefined && path2.includes(myFolder)) {
$(this).addClass("active");
$(this).find("a").removeClass("collapsed");
$(this).find("a").attr("aria-expanded", true);
$(this).find("div").addClass("show");
}
else{
$(this).removeClass("active");
}
});
사이트에 등록된 전체 기업을 조회한다.
// CompanyDAO.java
String sql = "select * from company order by company_id";
// CompanyListController.java
CompanyService service = new CompanyService();
List<CompanyVO> companyList = service.companyList();
request.setAttribute("companyList", companyList);
return "/company/company_list.jsp";
<!-- company_list.jsp -->
<tbody>
<c:forEach items="${companyList}" var="company">
<tr class="companyRow">
<td>${company.company_id}</td>
<td>${company.company_name}</td>
<td>${company.company_commission}%</td>
<td>${company.company_status == "Y".charAt(0) ? "활성" : "비활성"}</td>
</tr>
<%@ include file="company_modify.jsp" %>
</c:forEach>
</tbody>