Notice
Recent Posts
Recent Comments
| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 | 31 |
Tags
- nodejs express
- docker
- node.js web framework
- iBatis
- flex3
- 나의 취미
- 디즈니씨
- ror실행
- 명사 분석기
- Node.js
- 스킨 스쿠버
- 베트남어
- rss
- ajax
- 주식이야기
- 나의 프로젝트
- 명사 추출기
- 도커
- Lift
- php
- Eclipse
- php thumbnail
- scala
- 명사 뽑아내기
- 메일왕창보내는법
- ejb
- Cross
- 책이야기
- C/C++
- express for node.js
Archives
- Today
- Total
nkdk의 세상
10장 사원 및 고객 등록 본문
한번에 모두 올립니다.
package jikwon;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Buser extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select buser_name from sawon left outer join buser on buser_num = buser_no order by buser_name");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("<html><body><center>");
out.println("<h2>***부서 인원***</h2>");
out.println("<table border=0 width=30%>");
out.println("<tr bgcolor=yellow>");
out.println("<td>부서이름</td><td>인원수</td></tr>");
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
String bname = "";
while(rs.next()){
if (!bname.equals(rs.getString("buser_name"))) {
if(!bname.equals("")) {
out.println("<tr><td>"+bname +"</td><td>"+ count+"명</td></tr>");
}
bname = rs.getString("buser_name");
count = 0;
}
count += 1;
}
out.println("</table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
package jikwon;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JikwonDel extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=euc-kr");
request.setCharacterEncoding("euc-kr");
PrintWriter out = response.getWriter();
String no = request.getParameter("no");
out.println("<html><body><center><p>");
out.println("<h2>" + no + "번 자료를 정말 삭제할까요?</h2>");
out.println("<form method=post action=/sertest/JikwonDelOk>");
out.println("<input type=hidden name=code value=" +no+">");
out.println("<input type=submit value=삭제>");
out.println("<input type=button value=취소 onClick=history.back()>");
out.println("</form></center></body></html>");
}
}
package jikwon;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JikwonDelOk extends HttpServlet {
Connection conn;
PreparedStatement pstmt;
public void init() throws ServletException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("delete from sawon where sawon_no=?");
} catch (Exception e) {
System.out.println("연결실패:"+e);
return;
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String code=request.getParameter("code");
System.out.println(code);
try {
pstmt.setString(1, code);
pstmt.executeUpdate();
} catch (Exception e) {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("해당 사원은 고객을 가지고 있습니다.<br>고객 삭제 후 사원을 삭제해 주세요.<br><a href=/sertest/servlet/jikwon.JikwonList>돌아가기</a>");
return;
}
response.sendRedirect("/sertest/servlet/jikwon.JikwonList"); // 바로 보내는거, 상품리스트를 바로 부른다.
}
public void destroy() {
try {
pstmt.close();
conn.close();
} catch (Exception e) {
}
}
}
package jikwon;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class JikwonGogek extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select * from sawon left outer join gogek on sawon_no = gogek_damsano where sawon_no = ? order by sawon_no");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
String no = request.getParameter("no");
System.out.println(no);
try {
pstmt.setString(1, no);
} catch (Exception e) {
System.out.println("입력 오류 : " + e);
return;
}
out.println("<html><body><center>");
out.println("<h2>*** 고객 목록***</h2>");
out.println("<table border=0 width=80%>");
out.println("<tr bgcolor=yellow>");
out.println("<th>고객번호</th><th>고객이름</th><th>고객전번</th>");
out.println("<th>고객주민번호</th><th>담당사원이름</th></tr>");
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
while(rs.next()){
String g_no = rs.getString("gogek_no");
if(g_no.equals(null)) {
continue;
}
String g_name = rs.getString("gogek_name");
String g_tel = rs.getString("gogek_tel");
String g_jumin = rs.getString("gogek_jumin");
String g_saname = rs.getString("sawon_name");
out.println("<tr align=center>");
out.println("<td><a href=/sertest/GogekDel?no=" + g_no + ">" + g_no + "</a></td>");
out.println("<td>" + g_name + "</td>");
out.println("<td>" + g_tel + "</td>");
out.println("<td>" + g_jumin + "</td>");
out.println("<td>" + g_saname + "</td></tr>");
count += 1;
}
out.println("<tr><td colspan=5><b>전체 건수 : " +
count + "</b></td></tr></table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("<hr width=70%>" + "<font color=red size=2>" + "자료 삭제 시 고객번호를 클릭</font>");
out.println("<br><font color=blue size=2>" + "고객명을 클릭하면 관리 고객 출력</font>");
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
package jikwon;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class JikwonInsert extends HttpServlet {
Connection conn;
PreparedStatement pstmt;
public void init() throws ServletException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("insert into sawon(sawon_name, buser_num, sawon_jik, sawon_pay, sawon_ibsail, sawon_sex) values(?,?,?,?,?,?)");
} catch (Exception e) {
System.out.println("연결실패:"+e);
return;
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
String s_name = request.getParameter("jikname");
String b_num = "";
try {
String sel[] = request.getParameterValues("buser");
for(int i = 0; i < sel.length; i++)
b_num = sel[i];
} catch (Exception e) {
return;
}
String s_jik = "";
try {
String sel[] = request.getParameterValues("jik");
for(int i = 0; i < sel.length; i++)
s_jik = sel[i];
} catch (Exception e) {
return;
}
String s_pay = request.getParameter("pay");
String s_ibsail = request.getParameter("ibsail");
String s_sex = "";
try {
String sel[] = request.getParameterValues("sex");
for(int i = 0; i < sel.length; i++)
s_sex = sel[i];
} catch (Exception e) {
return;
}
try {
pstmt.setString(1, s_name);
pstmt.setString(2, b_num);
pstmt.setString(3, s_jik);
pstmt.setString(4, s_pay);
pstmt.setString(5, s_ibsail);
pstmt.setString(6, s_sex);
pstmt.executeUpdate();
} catch (Exception e) {
System.out.println("입력 오류 : " + e);
return;
}
response.sendRedirect("/sertest/servlet/jikwon.JikwonList");
}
public void destroy() {
try {
pstmt.close();
conn.close();
} catch (Exception e) {
}
}
}
package jikwon;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class JikwonList extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select sawon_no,sawon_name,buser_name,sawon_jik,sawon_ibsail,sawon_sex from sawon left outer join buser on buser_num = buser_no");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("<html><body><center>");
out.println("<h2>***직원 목록***</h2>");
out.println("<table border=0 width=80%>");
out.println("<tr bgcolor=yellow>");
out.println("<th>사번</th><th>이름</th>");
out.println("<th>부서</th><th>직급</thㄱ>");
out.println("<th>입사일</th><th>성별</th></tr>");
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
while(rs.next()){
String no = rs.getString("sawon_no");
String name = rs.getString("sawon_name");
String buser = rs.getString("buser_name");
String jik = rs.getString("sawon_jik");
String ibsail = rs.getString("sawon_ibsail").substring(0,10);
String sex = rs.getString("sawon_sex");
out.println("<tr align=center>");
out.println("<td><a href=/sertest/JikwonDel?no=" + no + ">" + no + "</a></td>");
out.println("<td><a href=/sertest/JikwonGogek?no=" + no + " target=_blank>" + name + "</td>");
out.println("<td>" + buser + "</td>");
out.println("<td>" + jik + "</td>");
out.println("<td>" + ibsail + "</td>");
out.println("<td>" + sex + "</td></tr>");
count += 1;
}
out.println("<tr><td colspan=5><b>전체 건수 : " +
count + "</b></td></tr></table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("<hr width=70%>" + "<font color=red size=2>" + "자료 삭제 시 사원번호를 클릭</font>");
out.println("<br><font color=blue size=2>" + "직원명을 클릭하면 관리 고객 출력</font>");
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class GogekDel extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=euc-kr");
request.setCharacterEncoding("euc-kr");
PrintWriter out = response.getWriter();
String no = request.getParameter("no");
out.println("<html><body><center><p>");
out.println("<h2>" + no + "번 자료를 정말 삭제할까요?</h2>");
out.println("<form method=post action=/sertest/JikwonDelOk>");
out.println("<input type=hidden name=code value=" +no+">");
out.println("<input type=submit value=삭제>");
out.println("<input type=button value=취소 onClick=history.back()>");
out.println("</form></center></body></html>");
}
}
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class GogekDelOk extends HttpServlet {
Connection conn;
PreparedStatement pstmt;
public void init() throws ServletException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("delete from gogek where gogek_no=?");
} catch (Exception e) {
System.out.println("연결실패:"+e);
return;
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String code=request.getParameter("code");
System.out.println(code);
try {
pstmt.setString(1, code);
pstmt.executeUpdate();
} catch (Exception e) {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("삭제되지 않았습니다.<a href=/sertest/servlet/jikwon.JikwonList>돌아가기</a>");
return;
}
response.sendRedirect("/sertest/servlet/jikwon.JikwonList"); // 바로 보내는거, 상품리스트를 바로 부른다.
}
public void destroy() {
try {
pstmt.close();
conn.close();
} catch (Exception e) {
}
}
}
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class GogekIns extends HttpServlet {
Connection conn;
PreparedStatement pstmt;
public void init() throws ServletException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("insert into gogek(gogek_name, gogek_tel, gogek_jumin, gogek_damsano) values(?,?,?,?)");
} catch (Exception e) {
System.out.println("연결실패:"+e);
return;
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
String g_name = request.getParameter("g_name");
String g_tel = request.getParameter("g_tel");
String g_jumin = request.getParameter("g_jumin");
String g_damsano = request.getParameter("g_damsano");
try {
pstmt.setString(1, g_name);
pstmt.setString(2, g_tel);
pstmt.setString(3, g_jumin);
pstmt.setString(4, g_damsano);
pstmt.executeUpdate();
} catch (Exception e) {
System.out.println("입력 오류 : " + e);
return;
}
response.sendRedirect("/sertest/GogekList");
}
public void destroy() {
try {
pstmt.close();
conn.close();
} catch (Exception e) {
}
}
}
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.*;
public class GogekList2 extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select * from gogek left outer join sawon on sawon_no = gogek_damsano order by gogek_no");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("<html><body><center>");
out.println("<h2>*** 40대 미만 고객 목록***</h2>");
out.println("<table border=0 width=80%>");
out.println("<tr bgcolor=yellow>");
out.println("<th>고객번호</th><th>고객이름</th><th>고객전번</th>");
out.println("<th>고객주민번호</th><th>담당사원이름</th></tr>");
Calendar calendar = new GregorianCalendar();
int year = calendar.get(calendar.YEAR);
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
while(rs.next()){
String g_no = rs.getString("gogek_no");
String g_name = rs.getString("gogek_name");
String g_tel = rs.getString("gogek_tel");
String g_jumin = rs.getString("gogek_jumin");
System.out.println(Integer.parseInt(g_jumin.substring(0, 2)));
if((year - 1900 - (Integer.parseInt(g_jumin.substring(0, 2)))) > 40) {
continue;
}
String g_saname = rs.getString("sawon_name");
out.println("<tr align=center>");
out.println("<td><a href=/sertest/GogekDel?no=" + g_no + ">" + g_no + "</a></td>");
out.println("<td><a href=/sertest/GogekSawon?no=" + g_no + ">" +g_name + "</td>");
out.println("<td>" + g_tel + "</td>");
out.println("<td>" + g_jumin + "</td>");
out.println("<td>" + g_saname + "</td></tr>");
count += 1;
}
out.println("<tr><td colspan=5><b>전체 건수 : " +
count + "</b></td></tr></table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("<hr width=70%>" + "<font color=red size=2>" + "자료 삭제 시 고객번호를 클릭</font>");
out.println("<br><font color=blue size=2>" + "고객명을 클릭하면 관리 고객 출력</font>");
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class GogekList extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select * from gogek left outer join sawon on sawon_no = gogek_damsano order by gogek_no");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("<html><body><center>");
out.println("<h2>***고객 목록***</h2>");
out.println("<table border=0 width=80%>");
out.println("<tr bgcolor=yellow>");
out.println("<th>고객번호</th><th>고객이름</th><th>고객전번</th>");
out.println("<th>고객주민번호</th>><th>담당사원이름</th></tr>");
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
while(rs.next()){
String g_no = rs.getString("gogek_no");
String g_name = rs.getString("gogek_name");
String g_tel = rs.getString("gogek_tel");
String g_jumin = rs.getString("gogek_jumin");
String g_saname = rs.getString("sawon_name");
out.println("<tr align=center>");
out.println("<td><a href=/sertest/GogekDel?no=" + g_no + ">" + g_no + "</a></td>");
out.println("<td><a href=/sertest/GogekSawon?no=" + g_no + " target=_blank>" +g_name + "</td>");
out.println("<td>" + g_tel + "</td>");
out.println("<td>" + g_jumin + "</td>");
out.println("<td>" + g_saname + "</td></tr>");
count += 1;
}
out.println("<tr><td colspan=5><b>전체 건수 : " +
count + "</b></td></tr></table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("<hr width=70%>" + "<font color=red size=2>" + "자료 삭제 시 고객번호를 클릭</font>");
out.println("<br><font color=blue size=2>" + "고객명을 클릭하면 관리 고객 출력</font>");
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class GogekSawon extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select * from sawon, buser, gogek where sawon_no = gogek_damsano and buser_num = buser_no and gogek_no = ?");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
String no = request.getParameter("no");
System.out.println(no);
try {
pstmt.setString(1, no);
} catch (Exception e) {
System.out.println("입력 오류 : " + e);
return;
}
out.println("<html><body><center>");
out.println("<h2>*** 담당사원내역***</h2>");
out.println("<table border=0 width=80%>");
out.println("<tr bgcolor=yellow>");
out.println("<th>사원번호</th><th>사원이름</th><th>부서이름</th>");
out.println("<th>사원직급</th><th>사원성별</th></tr>");
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
while(rs.next()){
String g_no = rs.getString("sawon_no");
String g_name = rs.getString("sawon_name");
String g_tel = rs.getString("buser_name");
String g_jumin = rs.getString("sawon_jik");
String g_saname = rs.getString("sawon_sex");
out.println("<tr align=center>");
out.println("<td><a href=/sertest/GogekDel?no=" + g_no + ">" + g_no + "</a></td>");
out.println("<td>" + g_name + "</td>");
out.println("<td>" + g_tel + "</td>");
out.println("<td>" + g_jumin + "</td>");
out.println("<td>" + g_saname + "</td></tr>");
count += 1;
}
out.println("<tr><td colspan=5><b>전체 건수 : " +
count + "</b></td></tr></table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("<hr width=70%>" + "<font color=red size=2>" + "자료 삭제 시 고객번호를 클릭</font>");
out.println("<br><font color=blue size=2>" + "고객명을 클릭하면 관리 고객 출력</font>");
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
<html><body>
<p><center>
<form method=post action=/sertest/GogekIns>
<table width=50%>
<tr>
<td width=40%>고객이름</td><td><input type=text name=g_name size=20></td>
</tr>
<tr>
<td width=40%>고객전번</td><td><input type=text name=g_tel size=20></td>
</tr>
<tr>
<td width=40%>고객주민번호</td><td><input type=text name=g_jumin size=20></td>
</tr>
<tr>
<td width=40%>담당사원번호</td><td><input type=text name=g_damsano size=20></td>
</tr>
<tr align=center>
<td colspan = 2>
<input type=submit value=" 등 록 ">
<input type=reset value="입력취소">
</td>
</tr>
</table>
</form>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<body bgcolor=cyan>
<center><br><br>
<font size=2>
★ 직원관리 ★<p>
<a href="/sertest/servlet/jikwon.JikwonList" target=main>직원 목록</a>
<p>
<a href="/sertest/servlet/jikwon.Buser" target=main>부서 인원수</a>
<p>
<a href="jikwonins.html" target=main>직원 추가</a>
<p>
-----------
<p>
♣ 고객관리 ♣<p>
<a href="/sertest/GogekList" target=main>고객 목록</a>
<p>
<a href="/sertest/GogekList2" target=main>40대미만 남성</a>
<p>
<a href="/sertest/gogekin.html" target=main>고객 추가</a>
<br><br><br><br>
<a href="/sertest/jikwon/jikmain.html" target=main>☞ 홈으로</a>
</font>
</body></html>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>상품자료</title>
</head>
<body><center><p>
<h3>--- 직원 및 고객자료 처리 ---</h3>
<img src="book.jpg">
<hr width=70%>
중앙ITEA All Right Reserved
</body>
</html>
<frameset cols="12%,*" frameborder=0 bordercolor=black>
<frame src="jiklmenu.html" name="menu"
frameborder=0 noresize>
<frame src="jikmain.html" name="main"
frameborder=0 noresize>
</frameset>
<html><body>
<p><center>
<form method=post action=/sertest/JikwonInsert>
<table width=40%>
<tr>
<td width=30%>직원이름</td><td><input type=text name=jikname size=20></td>
</tr>
<tr>
<td width=20%>부서</td><td><input type=radio name=buser value=10 checked>총무부
<input type=radio name=buser value=20>영업부<br>
<input type=radio name=buser value=30>전산부
<input type=radio name=buser value=40>관리부</td>
</tr>
<tr>
<td width=20%>직급</td>
<td><input type=radio name=jik value=사원 checked>사원
<input type=radio name=jik value=대리>대리
<input type=radio name=jik value=과장>과장 <br>
<input type=radio name=jik value=부장>부장
<input type=radio name=jik value=사장>사장 </td>
</tr>
<tr>
<td width=20%>월급</td><td><input type=text name=pay></td>
</tr>
<tr>
<td width=20%>입사일</td><td><input type=text name=ibsail><br>형식은 년-월-일 <br>예: 2007-12-10로 작성</td>
</tr>
<tr>
<td width=20%>성별</td><td><input type=radio name=sex value=남 checked>남
<input type=radio name=sex value=여>여 </td>
</tr>
<tr align=center>
<td colspan = 2>
<input type=submit value=" 등 록 ">
<input type=reset value="입력취소">
</td>
</tr>
</table>
</form>
</body>
</html>
이상입니다.
package jikwon;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Buser extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select buser_name from sawon left outer join buser on buser_num = buser_no order by buser_name");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("<html><body><center>");
out.println("<h2>***부서 인원***</h2>");
out.println("<table border=0 width=30%>");
out.println("<tr bgcolor=yellow>");
out.println("<td>부서이름</td><td>인원수</td></tr>");
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
String bname = "";
while(rs.next()){
if (!bname.equals(rs.getString("buser_name"))) {
if(!bname.equals("")) {
out.println("<tr><td>"+bname +"</td><td>"+ count+"명</td></tr>");
}
bname = rs.getString("buser_name");
count = 0;
}
count += 1;
}
out.println("</table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
package jikwon;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JikwonDel extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=euc-kr");
request.setCharacterEncoding("euc-kr");
PrintWriter out = response.getWriter();
String no = request.getParameter("no");
out.println("<html><body><center><p>");
out.println("<h2>" + no + "번 자료를 정말 삭제할까요?</h2>");
out.println("<form method=post action=/sertest/JikwonDelOk>");
out.println("<input type=hidden name=code value=" +no+">");
out.println("<input type=submit value=삭제>");
out.println("<input type=button value=취소 onClick=history.back()>");
out.println("</form></center></body></html>");
}
}
package jikwon;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JikwonDelOk extends HttpServlet {
Connection conn;
PreparedStatement pstmt;
public void init() throws ServletException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("delete from sawon where sawon_no=?");
} catch (Exception e) {
System.out.println("연결실패:"+e);
return;
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String code=request.getParameter("code");
System.out.println(code);
try {
pstmt.setString(1, code);
pstmt.executeUpdate();
} catch (Exception e) {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("해당 사원은 고객을 가지고 있습니다.<br>고객 삭제 후 사원을 삭제해 주세요.<br><a href=/sertest/servlet/jikwon.JikwonList>돌아가기</a>");
return;
}
response.sendRedirect("/sertest/servlet/jikwon.JikwonList"); // 바로 보내는거, 상품리스트를 바로 부른다.
}
public void destroy() {
try {
pstmt.close();
conn.close();
} catch (Exception e) {
}
}
}
package jikwon;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class JikwonGogek extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select * from sawon left outer join gogek on sawon_no = gogek_damsano where sawon_no = ? order by sawon_no");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
String no = request.getParameter("no");
System.out.println(no);
try {
pstmt.setString(1, no);
} catch (Exception e) {
System.out.println("입력 오류 : " + e);
return;
}
out.println("<html><body><center>");
out.println("<h2>*** 고객 목록***</h2>");
out.println("<table border=0 width=80%>");
out.println("<tr bgcolor=yellow>");
out.println("<th>고객번호</th><th>고객이름</th><th>고객전번</th>");
out.println("<th>고객주민번호</th><th>담당사원이름</th></tr>");
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
while(rs.next()){
String g_no = rs.getString("gogek_no");
if(g_no.equals(null)) {
continue;
}
String g_name = rs.getString("gogek_name");
String g_tel = rs.getString("gogek_tel");
String g_jumin = rs.getString("gogek_jumin");
String g_saname = rs.getString("sawon_name");
out.println("<tr align=center>");
out.println("<td><a href=/sertest/GogekDel?no=" + g_no + ">" + g_no + "</a></td>");
out.println("<td>" + g_name + "</td>");
out.println("<td>" + g_tel + "</td>");
out.println("<td>" + g_jumin + "</td>");
out.println("<td>" + g_saname + "</td></tr>");
count += 1;
}
out.println("<tr><td colspan=5><b>전체 건수 : " +
count + "</b></td></tr></table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("<hr width=70%>" + "<font color=red size=2>" + "자료 삭제 시 고객번호를 클릭</font>");
out.println("<br><font color=blue size=2>" + "고객명을 클릭하면 관리 고객 출력</font>");
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
package jikwon;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class JikwonInsert extends HttpServlet {
Connection conn;
PreparedStatement pstmt;
public void init() throws ServletException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("insert into sawon(sawon_name, buser_num, sawon_jik, sawon_pay, sawon_ibsail, sawon_sex) values(?,?,?,?,?,?)");
} catch (Exception e) {
System.out.println("연결실패:"+e);
return;
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
String s_name = request.getParameter("jikname");
String b_num = "";
try {
String sel[] = request.getParameterValues("buser");
for(int i = 0; i < sel.length; i++)
b_num = sel[i];
} catch (Exception e) {
return;
}
String s_jik = "";
try {
String sel[] = request.getParameterValues("jik");
for(int i = 0; i < sel.length; i++)
s_jik = sel[i];
} catch (Exception e) {
return;
}
String s_pay = request.getParameter("pay");
String s_ibsail = request.getParameter("ibsail");
String s_sex = "";
try {
String sel[] = request.getParameterValues("sex");
for(int i = 0; i < sel.length; i++)
s_sex = sel[i];
} catch (Exception e) {
return;
}
try {
pstmt.setString(1, s_name);
pstmt.setString(2, b_num);
pstmt.setString(3, s_jik);
pstmt.setString(4, s_pay);
pstmt.setString(5, s_ibsail);
pstmt.setString(6, s_sex);
pstmt.executeUpdate();
} catch (Exception e) {
System.out.println("입력 오류 : " + e);
return;
}
response.sendRedirect("/sertest/servlet/jikwon.JikwonList");
}
public void destroy() {
try {
pstmt.close();
conn.close();
} catch (Exception e) {
}
}
}
package jikwon;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class JikwonList extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select sawon_no,sawon_name,buser_name,sawon_jik,sawon_ibsail,sawon_sex from sawon left outer join buser on buser_num = buser_no");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("<html><body><center>");
out.println("<h2>***직원 목록***</h2>");
out.println("<table border=0 width=80%>");
out.println("<tr bgcolor=yellow>");
out.println("<th>사번</th><th>이름</th>");
out.println("<th>부서</th><th>직급</thㄱ>");
out.println("<th>입사일</th><th>성별</th></tr>");
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
while(rs.next()){
String no = rs.getString("sawon_no");
String name = rs.getString("sawon_name");
String buser = rs.getString("buser_name");
String jik = rs.getString("sawon_jik");
String ibsail = rs.getString("sawon_ibsail").substring(0,10);
String sex = rs.getString("sawon_sex");
out.println("<tr align=center>");
out.println("<td><a href=/sertest/JikwonDel?no=" + no + ">" + no + "</a></td>");
out.println("<td><a href=/sertest/JikwonGogek?no=" + no + " target=_blank>" + name + "</td>");
out.println("<td>" + buser + "</td>");
out.println("<td>" + jik + "</td>");
out.println("<td>" + ibsail + "</td>");
out.println("<td>" + sex + "</td></tr>");
count += 1;
}
out.println("<tr><td colspan=5><b>전체 건수 : " +
count + "</b></td></tr></table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("<hr width=70%>" + "<font color=red size=2>" + "자료 삭제 시 사원번호를 클릭</font>");
out.println("<br><font color=blue size=2>" + "직원명을 클릭하면 관리 고객 출력</font>");
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class GogekDel extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=euc-kr");
request.setCharacterEncoding("euc-kr");
PrintWriter out = response.getWriter();
String no = request.getParameter("no");
out.println("<html><body><center><p>");
out.println("<h2>" + no + "번 자료를 정말 삭제할까요?</h2>");
out.println("<form method=post action=/sertest/JikwonDelOk>");
out.println("<input type=hidden name=code value=" +no+">");
out.println("<input type=submit value=삭제>");
out.println("<input type=button value=취소 onClick=history.back()>");
out.println("</form></center></body></html>");
}
}
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class GogekDelOk extends HttpServlet {
Connection conn;
PreparedStatement pstmt;
public void init() throws ServletException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("delete from gogek where gogek_no=?");
} catch (Exception e) {
System.out.println("연결실패:"+e);
return;
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String code=request.getParameter("code");
System.out.println(code);
try {
pstmt.setString(1, code);
pstmt.executeUpdate();
} catch (Exception e) {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("삭제되지 않았습니다.<a href=/sertest/servlet/jikwon.JikwonList>돌아가기</a>");
return;
}
response.sendRedirect("/sertest/servlet/jikwon.JikwonList"); // 바로 보내는거, 상품리스트를 바로 부른다.
}
public void destroy() {
try {
pstmt.close();
conn.close();
} catch (Exception e) {
}
}
}
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class GogekIns extends HttpServlet {
Connection conn;
PreparedStatement pstmt;
public void init() throws ServletException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("insert into gogek(gogek_name, gogek_tel, gogek_jumin, gogek_damsano) values(?,?,?,?)");
} catch (Exception e) {
System.out.println("연결실패:"+e);
return;
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
String g_name = request.getParameter("g_name");
String g_tel = request.getParameter("g_tel");
String g_jumin = request.getParameter("g_jumin");
String g_damsano = request.getParameter("g_damsano");
try {
pstmt.setString(1, g_name);
pstmt.setString(2, g_tel);
pstmt.setString(3, g_jumin);
pstmt.setString(4, g_damsano);
pstmt.executeUpdate();
} catch (Exception e) {
System.out.println("입력 오류 : " + e);
return;
}
response.sendRedirect("/sertest/GogekList");
}
public void destroy() {
try {
pstmt.close();
conn.close();
} catch (Exception e) {
}
}
}
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.*;
public class GogekList2 extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select * from gogek left outer join sawon on sawon_no = gogek_damsano order by gogek_no");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("<html><body><center>");
out.println("<h2>*** 40대 미만 고객 목록***</h2>");
out.println("<table border=0 width=80%>");
out.println("<tr bgcolor=yellow>");
out.println("<th>고객번호</th><th>고객이름</th><th>고객전번</th>");
out.println("<th>고객주민번호</th><th>담당사원이름</th></tr>");
Calendar calendar = new GregorianCalendar();
int year = calendar.get(calendar.YEAR);
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
while(rs.next()){
String g_no = rs.getString("gogek_no");
String g_name = rs.getString("gogek_name");
String g_tel = rs.getString("gogek_tel");
String g_jumin = rs.getString("gogek_jumin");
System.out.println(Integer.parseInt(g_jumin.substring(0, 2)));
if((year - 1900 - (Integer.parseInt(g_jumin.substring(0, 2)))) > 40) {
continue;
}
String g_saname = rs.getString("sawon_name");
out.println("<tr align=center>");
out.println("<td><a href=/sertest/GogekDel?no=" + g_no + ">" + g_no + "</a></td>");
out.println("<td><a href=/sertest/GogekSawon?no=" + g_no + ">" +g_name + "</td>");
out.println("<td>" + g_tel + "</td>");
out.println("<td>" + g_jumin + "</td>");
out.println("<td>" + g_saname + "</td></tr>");
count += 1;
}
out.println("<tr><td colspan=5><b>전체 건수 : " +
count + "</b></td></tr></table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("<hr width=70%>" + "<font color=red size=2>" + "자료 삭제 시 고객번호를 클릭</font>");
out.println("<br><font color=blue size=2>" + "고객명을 클릭하면 관리 고객 출력</font>");
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class GogekList extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select * from gogek left outer join sawon on sawon_no = gogek_damsano order by gogek_no");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
out.println("<html><body><center>");
out.println("<h2>***고객 목록***</h2>");
out.println("<table border=0 width=80%>");
out.println("<tr bgcolor=yellow>");
out.println("<th>고객번호</th><th>고객이름</th><th>고객전번</th>");
out.println("<th>고객주민번호</th>><th>담당사원이름</th></tr>");
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
while(rs.next()){
String g_no = rs.getString("gogek_no");
String g_name = rs.getString("gogek_name");
String g_tel = rs.getString("gogek_tel");
String g_jumin = rs.getString("gogek_jumin");
String g_saname = rs.getString("sawon_name");
out.println("<tr align=center>");
out.println("<td><a href=/sertest/GogekDel?no=" + g_no + ">" + g_no + "</a></td>");
out.println("<td><a href=/sertest/GogekSawon?no=" + g_no + " target=_blank>" +g_name + "</td>");
out.println("<td>" + g_tel + "</td>");
out.println("<td>" + g_jumin + "</td>");
out.println("<td>" + g_saname + "</td></tr>");
count += 1;
}
out.println("<tr><td colspan=5><b>전체 건수 : " +
count + "</b></td></tr></table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("<hr width=70%>" + "<font color=red size=2>" + "자료 삭제 시 고객번호를 클릭</font>");
out.println("<br><font color=blue size=2>" + "고객명을 클릭하면 관리 고객 출력</font>");
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class GogekSawon extends HttpServlet{
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
public void init() throws ServletException{
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123");
pstmt=conn.prepareStatement("select * from sawon, buser, gogek where sawon_no = gogek_damsano and buser_num = buser_no and gogek_no = ?");
}catch(Exception e){
System.out.println("연결 실패 : " + e);
return;
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("euc-kr");
response.setContentType("text/html;charset=euc-kr");
PrintWriter out = response.getWriter();
String no = request.getParameter("no");
System.out.println(no);
try {
pstmt.setString(1, no);
} catch (Exception e) {
System.out.println("입력 오류 : " + e);
return;
}
out.println("<html><body><center>");
out.println("<h2>*** 담당사원내역***</h2>");
out.println("<table border=0 width=80%>");
out.println("<tr bgcolor=yellow>");
out.println("<th>사원번호</th><th>사원이름</th><th>부서이름</th>");
out.println("<th>사원직급</th><th>사원성별</th></tr>");
try{
int count = 0; //전체 건수
rs = pstmt.executeQuery();
while(rs.next()){
String g_no = rs.getString("sawon_no");
String g_name = rs.getString("sawon_name");
String g_tel = rs.getString("buser_name");
String g_jumin = rs.getString("sawon_jik");
String g_saname = rs.getString("sawon_sex");
out.println("<tr align=center>");
out.println("<td><a href=/sertest/GogekDel?no=" + g_no + ">" + g_no + "</a></td>");
out.println("<td>" + g_name + "</td>");
out.println("<td>" + g_tel + "</td>");
out.println("<td>" + g_jumin + "</td>");
out.println("<td>" + g_saname + "</td></tr>");
count += 1;
}
out.println("<tr><td colspan=5><b>전체 건수 : " +
count + "</b></td></tr></table>");
}catch(Exception e){
System.out.println("SQL 오류 : " + e);
return;
}
out.println("<hr width=70%>" + "<font color=red size=2>" + "자료 삭제 시 고객번호를 클릭</font>");
out.println("<br><font color=blue size=2>" + "고객명을 클릭하면 관리 고객 출력</font>");
out.println("</center></body></html>");
}
public void destroy(){
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){}
}
}
<html><body>
<p><center>
<form method=post action=/sertest/GogekIns>
<table width=50%>
<tr>
<td width=40%>고객이름</td><td><input type=text name=g_name size=20></td>
</tr>
<tr>
<td width=40%>고객전번</td><td><input type=text name=g_tel size=20></td>
</tr>
<tr>
<td width=40%>고객주민번호</td><td><input type=text name=g_jumin size=20></td>
</tr>
<tr>
<td width=40%>담당사원번호</td><td><input type=text name=g_damsano size=20></td>
</tr>
<tr align=center>
<td colspan = 2>
<input type=submit value=" 등 록 ">
<input type=reset value="입력취소">
</td>
</tr>
</table>
</form>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<body bgcolor=cyan>
<center><br><br>
<font size=2>
★ 직원관리 ★<p>
<a href="/sertest/servlet/jikwon.JikwonList" target=main>직원 목록</a>
<p>
<a href="/sertest/servlet/jikwon.Buser" target=main>부서 인원수</a>
<p>
<a href="jikwonins.html" target=main>직원 추가</a>
<p>
-----------
<p>
♣ 고객관리 ♣<p>
<a href="/sertest/GogekList" target=main>고객 목록</a>
<p>
<a href="/sertest/GogekList2" target=main>40대미만 남성</a>
<p>
<a href="/sertest/gogekin.html" target=main>고객 추가</a>
<br><br><br><br>
<a href="/sertest/jikwon/jikmain.html" target=main>☞ 홈으로</a>
</font>
</body></html>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>상품자료</title>
</head>
<body><center><p>
<h3>--- 직원 및 고객자료 처리 ---</h3>
<img src="book.jpg">
<hr width=70%>
중앙ITEA All Right Reserved
</body>
</html>
<frameset cols="12%,*" frameborder=0 bordercolor=black>
<frame src="jiklmenu.html" name="menu"
frameborder=0 noresize>
<frame src="jikmain.html" name="main"
frameborder=0 noresize>
</frameset>
<html><body>
<p><center>
<form method=post action=/sertest/JikwonInsert>
<table width=40%>
<tr>
<td width=30%>직원이름</td><td><input type=text name=jikname size=20></td>
</tr>
<tr>
<td width=20%>부서</td><td><input type=radio name=buser value=10 checked>총무부
<input type=radio name=buser value=20>영업부<br>
<input type=radio name=buser value=30>전산부
<input type=radio name=buser value=40>관리부</td>
</tr>
<tr>
<td width=20%>직급</td>
<td><input type=radio name=jik value=사원 checked>사원
<input type=radio name=jik value=대리>대리
<input type=radio name=jik value=과장>과장 <br>
<input type=radio name=jik value=부장>부장
<input type=radio name=jik value=사장>사장 </td>
</tr>
<tr>
<td width=20%>월급</td><td><input type=text name=pay></td>
</tr>
<tr>
<td width=20%>입사일</td><td><input type=text name=ibsail><br>형식은 년-월-일 <br>예: 2007-12-10로 작성</td>
</tr>
<tr>
<td width=20%>성별</td><td><input type=radio name=sex value=남 checked>남
<input type=radio name=sex value=여>여 </td>
</tr>
<tr align=center>
<td colspan = 2>
<input type=submit value=" 등 록 ">
<input type=reset value="입력취소">
</td>
</tr>
</table>
</form>
</body>
</html>
이상입니다.