<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %>
<%!
String url = "jdbc:oracle:@localhost:1521:orclsid";
String user = "scott";
String password = "password";
String sql = "CREATE TABLE testJsp (userName varchar(20))";
%>
<body bgcolor=pink>
<font size=2>
<%
Connection con = null;
Statement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url,user,password);
stmt = con.createStatement();
stmt.executeUpdate(sql);
}
catch(Exception e) {
e.getStackTrace();
}
finally {
try {
if(stmt != null) {
stmt.close();
stmt = null;
}
if(con != null) {
con.close();
con = null;
}
} catch(SQLException e) {
e.getStackTrace();
}
}
%>
</font>
</body>
</html>说明,此段代码能够正常运行,在浏览器中能够运行正常..
但是却不能够创建表,在运行完成此段程序后,我用oracle SQL*PLUS进行测试,但是还是没有看见表testJsp产生?????????? 进行测试的命令是:desc testJsp请知道者回复下,谢谢.....
<%@ page import="java.sql.*" %>
<%!
String url = "jdbc:oracle:@localhost:1521:orclsid";
String user = "scott";
String password = "password";
String sql = "CREATE TABLE testJsp (userName varchar(20))";
%>
<body bgcolor=pink>
<font size=2>
<%
Connection con = null;
Statement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url,user,password);
stmt = con.createStatement();
stmt.executeUpdate(sql);
}
catch(Exception e) {
e.getStackTrace();
}
finally {
try {
if(stmt != null) {
stmt.close();
stmt = null;
}
if(con != null) {
con.close();
con = null;
}
} catch(SQLException e) {
e.getStackTrace();
}
}
%>
</font>
</body>
</html>说明,此段代码能够正常运行,在浏览器中能够运行正常..
但是却不能够创建表,在运行完成此段程序后,我用oracle SQL*PLUS进行测试,但是还是没有看见表testJsp产生?????????? 进行测试的命令是:desc testJsp请知道者回复下,谢谢.....
e.getStackTrace();
}
=〉
} catch(SQLException e) {
e.printStackTrace();
}然后在控制台看输出吧!
<%@ page import="java.sql.*" %>
<%!
String url = "jdbc:oracle:@localhost:1521:orclsid";
String user = "scott";
String password = "password";
String sql = "CREATE TABLE testJsp (userName varchar(20))";
%>
<body bgcolor=pink>
<font size=2>
<%
Connection con = null;
Statement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url,user,password);
stmt = con.createStatement();
stmt.executeUpdate(sql);
}
catch(ClassNotFoundException e) {
e.getStackTrace();
} catch(SQLException e) {
e.getStackTrace();
}
finally {
try {
if(stmt != null) {
stmt.close();
stmt = null;
}
if(con != null) {
con.close();
con = null;
}
} catch(SQLException e) {
e.getStackTrace();
}
}
%>
</font>
</body>
</html> 同样没有出现表testJsp????
工程名:testJSP,端口号是:8088浏览器中什么也没有,我只是想在数据库 中创建一个表,并没有往浏览器中输入东西,...是否创建成功,不在isql*plus中查,那在哪里查是否创建了这个testJsp表呢??????
ERROR:
ORA-04043: 对象 testJsp 不存在
String url = "jdbc:oracle:@localhost:1521:orclsid"; 改为:String url = "jdbc:oracle:thin:@localhost:1521:orclsid";表testJsp出现!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
哈哈哈哈哈哈,谢谢大家了,写代码确实需要用心,小心啊........