package dbTest;

import java.io.ByteArrayInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

class LongInsert {
	LongInsert(String name, String xml) {
		this.name = name;
		this.xml = xml;
		insertToDB();
	}

	String name;
	String xml;
	String sqlstr;
	String errorStatus = "false";

	String insertToDB() {

		sqlstr = "insert into longtest(name, xml, timestamp) values(?, ?, sysdate)";

		try {
			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
			Connection esql = DriverManager.getConnection(
					"jdbc:oracle:thin:@192.168.1.6:1521:dream", "scott",
					"tiger");

			PreparedStatement ps = esql.prepareStatement(sqlstr);
			InputStream is = new ByteArrayInputStream(xml.getBytes());

			int i = 1;
			ps.setString(i++, name);
			ps.setAsciiStream(i++, is, is.available());

			if (ps.executeUpdate() > 0) {
				System.out.println("¾÷µ¥ÀÌÆ® ¿Ï·á");
			}

			// System.out.println("¼º°ø");
		} catch (Exception e) {
			errorStatus = "true";
			e.printStackTrace();
		}

		return errorStatus;

	}
}