±Û¾´ÀÌ :±èÁø 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
>
>
> ºÎŹ µå¸³´Ï´Ù.