<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%!Connection conn = null;
Statement stmt = null;
ResultSet rs_tmp = null;
try {
String createSql="create table meta_temp as select * from meta";
Class.forName("oracle.jdbc.driver.OracleDriver");
String url ="jdbc:oracle:thin:@192.168.0.55:1521:mydb";
conn = DriverManager.getConnection(url,"ptm_co","cyberdb");
stmt = conn.createStatement();
//create temp table
stmt.executeQuery(createSql);
%>
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%!Connection conn = null;
Statement stmt = null;
ResultSet rs_tmp = null;
try {
String createSql="create table meta_temp as select * from meta";
Class.forName("oracle.jdbc.driver.OracleDriver");
String url ="jdbc:oracle:thin:@192.168.0.55:1521:mydb";
conn = DriverManager.getConnection(url,"ptm_co","cyberdb");
stmt = conn.createStatement();
//create temp table
stmt.executeQuery(createSql);
%>
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=questionnaire";
Connection con= DriverManager.getConnection(url,"sa","111111");
Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs;
String sql;
%>