¼­ºí¸´¿¡¼­ DB ¿¬µ¿


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]

±Û¾´ÀÌ :±èÁø 1999³â 4¿ù 15ÀÏ 09:36:49

> ¾È³çÇϼ¼¿ä..
> ¼­ºí¸´¿¡¼­ db¿¬µ¿Çϴµ¥ ¹«Ã´ °í»ý½º·´½À´Ï´Ù.
>******************************************/
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;


public class Servlet extends HttpServlet {

public void doGet (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
ServletOutputStream out = res.getOutputStream();
out.println("<html>");
out.println("<h1>hello" +"</h1>"+"<br>");
try {
Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn1 = DriverManager.getConnection
("jdbc:oracle:thin:@190.5.11.20:1521:orcl","scott","tiger");

Statement stmt1 = conn1.createStatement();

ResultSet rs1 = stmt1.executeQuery ("select * from emp");

while (rs1.next()) {

out.println (rs1.getInt ("1") + "<br>");
out.println (rs1.getString ("2") + "<br>");
out.println (rs1.getString ("3") );

}
out.println("</html>");
stmt1.close();
conn1.close();
}
catch (Exception exception) {
out.println ("SQL Exception " + exception.toString() );
}

}
}


> *****************************************/
>
> ¾îÇø®ÄÉÀ̼ÇÇÏ°í ¿¡Çø´À¸·Î db°¡ ¿¬°áÀº µÇ´Âµ¥ ¼­ºí¸´¿¡¼­´Â ÀÌ·± ¿¡·¯°¡ ¶ß³×¿ä
>
> hello
>
>
> SQL Exception oracle.jdbc.driver.OracleDriver
>
>
> ºÎŹ µå¸³´Ï´Ù.


´ÙÀ½ ±Ûµé:



À̾ ±Û¿Ã¸®±â(´äÇϱâ)

À̸§:
E-Mail:
Á¦¸ñ:
³»¿ë:
HTML ÅÂ±× Æ÷ÇÔ ¿©ºÎ: HTML ¹®¼­ÀÏ °æ¿ì üũ
°ü·Ã URL(¼±ÅÃ):
URL Á¦¸ñ(¼±ÅÃ):
°ü·Ã À̹ÌÁö URL:


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]