JSPæ°æ®åºè®¿é®ä¸èµ·ä½ç¨
问题描述：
我想检索一个jsp页é¢ä¸çš„mysqlæ•°æ®ã€‚我é¢ä¸´çš„问题是检索值没有得到打å°ã€‚ä½†æ˜¯ï¼Œä½ å¥½æ˜¯æ ¹æ®è¡¨ä¸çš„行数æ£ç¡®æ‰“å°JSPæ•°æ®åº“访问ä¸èµ·ä½œç”¨
的代ç 是
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>Hello World!</h1>
<%@page import="java.sql.*,javax.servlet.*,javax.sql.*" %>
<%
//Register JDBC driver
Class.forName("com.mysql.jdbc.Driver");
//Open a connection
Connection conn=null;
conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost/quiz","root","root");
// Execute SQL query
Statement stmt = conn.createStatement();
String sql="select Question_Id,Question from question_master;";
out.println(sql);
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
out.println("hello");
int id=rs.getInt("Question_Id");
String ques=rs.getString("Question");
System.out.println("ID: " + id + "<br>");
System.out.println("Question " + ques+ "<br>");
}
%>
</body>
</html>
答
çš„é—®é¢˜æ˜¯ä½ å†™
System.out.println("ID: " + id + "<br>");
System.out.println("Question " + ques+ "<br>");
将在æœåŠ¡å™¨æŽ§åˆ¶å°æ‰“å°
ä½ å¿…é¡»å†™
out.println("ID: " + id + "<br>");
out.println("Question " + ques+ "<br>");
打å°åœ¨jsp页é¢
谢谢è€å…„ï¼è¿™æ˜¯ä¸€ä¸ªæ„šè ¢çš„错误没有注æ„到 – user305774 2015-03-13 16:14:09