我在自学jsp,在看到连接数据库时,自己动手连接下,就是连接不上,流浪器提示如下:
org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 11 in the jsp file: /jsp/4.jsp
Duplicate local variable con
8: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
9:
10:
11: Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433/jsp;DatabaseName=test","sa","123456");
12: sql=con.createStatement();
13: rs=sql.executeQuery("SELECT * FROM student");
14: out.print("<Table Border>");代码如下:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<% Connection con;
Statement sql;
ResultSet rs;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433/jsp;DatabaseName=test","sa","123456");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM student");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+" 学号");
out.print("<TH width=100>"+" 姓名");
out.print("<TH width=50>"+" 数学成绩");
out.print("<TH width=50>"+" 英语成绩");
out.print("<TH width=50>"+" 物理成绩");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
out.print("<TD >"+rs.getString(1)+"</TD>");
out.print("<TD >"+rs.getString(2)+"</TD>");
out.print("<TD >"+rs.getInt(" 数学成绩")+"</TD>");
out.print("<TD >"+rs.getInt(" 英语成绩")+"</TD>");
out.print("<TD >"+rs.getInt(" 物理成绩")+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
%></BODY>
</HTML>jsp数据库
org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 11 in the jsp file: /jsp/4.jsp
Duplicate local variable con
8: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
9:
10:
11: Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433/jsp;DatabaseName=test","sa","123456");
12: sql=con.createStatement();
13: rs=sql.executeQuery("SELECT * FROM student");
14: out.print("<Table Border>");代码如下:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<% Connection con;
Statement sql;
ResultSet rs;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433/jsp;DatabaseName=test","sa","123456");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM student");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+" 学号");
out.print("<TH width=100>"+" 姓名");
out.print("<TH width=50>"+" 数学成绩");
out.print("<TH width=50>"+" 英语成绩");
out.print("<TH width=50>"+" 物理成绩");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
out.print("<TD >"+rs.getString(1)+"</TD>");
out.print("<TD >"+rs.getString(2)+"</TD>");
out.print("<TD >"+rs.getInt(" 数学成绩")+"</TD>");
out.print("<TD >"+rs.getInt(" 英语成绩")+"</TD>");
out.print("<TD >"+rs.getInt(" 物理成绩")+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
%></BODY>
</HTML>jsp数据库
解决方案 »
- /petrosyscn/eventdeliver?eventID=11148&basetype=Regional Geology@Report&logid= 解释下这句话~
- javax.servlet.ServletException: Communication failure during handshake. Is there a server running on 127.0.01:3306?
- inclue 的问题,大家帮我看看,谢谢
- 研究连接池的时候,报错,请各位兄弟们指点指点。。。
- Struts应用示例
- oracle树形查询如何在java中做成map
- JSP操作SQL的问题.(简单)
- 新手提问:jsp中无法调用bean(急,在线等待...)
- 数据库连接
- 我的环境总是有问题,请问怎么解决?
- 现在通过mysql的jdbc访问数据库,为什么用中文账号登陆不了
- 想学习搭建框架改如何入手?(新手学习)
把
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433/jsp;DatabaseName=test","sa","123456");
改成
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433/jsp;DatabaseName=test","sa","123456");
就可以了
<% Connection con;
Statement sql;
ResultSet rs;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433/jsp;DatabaseName=test","sa","123456");
6: Statement sql;
7: ResultSet rs;
8: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
9:
10:
11: con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433/jsp;DatabaseName=test","sa","123456");
后面又出现了这个问题,请问这个是为什么? 代码我是拿过来,自己修改了下了的,不知道有没有问题