JSP通过JDBC与Oracle相连

JSP通过JDBC与Oracle相连

一、环境变量(系统变量)

JAVA_HOME = C:JDK1.3
TOMCAT_HOME = C:TOMCAT-3.2.3
ClassPath = D:OracleOra81jdbclibclasses12.zip(JDBC驱动程序)

二、测试程序



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(":"+"
");
//out.println(" + rs.getString(´answers´) + ");
}
rs.close();

}
catch(Exception e)
{
out.println(e);
}

　[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9650775/viewspace-921133/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9650775/viewspace-921133/