连接时总是报如下的异常,不知道是哪里出了问题,希望大家帮忙指导一下,谢谢了at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:494)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:474)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at webbook.chapter5.JDBCExample.main(JDBCExample.java:18)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:494)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:474)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at webbook.chapter5.JDBCExample.main(JDBCExample.java:18)
楼主【soukeiki】截止到2008-06-23 18:52:26的历史汇总数据(不包括此帖):
发帖数:2 发帖分:160
结贴数:0 结贴分:0
未结数:2 未结分:160
结贴率:0.00 % 结分率:0.00 %
如何结贴请参考这里:http://topic.csdn.net/u/20080501/09/ef7ba1b3-6466-49f6-9d92-36fe6d471dd1.html
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;public class JDBCExample { public static void main(String[] args) {
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@220.109.210.70:1521:tenkin";
String username = "RELO_DBA";
String password = "RELO_DBA";
String sql = "insert into users (USERNAME,PASSWORD) values(?,?)";
Connection conn = null;
try{
Class.forName(driver);
conn = DriverManager.getConnection(url, username, password);
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "gggggg");
pstmt.setString(2, "gggg");
pstmt.executeUpdate();
pstmt.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
<%//先导入classes12.jar包,大小为1169KB%>
<html>
<body>
<TABLE border=1>
<%
//此例测试oracle数据库连接
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:ACCP"; //orcl为你的数据库的SID
String user = "scott";
String password = "tiger";
Connection conn = DriverManager.getConnection(url, user, password);
//Statement stmt = conn.createStatement();
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String sql = "select * from emp";
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rmd = rs.getMetaData();
int columncount = rmd.getColumnCount();
while (rs.next()) {
%>
<TR>
<%
for (int i = 1; i <= columncount; i++) {
out.print("<TD>" + rs.getString(i) + " </TD>");
}
%>
</TR>
<%
}
rs.close();
stmt.close();
conn.close();
} catch (Exception ex) {
}
%>
</TABLE>
</body>
</html>上面的代码是可以运行的, 楼主注意导入class12包,我用的是oracle9i
不过 关闭数据库连接 最好放在 finally 里面。这样可以防止 如果关闭数据库连接前出错不会关闭的情况。