########## 11111111.txt¹®¼#################################################
:::MySQLÀÛ¾÷:::::::::::::: Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp.
C:\Documents and Settings\Administrator>cd..
C:\Documents and Settings>cd..
C:\>cd \mysql -u apple -p ÁöÁ¤µÈ °æ·Î¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.
C:\>cd \mysql -u root -p ÁöÁ¤µÈ °æ·Î¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.
C:\>cd \mysql -u root -p ÁöÁ¤µÈ °æ·Î¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.
C:\>mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.0.22-nt
Type help; or \h for help. Type \c to clear the buffer.
mysql> mysql> mysql> mysql> mysql> mysql> mysql> mysql> mysql> mysql> mysql> mysql> mysql> mysql> create database appledb; Query OK, 1 row affected (0.09 sec)
mysql> grant all on appledb. * to apple@localhost identified by 1234; Query OK, 0 rows affected (0.16 sec)
mysql> exit Bye
C:\>mysql -u apple -p Enter password: **** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 to server version: 4.0.22-nt
Type help; or \h for help. Type \c to clear the buffer.
mysql> exit Bye
C:\>cd mssql ÁöÁ¤µÈ °æ·Î¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.
C:\>cd mysql
C:\mysql>cd bin
C:\mysql\bin>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 80 to server version: 4.0.22-nt
Type help; or \h for help. Type \c to clear the buffer.
mysql> create database JspTestDB; Query OK, 1 row affected (0.02 sec)
mysql> use database ERROR 1049: Unknown database database mysql> use database; ERROR 1049: Unknown database database mysql> use JspTestDB Database changed mysql> create table starcraft(id varchar(20), -> name varchar(30), -> price int(10)); Query OK, 0 rows affected (0.06 sec)
mysql> insert into statcraft values (aa1, ¸¶¸°, 50); ERROR 1146: Table jsptestdb.statcraft doesn exist mysql> insert into starcraft values (aa1, ¸¶¸°, 50); Query OK, 1 row affected (0.00 sec)
mysql> insert into starcraft values (aa2, µå·¡°ï,250); Query OK, 1 row affected (0.00 sec)
mysql> insert into starcraft values (aa3, ĵµð,150); Query OK, 1 row affected (0.00 sec)
mysql> insert into starcraft values (aa4, È÷µå¶ó,75); Query OK, 1 row affected (0.00 sec)
mysql> insert into starcraft values (aa5, »½ÀÌ¿ä,150); Query OK, 1 row affected (0.00 sec)
mysql> select * from starcraft; +------+--------+-------+ | id | name | price | +------+--------+-------+ | aa1 | ¸¶¸° | 50 | | aa2 | µå·¡°ï | 250 | | aa3 | ĵµð | 150 | | aa4 | È÷µå¶ó | 75 | | aa5 | »½ÀÌ¿ä | 150 | +------+--------+-------+ 5 rows in set (0.00 sec)
mysql>
:::DB¿¬°á::::::::::::::::: ***JdbcExam.jsp <%@ page contentType= ext/html;charset = euc-kr import=java.sql.*\%> <%! private String driver=org.gjt.mm.mysql.Driver; private String user=
oot; private String pass=\; private String dbURL=jdbc:mysql://localhost:3306/jspTestDB; private String sql=select * from starcraft; private Connection connection; private Statement stmt; private ResultSet result; private String id; private String name; private int price; %> <html> <style type= ext/css> td{font-size:9pt} </style> <body> <p></p> <center><font color=darkblue>½ºÅ¸Å©·¡ÇÁÆ® À¯´Ö</font></center><br> <table width=60% border=1 bordercolor=#A0BCFF align=center> <tr bgcolor=#0054A8> <td><div align=center><font color=#FFFFFF>ID</font></div></td> <td><div align=center><font color=#FFFFFF>À¯´Ö¸í</font></div></td> <td><div align=center><font color=#FFFFFF>°¡°Ý</font></div></td> </tr> <% try{ Class.forName(driver); connection=DriverManager.getConnection(dbURL,user,pass); stmt=connection.createStatement(); result=stmt.executeQuery(sql); while(result.next()){ id=result.getString(id); name=result.getString(
ame); price=result.getInt(price); %> <tr bgcolor=#9bbcff> <td><div align=center><font color=#000000><%=id%></font></div></td> <td><div align=center><font color=#000000><%=name%></font></div></td> <td><div align=center><font color=#000000><%=price%></font></div></td> </tr> <% } }catch(SQLException se){ out.println(se.getMessage()); }catch(ClassNotFoundException cne){ out.println(jdbc driver not founded!); }
%> </table> </body> </html>
jsp½ºÅ͵ð 2004 11 26
¼Ò½ºÀÚ¼¼È÷º¸±â: http://www.6VJ.com/jsp/jsp1126.txt http://www.6VJ.com/jsp/jsp1126.html
########## 222222.html¹®¼#################################################
<!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN> <html> <head> <title>Untitled Document</title> <meta http-equiv=Content-Type content= ext/html; charset=euc-kr> </head>
<body> <pre> :::MySQLÀÛ¾÷::::::::::::::<br>Microsoft Windows 2000 [Version 5.00.2195]<br>(C) Copyright 1985-2000 Microsoft Corp.</pre> <p>C:\Documents and Settings\Administrator>cd..</p> <p>C:\Documents and Settings>cd..</p> <p>C:\>cd \mysql -u apple -p<br> ÁöÁ¤µÈ °æ·Î¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.</p> <p>C:\>cd \mysql -u root -p<br> ÁöÁ¤µÈ °æ·Î¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.</p> <p>C:\>cd \mysql -u root -p<br> ÁöÁ¤µÈ °æ·Î¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.</p> <p>C:\>mysql -u root -p<br> Enter password:<br> Welcome to the MySQL monitor. Commands end with ; or \g.<br> Your MySQL connection id is 7 to server version: 4.0.22-nt</p> <p>Type help; or \h for help. Type \c to clear the buffer.</p> <p>mysql><br> mysql><br> mysql><br> mysql><br> mysql><br> mysql><br> mysql><br> mysql><br> mysql><br> mysql><br> mysql><br> mysql><br> mysql><br> mysql> create database appledb;<br> Query OK, 1 row affected (0.09 sec)</p> <p>mysql> grant all on appledb. * to apple@localhost identified by 1234;<br> Query OK, 0 rows affected (0.16 sec)</p> <p>mysql> exit<br> Bye</p> <p>C:\>mysql -u apple -p<br> Enter password: ****<br> Welcome to the MySQL monitor. Commands end with ; or \g.<br> Your MySQL connection id is 8 to server version: 4.0.22-nt</p> <p>Type help; or \h for help. Type \c to clear the buffer.</p> <p>mysql> exit<br> Bye</p> <p>C:\>cd mssql<br> ÁöÁ¤µÈ °æ·Î¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.</p> <p>C:\>cd mysql</p> <p>C:\mysql>cd bin</p> <p>C:\mysql\bin>mysql -u root<br> Welcome to the MySQL monitor. Commands end with ; or \g.<br> Your MySQL connection id is 80 to server version: 4.0.22-nt</p> <p>Type help; or \h for help. Type \c to clear the buffer.</p> <p>mysql> create database JspTestDB;<br> Query OK, 1 row affected (0.02 sec)</p> <p>mysql> use database<br> ERROR 1049: Unknown database database<br> mysql> use database;<br> ERROR 1049: Unknown database database<br> mysql> use JspTestDB<br> Database changed<br> mysql> create table starcraft(id varchar(20),<br> -> name varchar(30),<br> -> price int(10));<br> Query OK, 0 rows affected (0.06 sec)</p> <p>mysql> insert into statcraft values (aa1, ¸¶¸°, 50);<br> ERROR 1146: Table jsptestdb.statcraft doesn exist<br> mysql> insert into starcraft values (aa1, ¸¶¸°, 50);<br> Query OK, 1 row affected (0.00 sec)</p> <p>mysql> insert into starcraft values (aa2, µå·¡°ï,250);<br> Query OK, 1 row affected (0.00 sec)</p> <p>mysql> insert into starcraft values (aa3, ĵµð,150);<br> Query OK, 1 row affected (0.00 sec)</p> <p>mysql> insert into starcraft values (aa4, È÷µå¶ó,75);<br> Query OK, 1 row affected (0.00 sec)</p> <p>mysql> insert into starcraft values (aa5, »½ÀÌ¿ä,150);<br> Query OK, 1 row affected (0.00 sec)</p> <p>mysql> select * from starcraft;<br> +------+--------+-------+<br> | id | name | price |<br> +------+--------+-------+<br> | aa1 | ¸¶¸° | 50 |<br> | aa2 | µå·¡°ï | 250 |<br> | aa3 | ĵµð | 150 |<br> | aa4 | È÷µå¶ó | 75 |<br> | aa5 | »½ÀÌ¿ä | 150 |<br> +------+--------+-------+<br> 5 rows in set (0.00 sec)</p> <p>mysql></p> <p>:::DB¿¬°á:::::::::::::::::<br> ***JdbcExam.jsp<br> <%@ page contentType="text/html;charset = euc-kr" import="java.sql.*"%><br> <%!<br> private String driver="org.gjt.mm.mysql.Driver";<br> private String user="root";<br> private String pass="";<br> private String dbURL="jdbc:mysql://localhost:3306/jspTestDB";<br> private String sql="select * from starcraft";<br> private Connection connection;<br> private Statement stmt;<br> private ResultSet result;<br> private String id;<br> private String name;<br> private int price;<br> %><br> <html><br> <style type="text/css"><br> td{font-size:9pt}<br> </style><br> <body><br> <p></p><br> <center><font color="darkblue">½ºÅ¸Å©·¡ÇÁÆ® À¯´Ö</font></center><br><br> <table width="60%" border="1" bordercolor="#A0BCFF" align="center"><br> <tr bgcolor="#0054A8"><br> <td><div align="center"><font color="#FFFFFF">ID</font></div></td><br> <td><div align="center"><font color="#FFFFFF">À¯´Ö¸í</font></div></td><br> <td><div align="center"><font color="#FFFFFF">°¡°Ý</font></div></td><br> </tr><br> <%<br> try{<br> Class.forName(driver);<br> connection=DriverManager.getConnection(dbURL,user,pass);<br> stmt=connection.createStatement();<br> result=stmt.executeQuery(sql);<br> <br> while(result.next()){<br> id=result.getString("id");<br> name=result.getString("name");<br> price=result.getInt("price");<br> %><br> <tr bgcolor="#9bbcff"><br> <td><div align="center"><font color="#000000"><%=id%></font></div></td><br> <td><div align="center"><font color="#000000"><%=name%></font></div></td><br> <td><div align="center"><font color="#000000"><%=price%></font></div></td><br> </tr><br> <%<br> }<br> }catch(SQLException se){<br> out.println(se.getMessage());<br> }catch(ClassNotFoundException cne){<br> out.println("jdbc driver not founded!");<br> }</p> <p> <br> %><br> </table> <br> </body><br> </html></p> <p></p> <p><br> jsp½ºÅ͵ð 2004 11 26</p> <p>¼Ò½ºÀÚ¼¼È÷º¸±â:<br> http://www.6VJ.com/jsp/jsp1126.txt<br> http://www.6VJ.com/jsp/jsp1126.html</p> <pre> </pre> </body> </html>
|