<%@ page contentType = "text/html" pageEncoding = "GBK"%>
<%@ page import = "java.sql.*"%>
<html>
<head> <title>MyFirstJSP</title></head>
<body>
<%!
public static final String driver = "com.mysql.jdbc.Driver";
public static final String url = "jdbc:mysql://localhost:8080/mldn";
public static final String user = "root";
public static final String password = "mysql";
%>
<%
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
%>
<%
try
{
Class.forName(driver);
conn = DriverManager.getConnection(url,user,password);
String sql = "select empno,ename,job,sal,hiredate from emp";
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
%>
<center>
<table border = "1" width = "80%">
<tr>
<td>雇员编号</td>
<td>雇员姓名</td>
<td>雇员工作</td>
<td>雇员工资</td>
<td>雇佣日期</td>
</tr>
<%
while(rs.next())
{
int empno = rs.getInt(1);
String ename = rs.getString(2);
String job = rs.getString(3);
float sal = rs.getFloat(4);
java.util.Date date = rs.getDate(5);
%>
<tr>
<td><%=empno%></td>
<td><%=ename%></td>
<td><%=job%></td>
<td><%=sal%></td>
<td><%=date%></td>
</tr>
<%
}
%>
</table>
</center>
<%
}
catch(Exception e){
System.out.println(e);
}finally{
rs.close();
pstmt.close();
conn.close();
}
%>
</body>
</html>
<%@ page import = "java.sql.*"%>
<html>
<head> <title>MyFirstJSP</title></head>
<body>
<%!
public static final String driver = "com.mysql.jdbc.Driver";
public static final String url = "jdbc:mysql://localhost:8080/mldn";
public static final String user = "root";
public static final String password = "mysql";
%>
<%
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
%>
<%
try
{
Class.forName(driver);
conn = DriverManager.getConnection(url,user,password);
String sql = "select empno,ename,job,sal,hiredate from emp";
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
%>
<center>
<table border = "1" width = "80%">
<tr>
<td>雇员编号</td>
<td>雇员姓名</td>
<td>雇员工作</td>
<td>雇员工资</td>
<td>雇佣日期</td>
</tr>
<%
while(rs.next())
{
int empno = rs.getInt(1);
String ename = rs.getString(2);
String job = rs.getString(3);
float sal = rs.getFloat(4);
java.util.Date date = rs.getDate(5);
%>
<tr>
<td><%=empno%></td>
<td><%=ename%></td>
<td><%=job%></td>
<td><%=sal%></td>
<td><%=date%></td>
</tr>
<%
}
%>
</table>
</center>
<%
}
catch(Exception e){
System.out.println(e);
}finally{
rs.close();
pstmt.close();
conn.close();
}
%>
</body>
</html>
解决方案 »
- extjs去除按钮的位置
- jodconverter转换包含标签的像<span>格式转化为pdf 转换不出pdf文件
- 无法写入cookie...
- 我的jsp页面都用gbk时正常,可是把gbk全部改为utf-8后,页面就全是乱码,(我没有用到数据库),怎么回事?
- 一个加密与解密问题,看你能不能解密出来!!!
- 求助:applet与jsp页面传递数据
- 请假一个传值问题!!!!
- servlet的稳定性问题
- 求,从oracle或者sqlserver Blob字段中读取内容代码;把一个文件插入Blob得代码
- JSP一定要有虚拟站点才能访问,才能得出结果吗??
- 请问在Spring中,如何获取Bean 的id或者name呢?
- 做java web 学SQL的问题
String ename = rs.getString(2);
String job = rs.getString(3);
float sal = rs.getFloat(4);
java.util.Date date = rs.getDate(5);
%>
<tr>
<td><%=empno%></td>
<td><%=ename%></td>
<td><%=job%></td>
<td><%=sal%></td>
<td><%=date%></td>
</tr>
你的, int empno 定义在 while(rs.next())块里面,以前学习的时候,好像遇到过,所以下面块外面,就没法获取到这个值,改成这样看看
int empno=0;
String ename =null;
String job=null;
java.util.Date date =null;
<%
while(rs.next())
{
empno = rs.getInt(1);
ename = rs.getString(2);
job = rs.getString(3);
sal = rs.getFloat(4);
date = rs.getDate(5);
%>
69:
70:
71: rs.close();
72: pstmt.close();
73: conn.close();
74:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause java.lang.NullPointerException
org.apache.jsp.list_005femp_jsp._jspService(list_005femp_jsp.java:154)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.30 logs.
public static final String url = "jdbc:mysql://localhost:3306/mldn";