<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" ""> <html xmlns="" lang="en" xml:lang="en"> <html xmlns="" lang="ko" xml:lang="ko"> <img src="" width="575" height="130"> <head> <HR align=left width=570 color=#000000> <% Dimension variables Dim adoCon Holds the Database Connection Object Dim rsAddComments Holds the record for the new record to be added Dim strSQL Holds the SQL query to query the database Create an ADO connection object Set adoCon = Server.CreateObject("ADODB.Connection") Set an active connection to the Connection object using a DSN-less connection adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)};; DBQ=" & Server.MapPath("Users.mdb") Create an ADO record object Set rsAddComments = Server.CreateObject("ADODB.Record") Initialise the strSQL variable with an SQL statement to query the database strSQL = "SELECT tblUsers.User_Name, tblUsers.User_passwd, tblUsers.User_level, tblUsers.NAME, tblUsers.MAIL_ID, tblUsers.Place, tblUsers.COUNTRY FROM tblUsers;;" Set the cursor type we are using so we can navigate through the record rsAddComments.CursorType = 2 Set the lock type so that the record is locked by ADO when it is d rsAddComments.LockType = 3 Open the record with the SQL query rsAddComments.Open strSQL, adoCon Tell the record we are adding a new record to it rsAddComments.AddNew Add a new record to the record rsAddComments.Fields("User_Name") = Request.Form("User_ID") rsAddComments.Fields(" ") = Request.Form("E-mail") rsAddComments.Fields("User_Address") = Request.Form("Address") rsAddComments.Fields("User_City") = Request.Form("City") rsAddComments.Fields("User_State") = Request.Form("State") rsAddComments.Fields("User_Country") = Request.Form("Country") rsAddComments.Fields("Use_Zip Code") = Request.Form("Zip Code") rsAddComments.Fields("User_passwd") = Request.Form("Password") rsAddComments.Fields("User_passwd") = Request.Form("Password again") Write the d record to the database rsAddComments.Update

Re server objects rsAddComments.Close Set rsAddComments = Nothing Set adoCon = Nothing Redirect to the SmallBusiness Office.asp page Response.Redirect "\signup.jsp" %> <% Response.Buffer = true %> <%

%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" ""> <h2>LogIn_jsp</h2> <% import java.sql.*;

