sql 문법 질문드립니다. (내공100)
-
게시물 수정 , 삭제는 로그인 필요
sql 생초짜입니다.
문장 마다 자세한 설명을 해주셨음 좋겠습니다.
아래는 asp 파일 내용
---
<html>
<head><title>회원 검색 결과</title></head>
<body>
<br>
<center><H2> 회원 검색 결과 </h2>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "smart", "sa", ""
member_num = request("member_num")
name = request("name")
person_num= request("person_num")
address= request("address")
phone = request("phone")
emailyn = request("emailyn")
email = request("email")
member_rank = request("member_rank")
sql= "SELECT member_num, name, person_num, address, phone, emailyn, email,member_lev "
sql= sql & " FROM member,member_rank "
sql= sql & " WHERE member_num >=1 and member.member_rank = member_rank.member_rank"
if (member_num <> "") Then sql= sql & " AND member_num = " & member_num & "" end if
if (name <> "") Then sql= sql & " AND name like '%" & name & "%'" end if
if (person_num <> "") Then sql= sql & " AND person_num like '%" & person_num & "%'" end if
if (address <> "") Then sql= sql & " AND address like '%" & address & "%'" end if
if (phone <> "") Then sql= sql & " AND phone like '%" & phone & "%'" end if
if (emailyn <> "") Then sql= sql & " AND emailyn like '%" & emailyn & "%'" end if
if (email <> "") Then sql= sql & " AND email like '%" & email & "%'" end if
if (member_rank <> "") Then sql= sql & " AND member.member_rank = '" & member_rank & "'" end if
sql= sql & " ORDER BY name"
Set Rs=Conn.Execute(sql)
%>
<br>
<a href="mainmenu.asp"; return false">메인메뉴</a>
<a href="member_retrieve.asp"; return false">회원조회</a>
<a href="member_insert.asp"; return false">회원추가</a>
<br><br>
<center>
<table border="1" cellspacing="0" cellpadding="3" bordercolor="#999999" style="border-collapse:collapse;">
<tr>
<td bgcolor="#CCCCCC" align="center"> 순번 </td>
<td bgcolor="#CCCCCC" align="center"> 회번 </td>
<td bgcolor="#CCCCCC" align="center"> 선택 </td>
<td bgcolor="#CCCCCC" align="center"> 회원명 </td>
<td bgcolor="#CCCCCC" align="center"> 주민등록번호</td>
<td bgcolor="#CCCCCC" align="center"> 주소 </td>
<td bgcolor="#CCCCCC" align="center"> 전화번호</td>
<td bgcolor="#CCCCCC" align="center"> 이메일여부 </td>
<td bgcolor="#CCCCCC" align="center"> 이메일 </td>
<td bgcolor="#CCCCCC" align="center"> 등급 </td>
</tr>
<%
num=0
while Not Rs.EOF
num=num+1
%>
<tr>
<td align="center"><%=num%></td>
<td align="center"><%=Rs("member_num")%></td>
<td><a href="member_update.asp?member_num=<%=Rs("member_num")%>">수정</a>
<a href="member_exedelete.asp?member_num=<%=Rs("member_num")%>">삭제</a></td>
<td><%=Rs("name")%></td>
<td><%=Rs("person_num")%></td>
<td><%=Rs("address")%></td>
<td><%=Rs("phone")%></td>
<td><%=Rs("emailyn")%></td>
<td><%=Rs("email")%></td>
<td><%=Rs("member_lev")%></td>
</tr>
<%
Rs.MoveNext
Wend
Conn.close
Set rs=Nothing
Set Conn=Nothing
%>
</table>
<br>
<a href="mainmenu.asp"; return false">메인메뉴</a>
<a href="member_retrieve.asp"; return false">회원조회</a>
<a href="member_insert.asp"; return false">회원추가</a>
</center>
</body>
</html>
이게 첫번째
-------
<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "smart", "sa", ""
company_num = request("company_num")
telecommade = request("telecommade")
name = request("name")
chager= request("chager")
phone = request("phone")
sql="UPDATE company SET name = '" & name & "'"
sql=sql & ", telecommade = '" & telecommade & "'"
sql=sql & ", chager = '" & chager & "'"
sql=sql & ", phone = '" & phone & "'"
sql=sql & " WHERE company_num = " & company_num
Set Rs=Conn.Execute(sql)
Conn.close
Set rs=Nothing
Set Conn=Nothing
%>
<html><head><title> 회사 정보 수정 </title></head>
<body>
<form action="company_exeretrieve.asp" name="edit" method=post>
<input type="hidden" name= "company_num" value="<%=company_num%>">
</form>
<script language="javascript">
<!--
alert("회사 정보를 수정하였습니다.");
document.edit.submit();
//-->
</script>
</body>
</html>
이게 2번째입니다.
자세하게 설명해주시면 감사하겠습니다.
#sql 문법 #sql 문법 정리 pdf #sql 문법 검사 #sql 문법 순서 #sql 문법 종류 #sql 문법 총정리 #sql 문법 예제 #sql 문법 join