望高手不要见笑,好象有些语法错误!
我改正了一点点!
现在的code :
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import= "java.sql.* "% >
<%jsp:useBean id="dbcon" scope="page" class= "dbopen.DBconn"% />
<html>
<body>
以下是从Oracle数据库读取的数据:<hr>
<table border=1>
<tr><td>id</td><td>书名</td><td>出版社</td><td>价格</td></tr>
<%
ResultSet rs=stmt.executeQuery("select * from book");
while(rs.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("BOOKID")+"</td>");
out.println("<td>"+rst.getString("bookname")+"</td>");
out.println("<td>"+rst.getString("publisher")+"</td>");
out.println("<td>"+rst.getFloat("price")+"</td>");
out.println("</tr>");
}
//关闭连接、释放资源
rst.close();
stmt.close();
con.close();
%>
</table>
</body>
</html>错误:org.apache.jasper.JasperException: /test.jsp(3,0) Unterminated <%@ page tag
谢谢!!
我改正了一点点!
现在的code :
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import= "java.sql.* "% >
<%jsp:useBean id="dbcon" scope="page" class= "dbopen.DBconn"% />
<html>
<body>
以下是从Oracle数据库读取的数据:<hr>
<table border=1>
<tr><td>id</td><td>书名</td><td>出版社</td><td>价格</td></tr>
<%
ResultSet rs=stmt.executeQuery("select * from book");
while(rs.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("BOOKID")+"</td>");
out.println("<td>"+rst.getString("bookname")+"</td>");
out.println("<td>"+rst.getString("publisher")+"</td>");
out.println("<td>"+rst.getFloat("price")+"</td>");
out.println("</tr>");
}
//关闭连接、释放资源
rst.close();
stmt.close();
con.close();
%>
</table>
</body>
</html>错误:org.apache.jasper.JasperException: /test.jsp(3,0) Unterminated <%@ page tag
谢谢!!
package opendb;//javabean名
import java.sql.*;
import javax.naming.*;
public class DBconn {
java.sql.Connection Conn = null;
javax.sql.DataSource ds = null;
java.sql.ResultSet rs = null;
public DBconn() {
try{
Class.forName( "oracle.jdbc.driver.OracleDriver ").newInstance();
String url= "jdbc:oracle:thin:@10.2.79.188:1521:xbh";
String user= "jspdev";
String password= "6716012";
Conn= DriverManager.getConnection(url,user,password);
}catch(Exception e) {
Conn = null;
System.out.print( "Error To Create Connection ");
}
}
public ResultSet executeQuery(String sql) {
rs=null;
try {
Statement stmt=Conn.createStatement();
rs=stmt.executeQuery(sql);
} catch (SQLException ex) {
Conn = null ;
rs = null;
System.err.println( "aq.execute-Query: "+ex.getMessage());
}
return rs;
}
}
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import= "java.sql.* "% >
改成
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import= "java.sql.* "% >
改成
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
2、
<%jsp:useBean id="dbcon" scope="page" class= "dbopen.DBconn"% />
改成
<%jsp:useBean id="dbcon" scope="page" class= "opendb.DBconn"% />
3、
在bean中还得写关闭数据库的操作,这是很重要的!
rs.close();
stmt.close();
conn.close();
没看到你在jsp中写了关闭数据库的操作
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error, insert "AssignmentOperator ArrayInitializer" to complete ArrayInitializerAssignementAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error, insert ";" to complete StatementAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error, insert ";" to complete StatementAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "class", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on tokens, Expression expected insteadAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "Invalid Character", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token(s), misplaced construct(s)An error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error, insert ";" to complete StatementAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "/", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "/", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "/", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "/", delete this tokenAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 4 in the jsp file: /test.jsp
Generated servlet error:
Syntax error, insert ";" to complete Statement
麻烦了!!
这样对么??
package opendb;//javabean名
import java.sql.*;
import javax.naming.*;
public class DBconn {
java.sql.Connection Conn = null;
javax.sql.DataSource ds = null;
java.sql.ResultSet rs = null;
public DBconn() {
try{
Class.forName( "oracle.jdbc.driver.OracleDriver ").newInstance();
String url= "jdbc:oracle:thin:@10.2.79.188:1521:xbh";
String user= "jspdev";
String password= "6716012";
Conn= DriverManager.getConnection(url,user,password);
}catch(Exception e) {
Conn = null;
System.out.print( "Error To Create Connection ");
}
}
public ResultSet executeQuery(String sql) {
rs=null;
try {
Statement stmt=Conn.createStatement();
rs=stmt.executeQuery(sql);
} catch (SQLException ex) {
Conn = null ;
rs = null;
System.err.println( "aq.execute-Query: "+ex.getMessage());
}
return rs;
}
rs.close();
stmt.close();
conn.close();
}
就错在关闭数据库的操作那!
谢谢啊!