每次在运行的运行的时候,都会出错误
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="login" scope="page" class="javafan.conns"/><%ResultSet rs=login.executeQuery("select * from admin");
while(rs.next()){
out.print(rs.getString("username")+" ");
out.print(rs.getString("password")+" ");
out.println("<br>");
}
%>
conns.javapackage javafan;
import java.sql.*;
public class conns {
Connection conn=null;
ResultSet rs;
String user ="sa";
String password ="123";
String sql;
String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=guestbook";
public conns()
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
System.out.println("数据库连接成功!"); }
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库连接失败");
}
}
public ResultSet executeQuery(String sql)throws Exception{
conn = DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
stmt.close();
conn.close();
System.out.println("<br>数据库表打开!");
return rs;
}
}错误提示:exception :org.apache.jasper.JasperException: An exception occurred processing JSP page /C.jsp at line 8Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="login" scope="page" class="javafan.conns"/><%ResultSet rs=login.executeQuery("select * from admin");
while(rs.next()){
out.print(rs.getString("username")+" ");
out.print(rs.getString("password")+" ");
out.println("<br>");
}
%>
conns.javapackage javafan;
import java.sql.*;
public class conns {
Connection conn=null;
ResultSet rs;
String user ="sa";
String password ="123";
String sql;
String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=guestbook";
public conns()
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
System.out.println("数据库连接成功!"); }
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库连接失败");
}
}
public ResultSet executeQuery(String sql)throws Exception{
conn = DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
stmt.close();
conn.close();
System.out.println("<br>数据库表打开!");
return rs;
}
}错误提示:exception :org.apache.jasper.JasperException: An exception occurred processing JSP page /C.jsp at line 8Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
XP系需要打MS SQL补丁.
在命令窗口下运行netstat -an查看1433端口是否打开.
确认数据库驱动包是否导入到项目里
用List取出数据之后再返回页面吧,记得页面import java.util.List哦!