67,516
社区成员
发帖
与我相关
我的任务
分享JSP高手进来解决一下，两个异常，帮忙指出。。
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"
import="java.sql.*"
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
String s = request.getParameter("start");
Connection conn = null;
Statement st = null;
ResultSet rs = null;
String driverName = "com.mysql.jdbc.Driver";
try {
Class.forName(driverName);
String url = "jdbc:mysql://localhost:3306/jdbc";
conn = DriverManager.getConnection(url, "root", "mysql");
st = conn.createStatement();
String sql = "select eno, ename, sex, inDate from emp limit "+s+", 1";
rs = st.executeQuery(sql);
out.print("<table border=1>");
while (rs.next()) {
out.print("<tr>");
out.print("<td>" + rs.getInt("eno") + "</td>");
out.print("<td>" + rs.getString("ename") + "</td>");
out.print("<td>" + rs.getString("sex") + "</td>");
out.print("<td>" + rs.getDate("inDate") + "</td>");
out.print("</tr>");
}
out.print("</table>");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
%>
<a href ="sql.jsp?start=0"> 首页 </a>
<a href ="sql.jsp?start=1"> 尾页 </a>
</body>
</html>
pageEncoding="UTF-8"
import="java.sql.*"
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
String s = request.getParameter("start");
Connection conn = null;
Statement st = null;
ResultSet rs = null;
String driverName = "com.mysql.jdbc.Driver";
try {
Class.forName(driverName);
String url = "jdbc:mysql://localhost:3306/jdbc";
conn = DriverManager.getConnection(url, "root", "mysql");
st = conn.createStatement();
String sql = "select eno, ename, sex, inDate from emp limit "+s+", 1";
rs = st.executeQuery(sql);
out.print("<table border=1>");
while (rs.next()) {
out.print("<tr>");
out.print("<td>" + rs.getInt("eno") + "</td>");
out.print("<td>" + rs.getString("ename") + "</td>");
out.print("<td>" + rs.getString("sex") + "</td>");
out.print("<td>" + rs.getDate("inDate") + "</td>");
out.print("</tr>");
}
out.print("</table>");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
%>
<a href ="sql.jsp?start=0"> 首页 </a>
<a href ="sql.jsp?start=1"> 尾页 </a>
</body>
</html>
...全文
请发表友善的回复…
发表回复
小笨熊 2011-09-14
- 打赏
- 举报
大概看了下，代码没问题哇？？？
sun342115450 2011-09-13
- 打赏
- 举报
搞定了~~不好意思呀
艾小仙 2011-09-13
- 打赏
- 举报
异常在哪里?
