sql server 2008 jdbc 驱动连接出有关问题
日期：2014-05-17 浏览次数：20850 次
sql server 2008 jdbc 驱动连接出问题
sql server 2008 jdbc驱动包连接了，但是还是跳出这样的问题，为什么啊？
<%@ page language="java" contentType="text/html; charset=gbk"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!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=gbk">
<title>Insert title here</title>
</head>
<body>
<%
//接受数据
String u=request.getParameter("username");
String p=request.getParameter("password");
//到数据库验证
//加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//数据库连接对象
Connection ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Login","sa","19930821");
//sql语句对象
Statement stmt=ct.createStatement();
//查询
ResultSet rs=stmt.executeQuery("selest password from User where userName='"+u+"'");
//根据结果判断
if(rs.next())
{
//如果能进到这里面，说明用户名存在
if(rs.getString(1).equals(p))
{
//一定合法
response.sendRedirect("welcome.jsp?user="+u);
}
else
{
//密码错误
response.sendRedirect("login.jsp?error=1");
}
}
else
{
//用户名不存在
response.sendRedirect("login.jsp?error=2");
}
%>
</body>
</html>
---------------------------------------------
HTTP Status 500 - javax.servlet.ServletException: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
--------------------------------------------
type Exception report
message javax.servlet.ServletException: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)
org.apache.jasper.ser
sql server 2008 jdbc驱动包连接了，但是还是跳出这样的问题，为什么啊？
<%@ page language="java" contentType="text/html; charset=gbk"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!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=gbk">
<title>Insert title here</title>
</head>
<body>
<%
//接受数据
String u=request.getParameter("username");
String p=request.getParameter("password");
//到数据库验证
//加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//数据库连接对象
Connection ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Login","sa","19930821");
//sql语句对象
Statement stmt=ct.createStatement();
//查询
ResultSet rs=stmt.executeQuery("selest password from User where userName='"+u+"'");
//根据结果判断
if(rs.next())
{
//如果能进到这里面，说明用户名存在
if(rs.getString(1).equals(p))
{
//一定合法
response.sendRedirect("welcome.jsp?user="+u);
}
else
{
//密码错误
response.sendRedirect("login.jsp?error=1");
}
}
else
{
//用户名不存在
response.sendRedirect("login.jsp?error=2");
}
%>
</body>
</html>
---------------------------------------------
HTTP Status 500 - javax.servlet.ServletException: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
--------------------------------------------
type Exception report
message javax.servlet.ServletException: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)
org.apache.jasper.ser
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
