import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class oracletest extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException {
response.setContentType("text/html; charset=EUC-JP");
PrintWriter out = response.getWriter();
out.println("Oracle JDBC TestPageOracle 接続テストページ| EMPNO | ENAME | SAL | ");
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String dburl = "jdbc:oracle:thin:@lknode1.miraclelinux.com:1521:o9202";
Connection conn = DriverManager.getConnection(dburl,"scott","tiger");
Statement stmt = conn.createStatement();
String sqlstr = "select empno,ename,sal from emp";
ResultSet rset = stmt.executeQuery(sqlstr);
if(rset != null) {
while (rset.next()) {
String empno = rset.getString("empno");
String ename = rset.getString("ename");
String sal = rset.getString("sal");
out.println("| " + empno + " | " + ename + " | " + sal + " |
");
}
} else {
out.println("| No Record |
");
}
rset.close();
stmt.close();
conn.close();
}
catch(Exception e) {
e.printStackTrace(System.err);
}
out.println("
");
out.close();
}
}