JDBC连接oracle10g - J2EE论坛 - JAVA论坛

问题点数：0 回复次数：0

JDBC连接oracle10g

我们实验室，web服务器和database服务器是分开的。我的JDBC连接步骤，在oracle的安装目录下找到classes.jar放在resin的lib目录下（我们的web用的resin的服务器。又在oracle的安装目录下找到jdk14.jar放在jdk的lib目录下。
然后写了一段代码
<%@ page contentType = "text/html; charset = gb2312"  import ="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
  <head>
    <base href="<%=basePath%>">

    <title>My JSP 'MyJsp.jsp' starting page</title>

    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    

  </head>

  <body>
    <%
Class. forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url ="jdbc:oracle:thin:@172.16.9.196:1521:BIOINFG";
String username ="GN";
String password ="micrarray"
Connection con = DriverManager.getConnection(url,username,password);
Statement stme =con.creatStatement(ResultSet.TYPE_SCROLL_INSENSTIVE, ResultSet.CONCUR_READ_ONLY)；
String sql = “select * from student":
ResultSet rs = stme.executeQuery(sql);
while(rs.next()){
System.out.println("数据库服务器连接成功。”）；
%>

  </body>
</html>
但是系统给出了这样的报错信息：
500 Servlet Exception

[show] /JDBC1.jsp:1: expected '%>' at '"'.  JSP directive syntax is '<%@ name
attr1='value1' ... %>'.  (Started at line 1)

1:  <%@ page contentType = "text/html; charset = gb2312" import"java.sql.*"%>
2:  <%
3:  String path = request.getContextPath();

我不太清楚这是怎么回事，希望老师指导一下。

搜索更多相关主题的帖子: JDBC　