Youtube版【Java】JavaサーブレットからOracleへ接続する

解説動画

Javaサーブレットから、Oracleへ接続します。
まずは、ステートメントでSQLを発行です。

■動画はこちら

■Youtube版の解説で使用しているソースコード
動画と一緒にこちらも参考にどうぞ。

JavaサーブレットからのOracle接続

import java.io.BufferedWriter;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

public class JdbcOraTestServlet2 extends HttpServlet {
	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		try {

			//DBに接続(URL,USER_ID,PASSWORD)
			InitialContext ctx = new InitialContext();
			DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/oraora");
			Connection conn = ds.getConnection();

			//SQLを発行
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("select item_name,price from price_list");

			//結果を取得
			StringBuilder sb = new StringBuilder();
			sb.append("<html><header><meta charset=\"UTF-8\"></header><body>");
			while(rs.next()) {
				sb.append(rs.getString("item_name")).append(" ").append(rs.getString("price")).append("<br />");
			}
			sb.append("</body></html>");

			//クローズ
			rs.close();
			stmt.close();
			conn.close();

			//結果をブラウザへ
			ServletOutputStream sos = response.getOutputStream();
			OutputStreamWriter osw = new OutputStreamWriter(sos,"UTF-8");
			BufferedWriter bw = new BufferedWriter(osw);
			bw.write(sb.toString());
			bw.flush();
			bw.close();
			
		}catch(Exception e) {
			e.printStackTrace();
		}
	}
}

import java.io.BufferedWriter;

import java.io.IOException;

import java.io.OutputStreamWriter;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Statement;

import javax.naming.InitialContext;

import javax.servlet.ServletException;

import javax.servlet.ServletOutputStream;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.sql.DataSource;

public class JdbcOraTestServlet2 extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

try {

//DBに接続(URL,USER_ID,PASSWORD)

InitialContext ctx = new InitialContext();

DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/oraora");

Connection conn = ds.getConnection();

//SQLを発行

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("select item_name,price from price_list");

//結果を取得

StringBuilder sb = new StringBuilder();

sb.append("<html><header><meta charset=\"UTF-8\"></header><body>");

while(rs.next()) {

sb.append(rs.getString("item_name")).append(" ").append(rs.getString("price")).append("<br />");

}

sb.append("</body></html>");

//クローズ

rs.close();

stmt.close();

conn.close();

//結果をブラウザへ

ServletOutputStream sos = response.getOutputStream();

OutputStreamWriter osw = new OutputStreamWriter(sos,"UTF-8");

BufferedWriter bw = new BufferedWriter(osw);

bw.write(sb.toString());

bw.flush();

bw.close();

}catch(Exception e) {

e.printStackTrace();

}

context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context>
 <Resource
 name="jdbc/oraora"
 auth="Container"
 type="javax.sql.DataSource"
 maxTotal="3"
 maxIdle="1"
 username="YURUKU" password="FUWATTO"
 driverClassName="oracle.jdbc.driver.OracleDriver"
 url="jdbc:oracle:thin:@DBYuruFuwa:1521:xe"/>
</Context>