哎 最近老是问这些基础问题 我快被气死了!!!
好久没用这些了 现在突然一写 错误不断大家给看看吧 很简单的JSP连接数据库然后循环除内容
驱动包肯定架对了
这是代码
<%@ page language="java" import="java.sql.*" pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<%
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=stu","sa","123456");
}catch(Exception e){}
%>
<%
try{
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM products";
ResultSet rs = stmt.executeQuery(sql);
}catch(Exception e){}
if(rs.next()){
%>
<%=rs.getInt(1)%><br>
<%=rs.getString(2)%><br>
<%=rs.getString(3)%><br>
<%=rs.getString(4)%><br>
<%}
%>
</body>
</html>
运行以后老是这个错误 也忘了这个错误是什么了。。
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 13 in the jsp file: /page.jsp
Generated servlet error:
conn cannot be resolvedAn error occurred at line: 21 in the jsp file: /page.jsp
Generated servlet error:
conn cannot be resolvedAn error occurred at line: 21 in the jsp file: /page.jsp
Generated servlet error:
rs cannot be resolvedAn error occurred at line: 32 in the jsp file: /page.jsp
Generated servlet error:
rs cannot be resolvedAn error occurred at line: 33 in the jsp file: /page.jsp
Generated servlet error:
rs cannot be resolvedAn error occurred at line: 34 in the jsp file: /page.jsp
Generated servlet error:
rs cannot be resolvedAn error occurred at line: 35 in the jsp file: /page.jsp
Generated servlet error:
rs cannot be resolved
麻烦大家给我说说那错了。。哎。。这种问题 真想把机子给砸了。。如果不是我自己的机子的话
好久没用这些了 现在突然一写 错误不断大家给看看吧 很简单的JSP连接数据库然后循环除内容
驱动包肯定架对了
这是代码
<%@ page language="java" import="java.sql.*" pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<%
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=stu","sa","123456");
}catch(Exception e){}
%>
<%
try{
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM products";
ResultSet rs = stmt.executeQuery(sql);
}catch(Exception e){}
if(rs.next()){
%>
<%=rs.getInt(1)%><br>
<%=rs.getString(2)%><br>
<%=rs.getString(3)%><br>
<%=rs.getString(4)%><br>
<%}
%>
</body>
</html>
运行以后老是这个错误 也忘了这个错误是什么了。。
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 13 in the jsp file: /page.jsp
Generated servlet error:
conn cannot be resolvedAn error occurred at line: 21 in the jsp file: /page.jsp
Generated servlet error:
conn cannot be resolvedAn error occurred at line: 21 in the jsp file: /page.jsp
Generated servlet error:
rs cannot be resolvedAn error occurred at line: 32 in the jsp file: /page.jsp
Generated servlet error:
rs cannot be resolvedAn error occurred at line: 33 in the jsp file: /page.jsp
Generated servlet error:
rs cannot be resolvedAn error occurred at line: 34 in the jsp file: /page.jsp
Generated servlet error:
rs cannot be resolvedAn error occurred at line: 35 in the jsp file: /page.jsp
Generated servlet error:
rs cannot be resolved
麻烦大家给我说说那错了。。哎。。这种问题 真想把机子给砸了。。如果不是我自己的机子的话
解决方案 »
- 打算做网站,哪位高手提供成熟的CMS系统模板参考
- 动态添加多级文本行
- 类似这种开头的加密密文,是采用什么方式加的密???
- org.apache.catalina.core.StandardWrapperValve invoke 异常
- mysql中文字符模糊查询问题
- 【着急,在线等】java数据库查询问题
- 怎么给APPLET传递参数.
- 请教--关于Struts防止重复提交问题
- 在Weblogic中发布我的javaBeans,如何才能热发布,我现下每次修改JavaBeans都要重起Weblogic!
- 用<input type="fiel" name="test">时,怎样判断输进去的文件是硬盘上实际存在的?
- 如何设置eclipse找出相关文字
- 几个WEB系统,想请大家来评论下.在线测试使用.准备面试用的.
rs 既然在try里面生命的,为什么在外面还在用
....
改成while(rs.next())...
最好把完整的发上来
仅仅这么一点点,很难判断
{
}