Js|oracle
JSP is connected to Oracle through JDBC
Environment variables (System variables)
Java_home = C:\JDK1.3
Tomcat_home = C:\TOMCAT-3.2.3
ClassPath = D:\Oracle\Ora81\jdbc\lib\classes12.zip (JDBC driver)
Second, test procedures
<%@ page language= "java" import= "java.io.*,java.sql.*,javax.sql.*, javax.naming.*"%>
<%@ page contenttype= "text/html;charset=gb2312"%>
<%
String sdbdriver = "Oracle.jdbc.driver.OracleDriver";
String sConnStr = "JDBC:ORACLE:THIN:@192.168.0.58:1521:ORCL";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
Try
{
Class.forName (Sdbdriver);
conn = Drivermanager.getconnection (sConnStr, "Veh_admin", "Oracle");
stmt = Conn.createstatement ();
Stmt.executequery ("CREATE TABLE aaa (AAA int)");
Stmt.executeupdate ("INSERT into BBB values (456)");
rs = Stmt.executequery ("SELECT * from Veh_xzqj");
while (Rs.next ()) {
Out.println ("" + rs.getint (1) + "");
Out.println (":" + "<br>");
Out.println ("+ rs.getstring (' answers ') +");
}
Rs.close ();
}
catch (Exception e)
{
Out.println (e);
}