为什么这个程序老是报内部服务器出错呢?有知道的吗?
lzedu 2003-04-08 07:35:15 <%-- 留言本程序文件 gb.jsp --%>
<%@ page contentType="text/html; charset=gb2312" %>
<HTML><BODY bgcolor="#FFFFFF" text="#0000C0">
<FORM method="POST" action=gb.jsp>
<INPUT type="text" name="name" size="21" value="姓名和留言" onFocus="this.value=''">
<BR><TEXTAREA rows="4" name="content" cols="20"></TEXTAREA>
<INPUT type="submit" value="提交">
</FORM>
<%
// 初始化
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
java.sql.Connection sqlConn
=java.sql.DriverManager.getConnection("jdbc:oracle:thin:@10.1.1.139:1521:lztest","system","manager");
java.sql.Statement sqlStmt = sqlConn.createStatement();
// 写入数据
sqlStmt.executeUpdate("insert into gb(name,content,time)"
+ "values('" + request.getParameter("name")+ "','" + request.getParameter("content")
+ "','" + new java.util.Date() + "');"
);
// 读取数据
java.sql.ResultSet sqlRst = sqlStmt.executeQuery("select * from gb;");
while (sqlRst.next()) {
out.println("<B STYLE='FONT-SIZE:9pt'>" + sqlRst.getString("name")
+ ":</B><FONT STYLE='FONT-SIZE:9pt;COLOR:#C00000'> " + sqlRst.getString("content")
+ "</FONT><FONT STYLE='FONT-SIZE:9pt;COLOR:#CCCCCC'> @ " + sqlRst.getString("time")
+ "</FONT><BR>");
}
sqlStmt.close();
sqlConn.close();
%>
</body></html>