求助conn = DriverManager.getConnection(url, name, pwd);错误

deng231520 2018-03-24 10:19:12

本人刚学jsp，学到连接数据库，可是一直出现问题，我照着资料写的，一直提示这儿有错

大神帮忙看看，谢谢了

这是jsp链接SQL server 2008 r2 的（错误的）我下面还有一个链接Oracle的（成功链接上了！）

这是错误信息：
type Exception report

message An exception occurred processing JSP page /jdbc_sql.jsp at line 25

description The server encountered an internal error that prevented it from fulfilling this request.

exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /jdbc_sql.jsp at line 25

22:
23: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
24: //Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
25: conn = DriverManager.getConnection(url, name, pwd);
26: stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
27: rs = stmt.executeQuery(sql);
28: /*if(rs!=null )

下面是我的代码：



<%@ page language="java" contentType="text/html; charset=UTF-8"

	pageEncoding="UTF-8"%>

<%@  page import="java.sql.*"%>

<%@ page import="java.io.*"%>

<%@ page import="java.util.*"%>



<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>Insert title here</title>

</head>

<body>

	<%

		Connection conn = null;

		String sql = "select * from information";

		String url = "jdbc:sqlserver://localhost:1433;DatabaseName=users";

		String name = "sa";

		String pwd = "231520";

		ResultSet rs = null;

		Statement stmt = null;



		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

		//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

		conn = DriverManager.getConnection(url, name, pwd);

		stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

		rs = stmt.executeQuery(sql);

		/*if(rs!=null )

		{

		String strnum = Integer.toString(rs.getRow());

		out.println(strnum);

		rs.first();

		}*/

		while (rs.next()) {

	%>

	<table>

		<%=rs.getString(1)%>

		<%=rs.getString(2)%>

		<%=rs.getString(3)%>

		<%=rs.getString(4)%>

		<%=rs.getString(5)%>

	</table>

	<%

		}

	%>

	<%

		out.print("\n\n\n数据库操作成功，恭喜你");

	%>

	<%

		rs.close();

		stmt.close();

		conn.close();

	%>





</body>

</html>

以下是对的（链接Oracle数据库的）代码：





<%@ page language="java" contentType="text/html; charset=UTF-8"

	pageEncoding="UTF-8"%>

<%@  page import="java.sql.*"%>

<%@ page import="java.io.*"%>

<%@ page import="java.util.*"%>



<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>Insert title here</title>

</head>

<body>

	<%

		Connection conn = null;

		String sql = "select * from KINGS";

		String url = "jdbc:oracle:thin:@localhost:1521:Orcl";

		String user = "system";

		String pwd = "231520";

		ResultSet rs = null;

		Statement stmt = null;



		Class.forName("oracle.jdbc.driver.OracleDriver");

		conn = DriverManager.getConnection(url, user, pwd);

		stmt = conn.createStatement();

		rs = stmt.executeQuery(sql);

		/*if(rs!=null )

		{

		String strnum = Integer.toString(rs.getRow());

		out.println(strnum);

		rs.first();

		}*/

		while (rs.next()) {

	%>

	<table>

		<%=rs.getString(1)%>

		<%=rs.getString(2)%>

		<%=rs.getString(3)%>

		<%=rs.getString(4)%>

		<%=rs.getString(5)%>

	</table>

	<%

		}

	%>

	<%

		out.print("\n\n\n数据库操作成功，恭喜你");

	%>

	<%

		rs.close();

		stmt.close();

		conn.close();

	%>





</body>

</html>