请高手帮忙看看连接sqlserver数据库问题
我是下载了jdbc驱动程序,并且安装了,把msbase mssqlserver msutil这三个文件也放到了tomcat /common/lib
下.而且也放到了WEB-INF\lib下,但是还是不行啊.
以下是我的程序:
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch(Exception e)
{
out.println(e.toString());
System.err.println(e.getMessage());
out.println("name error");
}
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=favor";
错误提示:
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.NullPointerException
org.apache.jsp.entrydeal_jsp._jspService(entrydeal_jsp.java:235)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
问题点数:0、回复次数:1Top
1 楼beixing8122()回复于 2004-12-03 01:40:21 得分 0
刚才少了几行代码:
String user="sa";
String password="zz8122s";
try
{
conn= DriverManager.getConnection(url,user,password);
}
catch(Exception ex)
{
out.println(ex.toString());
System.err.println(ex.getMessage());
out.println("connection error");
}Top




