大家好,我是JSP新手,请大家帮忙看一下以下代码哪里有错,谢谢
<%@ page import="java.sql.*" contentType="text/html;charset=gb2312" %>
<%
out.println("从这里开始是正确的<br>");
%>
<%
String url="jdbc:odbc:LBSource";
String username="LUser";
String password="2222222";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e)
{
out.println("some wrong have happen in forname");
}
try
{
Connection con=DriverManager.getConnection(url,username,password);
}
catch(Exception e)
{
out.println("some wrong have happen in getconnection");
}
try
{
Statement stm=con.createStatement();
}
catch(Exception e)
{
out.println("some wrong have happen in createstatement");
con.close();
}
try
{
String sql="select * from book_table where bookid>3";
ResultSet rs=stm.executeQuery(sql);
}
catch(Exception e)
{
out.println("some wrong have happen in executequer");
stm.close();
con.close();
}
%>
<%
out.println("<br>如果你能看到这里,就那行了");
%>运行的时候出错提示如下
An error occurred at line: 5 in the jsp file: /connect.jsp
Generated servlet error:
con cannot be resolved
<%@ page import="java.sql.*" contentType="text/html;charset=gb2312" %>
<%
out.println("从这里开始是正确的<br>");
%>
<%
String url="jdbc:odbc:LBSource";
String username="LUser";
String password="2222222";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e)
{
out.println("some wrong have happen in forname");
}
try
{
Connection con=DriverManager.getConnection(url,username,password);
}
catch(Exception e)
{
out.println("some wrong have happen in getconnection");
}
try
{
Statement stm=con.createStatement();
}
catch(Exception e)
{
out.println("some wrong have happen in createstatement");
con.close();
}
try
{
String sql="select * from book_table where bookid>3";
ResultSet rs=stm.executeQuery(sql);
}
catch(Exception e)
{
out.println("some wrong have happen in executequer");
stm.close();
con.close();
}
%>
<%
out.println("<br>如果你能看到这里,就那行了");
%>运行的时候出错提示如下
An error occurred at line: 5 in the jsp file: /connect.jsp
Generated servlet error:
con cannot be resolved
解决方案 »
- java 项目连接数据库问题
- 用Java实现网站的自动登录,有挑战性,高手来
- 用户登录后的注销问题!!!在线等!!!!
- 怎么写学年论文!!
- 请教j2sdk+apache+tomcat+php开发JSP的配置方法
- 有没有使用过滤器解决jsp中乱码的完整的过程
- 要怎么才可以编译JAVA文件?要在什么环境才可以?新手提问...谢谢..
- 如何配置mysql-connector连接mySql啊
- 怎样调整网页在不同大小或分辨率显示器中的位置?再线等待!
- 关于从数据库取下来菜单,以及取到之后如何替换真实的值
- tomcat数据库连接
- 求助:servlet运行时出现的问题 HTTP method GET is not supported by this URL
你在一个{}中定义con,再别的{}调用con,因此出错了吧.