最好不要在jsp里面直接写java代码,这样以后非常难维护,你最好把java代码写在servlet里面。或者写在javabean里面。
我这里有一个连接oracle的数据库连接类,你只要改动以下驱动就可以了。
package jp.co.nec.JTC;import java.sql.*;
import java.util.*;
import java.io.*;
public class JTCDBConnectionF implements Serializable{
protected Connection con = null;
public JTCDBConnectionF() { }
public void dbOpen() throws java.lang.Exception{
if (con == null || con.isClosed()) {
String url = "jdbc:oracle:oci8:@apsv";
String user = "scott";
String pass = "tiger";
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
con = DriverManager.getConnection(url,user,pass);
con.setTransactionIsolation( con.TRANSACTION_READ_COMMITTED );
con.setAutoCommit(false); System.out.println("DB OPEN");
} else {
System.out.println("OPENED DB");
}
}
public JTCerrorF dbClose() {
try {
if (con != null && !con.isClosed()) {
con.rollback();
con.close();
System.out.println("DB CLOSE");
} else {
System.out.println("CLOSED DB");
}
}
catch (SQLException se) {
// return new JTCerrorF(se.getErrorCode(),se);
return new JTCerrorF("PD05",se); //DB CLOSE
}
finally {
con = null;
}
return (JTCerrorF)null;
}
}
我这里有一个连接oracle的数据库连接类,你只要改动以下驱动就可以了。
package jp.co.nec.JTC;import java.sql.*;
import java.util.*;
import java.io.*;
public class JTCDBConnectionF implements Serializable{
protected Connection con = null;
public JTCDBConnectionF() { }
public void dbOpen() throws java.lang.Exception{
if (con == null || con.isClosed()) {
String url = "jdbc:oracle:oci8:@apsv";
String user = "scott";
String pass = "tiger";
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
con = DriverManager.getConnection(url,user,pass);
con.setTransactionIsolation( con.TRANSACTION_READ_COMMITTED );
con.setAutoCommit(false); System.out.println("DB OPEN");
} else {
System.out.println("OPENED DB");
}
}
public JTCerrorF dbClose() {
try {
if (con != null && !con.isClosed()) {
con.rollback();
con.close();
System.out.println("DB CLOSE");
} else {
System.out.println("CLOSED DB");
}
}
catch (SQLException se) {
// return new JTCerrorF(se.getErrorCode(),se);
return new JTCerrorF("PD05",se); //DB CLOSE
}
finally {
con = null;
}
return (JTCerrorF)null;
}
}
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<HTML>
<HEAD>
<TITLE> 恬匍砿尖 </TITLE>
</HEAD>
<BODY>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url=new String("jdbc:odbc:platform");
String user="sa";
String password="";
Connection conDB= DriverManager.getConnection(url,user,password);
Statement stmt = conDB.createStatement(); ・
ResultSet rs;
String name = request.getParameter("stuname");
String sql="select * from JudgeHomework where StuName = '" + name + "' order by HomeworkID ";
rs=stmt.executeQuery(sql);
%><TABLE bgcolor=DodgerBlue>
<TR bgcolor=SkyBlue>
<TD>恬匍園催</TD>
<TD>僥伏廣過兆</TD>
<TD>答個縮弗</TD>
<TD>答個扮寂</TD>
<TD>恬匍誼蛍</TD>
<TD>縮弗得囂</TD>
</TR>
<%
while (rs.next())
{
%>
<TR bgcolor=SkyBlue>
<TD><%= rs.getString("HomeworkID") %></TD>
<TD>
<% String theme = rs.getString("StuName"); %>
<%=theme%>
</TD>
<TD><%= rs.getString("JudgePerson") %></TD>
<TD><%= rs.getString("JudgeDate") %></TD>
<TD><%= rs.getString("StuScore") %></TD>
<TD><%= rs.getString("TeacherRe") %></TD>
</TR>
<%
}
rs.close(); //購液芝村鹿
stmt.close(); //購液Statement斤・
conDB.close(); //購液方象垂全俊
%>
</TABLE>
<br>
</FORM>
</BODY>
</HTML>
在tools菜单-------〉Exterprise Setup 中找到相关的驱动位置,添加到 JB中(如果没有,就要新建了 Database Driver-----add----new---....)这时就可以用了