public class Test {

public static void main(String() args) {

try {

System.err.printIn("???? ?? : " + e.getMessage(); }





try {

String url = "jdbc:mysql://localhost/goods";

Connection db = DriverManager.getConnection( url, "jsptest", "" );

} catch (SQLException e) {

System.err.printIn("SQL ?? : " + e.getMessage();




try {

Statement stmt = db.Statement();

ResultSet rs = stmt.uteQuery(" * from list");


} catch (SQLException e) {

System.err.printIn("SQL Error : " + e.getMessage());





try {


<% String url = "jdbc:mysql://localhost/goods";

Connection db = DriverManager.getConnection(url, "jsptest", "" );

Statement stmt = db.Statement(" * from list");

ResultSet rs = stmt.excuteQuery();

while ( {

String no = rs.getInt("no");

String name = rs.getChar("name");

String price = rs.getInt("price");

System.out.printIn(no + ":" + name + ":" + price); }

rs.close(); stmt.close(); db.close();

%></head> <body> <FORM action="\signup.jsp" method=post> <TABLE height="27%" width="27%" border=3>


$row = mysql_query(" no from $member_ where user_id='$user_id'"); $row = mysql_fetch_array($row); $user_no = $row[no]; $memo = $name. "님의 가입을 진심으로 축하드립니다. 앞으로 자주 뵈었으면 좋겠습니다~! 즐거운 하루되세요0"; mysql_query(" into $get_memo_ (member_no,member_from,subject,memo,readed,reg_date) values ('$user_no',1,'회원가입을 환영합니다0','$memo',1,'$reg_date')"); mysql_query(" $member_ new_memo=1 where user_id='$user_id'"); // 회원가입시 메모 보냄

?> %>

</TD></TR></TBODY></TABLE></FORM> <FONT color=#ff0000> <A href=""> <U> forgot password</U>

</FONT> </P> </TD> </TR> </TBODY> </TABLE> <CENTER> </CENTER> </DIV> </FORM> <form action=""id="cse-search-box">

<HR align="left" width="310" color="#000000"> </form> <style type="text/css"> h1 {color: #0000FF} h2 {color: #0000FF} h3 {color: #0000FF} h4 {color: #0000FF} h5 {color: #0000FF} h6 {color: #0000FF} </style> <% Session("FirstName") = Request.Form("fname") %> <% If Session("FirstName") = "" Then Response.Redirect("default.asp") End If %> <% 입력 파라미터 : @id_user, @no_password 고객이 로그인을 요구할 경우 사용자 id의 password가 일치하는 사용자 id, 성명, e-mail주소, 우편번호, 주소, 전화번호, 휴대폰, 주민등록번호를 가져오는 프로시져

@id_user varchar(20), @no_password varchar(20) as

ds_add2, no_tel1, no_tel2

from dzbt_user where id_user = @id_user and no_password = @no_password %> <% Response.Buffer = true %> <%

%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" ""> <a href=""><u>1. 천둥과 번개</u></a><br /> <a href=""><u>2. 구름과 비</u></a><br /><br /> <a href=""><u>3. 전기</u></a><br /> <a href=""><u>4. 자석</u></a><br /><br /> <a href=""><u>5. 빛</u></a><br /> <a href=""><u>6. 소리</u></a><br /><br /> <a href=""><u>7. 운동</a><br /> <a href=""><u>8. 시간</u></a><br /><br /> <HR align=left width=570 color=#000000> <a href="" target="_blank"> <img src="" width="282" height="330"></a> <a href="" target="_blank"> <img src="" width="281" height="330"></a> <hr width="570" align="left" color="#000000"><br> <b><i><h5>1. 어서오이소<%=Request.Form("아 이 디")%> 님!!!</h5></i></b> <a href="\Login.asp" target="_blank"><u><b>2. Smallbusiness office</b></u></a><br><br> <a href=""><b>3.</b> 스테가노스</a> <a href="">IP스위치</a> <a href="">Journaliator</a> <a href="">코넥트</a> <a href="">IMail Server Premium</a> <br><br> <a href=""><b>4.</b> A song of Despair</a> <a href="">The Love Song of J.Alfred Prufrock </a> <a href="">All Souls Night</a><br><br> <a href="\Login.jsp"><b>5.</b> Sun, Moon, and Stars</a> <a href="[[ÀÛ¾÷½Ç&board_all=no\Login.asp">ì˜ˆë¿ê·¸ë €</a>|ÀÛ¾÷½Ç&board_all=no\Login.asp">ì˜ˆë¿ê·¸ë €</a>|[[ÀÛ¾÷½Ç&board_all=no\Login.asp">ì˜ˆë¿ê·¸ë €</a]]>|\Login.asp">예뿐그녀</a]]>]]]]]] <a href="\Login.asp">쇼핑몰</a> <a href="\Login.asp">Friends</a> <a href="\Login.asp">臨 古</a> <a href="">지연이의 못진 춤</a> <a href="">좋은 현상으로</a><br><br> <%

Session("name")="" Response.Redirect("\confirm.ajsp") %> <a href="\signup.jsp"><u><b> 6. signup.</b></u></a> <%

Session("name")="" Response.Redirect("\addnewmember.jsp") %> <a href="\confirm.jsp"><u><b> confirm.</b></u></a> <%

Session("name")="" Response.Redirect("\Login.jsp") %> <a href="\addnewmember.jsp"><u><b> addnewmember.</b></u></a> <%

Session("name")="" Response.Redirect("\Login.jsp") %> <a href="\Login.jsp"><u><b> Login.</b></u></a> <%

Session("name")="" Response.Redirect("\check_user.jsp") %> <a href="\Login.jsp"><u><b> Logout.</b></u></a> <%

Session("name")="" Response.Redirect("\forgot.jsp?mode=send") %> <a href="\forgot.jsp"><u><b> forgot.</b></u></a> <a href="" target="_blank"><u><b> Forum.</b></u></a><a href=""><u><b> Microsoft® Window<br><br>s NT® 4.0 Option Pack.</b></u></a> <a href=""><u><b> Internet Assigned Numbers Authority.</b></u></a> <a href=""><u><b>Visual studio.</b></u></a> <a href="" target="_blank"> <u><b> a satisfac<br><br>tion expression with the microsoft</b></u></a> <hr width="570" align="left" color="#000000"> <%

%> </body> </html> <html xmlns="" lang="ko" xml:lang="ko"> <head> <% <script type="text/javascript"> function getCookie(c_name) { if (document.cookie.length>0)

return ""; }

function Cookie(c_name,value,expiredays) { var exdate=new Date(); exdate.Date(exdate.getDate()+expiredays); document.cookie=c_name+ "=" +escape(value)+ ((expiredays==null) ? "" : ";expires="+exdate.toGMTString()); }

function checkCookie() { username=getCookie('username'); if (username!=null username!="")


} </script> %> </head> <body onload="checkCookie()"> <FORM action="\Login.asp/login_ok.jsp" method=post> <TABLE height="27%" width="27%" border=2>

</TD></TR></TBODY></TABLE></FORM> <img src="" width="265" height="3"> <a href="" target="_blank"><b>카페노래</b></a><img src="" width="262" height="3"><br><br><br><br> <a href="" target="_blank"> <img style="border:2;;width:80px;;height:76px"

<a href=""> <img src="" width="83" height="70"></a> <a href=""> <img src="제목%20없음qq_1.bmp" width="104" height="70"></a> <a href=""> <img src="변하는집.gif" width="81" height="69"></a> <a href=""> <img src="" width="83" height="70"></a> <a href=""> <img src="" width="104" height="70"></a> <img src="" width="577" height="40"> </body> </html> <hr width="577" align="left" color="#000000"> <html> <head> <style type="text/css"> h4 {text-align: center} h4 {color: #0000FF} </style> </head> <body> <a href=""><i><h4>copyright (c) jimimi</h4></i></a> <a href="" target="_blank"> <img src="" width="80" height="21"></a> <hr width="82" align="left" color="#FFFF00"> <form action="" id="cse-search-box" borfer="5" target="_blank">

</form> <submit type="text/javascript" src="; border="5" lang=en"> </script> </body> </html>

FrontPage, (last edited 2010-04-05 03:35:25 by Jaewook Ban)