jsp如何连接sql2005?高手看看我这样设置有没有问题?
1、在类中实现连接代码如下:
private static final String DRIVERCLASS = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static final String URL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=db_DrinkeryManage"; private static final String USERNAME = "sa"; private static final String PASSWORD = "123";
2、在SQL Server Configuration Manager中启用TCP/IP,并设置端口为1433
3、把sqljdbc.jar复制到Tomcat 5.5\common\lib中
运行结果出现错误:
description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause java.lang.NullPointerException
com.JDBConnection.executeQuery(JDBConnection.java:56)
org.apache.jsp.index_jsp._jspService(index_jsp.java:77)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
请问这是什么原因?之前这个程序我是用sql2000数据库没问题,现在改用sql2005怎么不行呢?
谢谢!!
1、在类中实现连接代码如下:
private static final String DRIVERCLASS = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static final String URL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=db_DrinkeryManage"; private static final String USERNAME = "sa"; private static final String PASSWORD = "123";
2、在SQL Server Configuration Manager中启用TCP/IP,并设置端口为1433
3、把sqljdbc.jar复制到Tomcat 5.5\common\lib中
运行结果出现错误:
description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause java.lang.NullPointerException
com.JDBConnection.executeQuery(JDBConnection.java:56)
org.apache.jsp.index_jsp._jspService(index_jsp.java:77)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
请问这是什么原因?之前这个程序我是用sql2000数据库没问题,现在改用sql2005怎么不行呢?
谢谢!!
解决方案 »
- 9年前的项目,对其添加一个功能应该,里面的JDK如何控制?各位大哥有什么好的建议吗?
- 知道一个webservice的地址如何用JavaScript来调用它?
- 执行SQL语句的问题
- 请问在JSP<%!%>声明里定义的方法是共享的吗?
- 乱码是否可以转换成中文
- 一个jsp页面中 调用JAVABEAN是不是不能超过五个JAVABEAN。。。。??
- javasript validation framework 运行时错误:配置文件读取错误,请检查。
- 怪现象,请高手帮忙找原因.................
- 有关servlet问题
- 关于localhost和tomcat的问题--在线等
- 连接池的连接类怎么写才好????
- jasperreport+ireport配置问题,在线等.......
再试试!!!
看看,如果这样成功的话就说明用127.0.0.1不能访问你的电脑,需要重新配置
你把jar包放在tomcat下 我值知道使用数据库连接池才会那么做的
然后重启服务
把代码帖出来!
然后说说你在什么情况下报错!
描述清楚!
package com;
import java.sql.*;public class JDBConnection {
private final String dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //连接sql数据库的方法
private final String url ="jdbc:sqlserver://localhost:1433;DatabaseName=db_database02";
private final String userName = "sa";
private final String password = "123";
private Connection con = null; public JDBConnection() {
try {
Class.forName(dbDriver).newInstance(); //加载数据库驱动
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}//创建数据库连接
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url, userName, password);
con.setAutoCommit(true); } catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
}
return true;
}
//对数据库的增加、修改和删除的操作
//对数据库的查询操作
public ResultSet executeQuery(String sql) {
ResultSet rs;
try {
if (con == null) {
creatConnection();
}
Statement stmt = con.createStatement();
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
return null;
}
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("executeQueryError!");
return null;
}
return rs;
}//关闭数据库的操作
public void closeConnection() {
if (con != null) {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace(); //To change body of catch statement use File | Settings | File Templates.
System.out.println("Failed to close connection!");
} finally {
con = null;
}
}
}}
看看到底有什么问题?
SQLServerDataSource ssds=new SQLServerDataSource();
ssds.setServerName="localhost";
ssds.setUserName="sa";
ssds.setPassword="sa";
ssds.setPortnumber=1433;
ssds.setDatabaseName="dbname";
Connection conn=ssds.getConnection();