JSP连接SQLserver问题

[weeksun23]

连接代码：
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLserverDriver");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=BBSmessage","sa","013018");
Statement stmt = conn.createStatement();
int rtn = stmt.executeUpdate("insert into Table_1 (Author,Title,Text) values('df','er','dfgdfgertewr')");
stmt.close();
conn.close();

sqljdbc.jar包导入了 TCP端口设置了 运行还是不成功。。。。。什么原因？？求解释！我用的是MyEclipse
错误：
org.apache.jasper.JasperException: An exception occurred processing JSP page /write_deal.jsp at line 48
line 48：
Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=BBSmessage","sa","013018");

[runer]

把完整的错误栈贴出来

[叶涛网站推广优化]

BBSmessage 这个库有吗

[weeksun23]

[Quote=引用 1 楼 runer 的回复:]
把完整的错误栈贴出来
[/Quote]
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

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 /write_deal.jsp at line 48

45: }
46: // Connection conn= DriverManager.getConnection ("jdbc:sqlserver://localhost;DatabaseName=BBSmessage;user=sa;password=");
47:
48: Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=BBSmessage","sa","013018");
49: Statement stmt = conn.createStatement();
50: int rtn = stmt.executeUpdate("insert into Table_1 (Author,Title,Text) values('df','er','dfgdfgertewr')");
51: stmt.close();


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:551)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:440)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)


root cause

javax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;DatabaseName=BBSmessage
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:915)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:844)
org.apache.jsp.write_005fdeal_jsp._jspService(write_005fdeal_jsp.java:135)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)


root cause

java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;DatabaseName=BBSmessage
java.sql.DriverManager.getConnection(DriverManager.java:602)
java.sql.DriverManager.getConnection(DriverManager.java:185)
org.apache.jsp.write_005fdeal_jsp._jspService(write_005fdeal_jsp.java:121)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)


note The full stack trace of the root cause is available in the Apache Tomcat/7.0.8 logs.

[weeksun23]

[Quote=引用 2 楼 yetaodiao 的回复:]
BBSmessage 这个库有吗
[/Quote]
当然有

[lijian8552]

你的Sql server是什么版本？如果是2000，得装sp3补丁
安装时有没有选择混合模式？
数据库连接的密码是否正确？

[zhangsf1982]

[Quote=引用 5 楼 lijian8552 的回复:]
你的Sql server是什么版本？如果是2000，得装sp3补丁
[/Quote]

可能是问题所在

[fyg0072]

javax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;DatabaseName=BBSmessage


没有驱动，或者驱动有问题。