package bggxy;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class sqlBean
{
public Connection conn = null;
public ResultSet rs = null;
public String DatabaseDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // DataSource 数据源名称DSN
public String url = "jdbc:microsoft:sqlserver://localhost:1433;databasename=nyserver";
public String id = "sa";
public String pwd = "sa";
conn = DriverManager.getConnection(url, id, pwd);
// 定义方法
/* setXxx用于设置属性值;getXxx用于得到属性值 */ public void setDatabaseDriver(String Driver)
{
this.DatabaseDriver = Driver;
} public String getDatabaseDriver()
{
return (this.DatabaseDriver);
} public void setDBUrl(String Url)
{
this.url = Url;
} public String getDBUrl()
{
return (this.url);
} public void setDBid(String id)
{
this.id = id;
} public String getDBid()
{
return (this.id);
} public void setDBpwd(String pwd)
{
this.pwd = pwd;
} public String getDBpwd()
{
return (this.pwd);
} public sqlBean()// 创建驱动连接
{// ///构造函数
try
{
Class.forName(DatabaseDriver);
} catch (java.lang.ClassNotFoundException e)
{
System.err.println("加载驱动器有错误:" + e.getMessage());
System.out.print("执行插入有错误:" + e.getMessage());// 输出到客户端
}
} public int executeInsert(String sql)// 执行插入操作
{
int num = 0;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (SQLException ex)
{
System.err.println("执行插入有错误:" + ex.getMessage());
System.out.print("执行插入有错误:" + ex.getMessage());// 输出到客户端
} CloseDataBase();
return num;
} // display data public ResultSet executeQuery(String sql)// 执行查询操作
{
rs = null;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex)
{
System.err.println("执行查询有错误:" + ex.getMessage());
System.out.print("执行查询有错误:" + ex.getMessage()); // 输出到客户端
}
return rs;
} // delete data
public int executeDelete(String sql)// 执行删除操作
{
int num = 0;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (SQLException ex)
{
System.err.println("执行删除有错误:" + ex.getMessage());
System.out.print("执行删除有错误:" + ex.getMessage()); // 输出到客户端
}
CloseDataBase();
return num;
} public int executeUpdate(String sql)// 执行更新
{
int num = 0;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (Exception ex)
{
System.err.println("执行更新有错误:" + ex.getMessage());
System.out.print("执行更新有错误:" + ex.getMessage()); // 输出到客户端
}
CloseDataBase();
return num; } public void CloseDataBase()// 关闭数据库
{
try
{
conn.close();
} catch (Exception end)
{
System.err.println("执行关闭Connection对象有错误:" + end.getMessage());
System.out.print("执行执行关闭Connection对象有错误:有错误:" + end.getMessage()); // 输出到客户端
}
}
}错误信息为:执行查询有错误:Io 异常: The Network Adapter could not establish the connection毛病出在哪儿啊?
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class sqlBean
{
public Connection conn = null;
public ResultSet rs = null;
public String DatabaseDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // DataSource 数据源名称DSN
public String url = "jdbc:microsoft:sqlserver://localhost:1433;databasename=nyserver";
public String id = "sa";
public String pwd = "sa";
conn = DriverManager.getConnection(url, id, pwd);
// 定义方法
/* setXxx用于设置属性值;getXxx用于得到属性值 */ public void setDatabaseDriver(String Driver)
{
this.DatabaseDriver = Driver;
} public String getDatabaseDriver()
{
return (this.DatabaseDriver);
} public void setDBUrl(String Url)
{
this.url = Url;
} public String getDBUrl()
{
return (this.url);
} public void setDBid(String id)
{
this.id = id;
} public String getDBid()
{
return (this.id);
} public void setDBpwd(String pwd)
{
this.pwd = pwd;
} public String getDBpwd()
{
return (this.pwd);
} public sqlBean()// 创建驱动连接
{// ///构造函数
try
{
Class.forName(DatabaseDriver);
} catch (java.lang.ClassNotFoundException e)
{
System.err.println("加载驱动器有错误:" + e.getMessage());
System.out.print("执行插入有错误:" + e.getMessage());// 输出到客户端
}
} public int executeInsert(String sql)// 执行插入操作
{
int num = 0;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (SQLException ex)
{
System.err.println("执行插入有错误:" + ex.getMessage());
System.out.print("执行插入有错误:" + ex.getMessage());// 输出到客户端
} CloseDataBase();
return num;
} // display data public ResultSet executeQuery(String sql)// 执行查询操作
{
rs = null;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex)
{
System.err.println("执行查询有错误:" + ex.getMessage());
System.out.print("执行查询有错误:" + ex.getMessage()); // 输出到客户端
}
return rs;
} // delete data
public int executeDelete(String sql)// 执行删除操作
{
int num = 0;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (SQLException ex)
{
System.err.println("执行删除有错误:" + ex.getMessage());
System.out.print("执行删除有错误:" + ex.getMessage()); // 输出到客户端
}
CloseDataBase();
return num;
} public int executeUpdate(String sql)// 执行更新
{
int num = 0;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (Exception ex)
{
System.err.println("执行更新有错误:" + ex.getMessage());
System.out.print("执行更新有错误:" + ex.getMessage()); // 输出到客户端
}
CloseDataBase();
return num; } public void CloseDataBase()// 关闭数据库
{
try
{
conn.close();
} catch (Exception end)
{
System.err.println("执行关闭Connection对象有错误:" + end.getMessage());
System.out.print("执行执行关闭Connection对象有错误:有错误:" + end.getMessage()); // 输出到客户端
}
}
}错误信息为:执行查询有错误:Io 异常: The Network Adapter could not establish the connection毛病出在哪儿啊?
public Connection conn = null;
public ResultSet rs = null;
public String DatabaseDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; //DataSource 数据源名称DSN
public String url = "jdbc:microsoft:sqlserver://localhost:1433;databasename=nyserver";
public String id = "sa";
public String pwd = "sa";
conn = DriverManager.getConnection(url,id,pwd);
在这里就有个错,在第一句conn已经被声明的同时赋初值为null,怎么又在下面再赋值呢?
要么写做public Connection conn = DriverManager.getConnection(url,id,pwd);然后放到下面去
要么就写进构造方法或者单独写一个方法.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class sqlBean {
public ResultSet rs = null; public String DatabaseDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // DataSource 数据源名称DSN
public String url = "jdbc:microsoft:sqlserver://localhost:1433;databasename=nyserver"; public String id = "sa"; public String pwd = "sa"; public Connection conn = null; // 定义方法
/* setXxx用于设置属性值;getXxx用于得到属性值 */
public void setDatabaseDriver(String Driver) {
this.DatabaseDriver = Driver;
} public String getDatabaseDriver() {
return (this.DatabaseDriver);
} public void setDBUrl(String Url) {
this.url = Url;
} public String getDBUrl() {
return (this.url);
} public void setDBid(String id) {
this.id = id;
} public String getDBid() {
return (this.id);
} public void setDBpwd(String pwd) {
this.pwd = pwd;
} public String getDBpwd() {
return (this.pwd);
} public sqlBean()// 创建驱动连接
{// ///构造函数
try {
Class.forName(DatabaseDriver);
} catch (java.lang.ClassNotFoundException e) {
System.err.println("加载驱动器有错误:" + e.getMessage());
System.out.print("执行插入有错误:" + e.getMessage());// 输出到客户端
}
} public int executeInsert(String sql)// 执行插入操作
{
int num = 0;
try {
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (SQLException ex) {
System.err.println("执行插入有错误:" + ex.getMessage());
System.out.print("执行插入有错误:" + ex.getMessage());// 输出到客户端
} finally {
CloseDataBase();
}
return num;
} // display data
public ResultSet executeQuery(String sql)// 执行查询操作
{
rs = null;
try {
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("执行查询有错误:" + ex.getMessage());
System.out.print("执行查询有错误:" + ex.getMessage()); // 输出到客户端
} finally {
CloseDataBase();
}
return rs;
} // delete data
public int executeDelete(String sql)// 执行删除操作
{
int num = 0;
try {
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (SQLException ex) {
System.err.println("执行删除有错误:" + ex.getMessage());
System.out.print("执行删除有错误:" + ex.getMessage()); // 输出到客户端
} finally {
CloseDataBase();
}
CloseDataBase();
return num;
} public int executeUpdate(String sql)// 执行更新
{
int num = 0;
try {
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (Exception ex) {
System.err.println("执行更新有错误:" + ex.getMessage());
System.out.print("执行更新有错误:" + ex.getMessage()); // 输出到客户端
} finally {
CloseDataBase();
}
return num;
} public void CloseDataBase()// 关闭数据库
{
try {
conn.close();
} catch (Exception end) {
System.err.println("执行关闭Connection对象有错误:" + end.getMessage());
System.out.print("执行执行关闭Connection对象有错误:有错误:" + end.getMessage()); // 输出到客户端
}
}
}
但是我自己没改明白,请大家帮我改改,怎么样才能连上我的SQL数据库,谢谢各位高手们
代码如下:package bggxy;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class sqlBean
{ public Connection conn = null; public ResultSet rs = null; public String DatabaseDriver = "oracle.jdbc.driver.OracleDriver"; // DataSource 数据源名称DSN
public String url = "jdbc:oracle:thin:@192.168.30.238:1521:gserver"; public String id = "bgjl_ny"; public String pwd = "7822681"; // 定义方法
/* setXxx用于设置属性值;getXxx用于得到属性值 */ public void setDatabaseDriver(String Driver)
{
this.DatabaseDriver = Driver;
} public String getDatabaseDriver()
{
return (this.DatabaseDriver);
} public void setDBUrl(String Url)
{
this.url = Url;
} public String getDBUrl()
{
return (this.url);
} public void setDBid(String id)
{
this.id = id;
} public String getDBid()
{
return (this.id);
} public void setDBpwd(String pwd)
{
this.pwd = pwd;
} public String getDBpwd()
{
return (this.pwd);
} public sqlBean()// 创建驱动连接
{// ///构造函数
try
{
Class.forName(DatabaseDriver);
} catch (java.lang.ClassNotFoundException e)
{
System.err.println("加载驱动器有错误:" + e.getMessage());
System.out.print("执行插入有错误:" + e.getMessage());// 输出到客户端
}
} public int executeInsert(String sql)// 执行插入操作
{
int num = 0;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (SQLException ex)
{
System.err.println("执行插入有错误:" + ex.getMessage());
System.out.print("执行插入有错误:" + ex.getMessage());// 输出到客户端
} CloseDataBase();
return num;
} // display data public ResultSet executeQuery(String sql)// 执行查询操作
{
rs = null;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex)
{
System.err.println("执行查询有错误:" + ex.getMessage());
System.out.print("执行查询有错误:" + ex.getMessage()); // 输出到客户端
}
return rs;
} // delete data
public int executeDelete(String sql)// 执行删除操作
{
int num = 0;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (SQLException ex)
{
System.err.println("执行删除有错误:" + ex.getMessage());
System.out.print("执行删除有错误:" + ex.getMessage()); // 输出到客户端
}
CloseDataBase();
return num;
} public int executeUpdate(String sql)// 执行更新
{
int num = 0;
try
{
conn = DriverManager.getConnection(url, id, pwd);
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (Exception ex)
{
System.err.println("执行更新有错误:" + ex.getMessage());
System.out.print("执行更新有错误:" + ex.getMessage()); // 输出到客户端
}
CloseDataBase();
return num; } public void CloseDataBase()// 关闭数据库
{
try
{
conn.close();
} catch (Exception end)
{
System.err.println("执行关闭Connection对象有错误:" + end.getMessage());
System.out.print("执行执行关闭Connection对象有错误:有错误:" + end.getMessage()); // 输出到客户端
}
}
}
这个类是我改别人oracle的类,但是我自己改不明白了,希望大家帮帮我,看看怎么改才能正常运行!
执行查询有错误:Io 异常: The Network Adapter could not establish the connection”
我的SQL运行也是正常的,到底是什么毛病啊?
郁闷死我了!
执行查询有错误:Io 异常: The Network Adapter could not establish the connection”
我的SQL运行也是正常的,到底是什么毛病啊?
郁闷死我了
import java.*;
public class Connect{
private java.sql.Connection con = null;
private final String url = "jdbc:microsoft:sqlserver://";
private final String serverName= "localhost";
private final String portNumber = "1433";
private final String databaseName= "pubs"; // 修改成你的数据库的名字
private final String userName = "user"; // 修改成你的数据库的用户名
private final String password = "password"; // 修改成你的数据库的密码
// Informs the driver to use server a side-cursor,
// which permits more than one active statement
// on a connection.
private final String selectMethod = "cursor";
// Constructor
public Connect(){}
private String getConnectionUrl(){
return url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";
}
private java.sql.Connection getConnection(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
if(con!=null) System.out.println("Connection Successful!");
}catch(Exception e){
e.printStackTrace();
System.out.println("Error Trace in getConnection() : " + e.getMessage());
}
return con;
} /*
Display the driver properties, database details
*/ public void displayDbProperties(){
java.sql.DatabaseMetaData dm = null;
java.sql.ResultSet rs = null;
try{
con= this.getConnection();
if(con!=null){
dm = con.getMetaData();
System.out.println("Driver Information");
System.out.println("\tDriver Name: "+ dm.getDriverName());
System.out.println("\tDriver Version: "+ dm.getDriverVersion ());
System.out.println("\nDatabase Information ");
System.out.println("\tDatabase Name: "+ dm.getDatabaseProductName());
System.out.println("\tDatabase Version: "+ dm.getDatabaseProductVersion());
System.out.println("Avalilable Catalogs ");
rs = dm.getCatalogs();
while(rs.next()){
System.out.println("\tcatalog: "+ rs.getString(1));
}
rs.close();
rs = null;
closeConnection();
}else System.out.println("Error: No active Connection");
}catch(Exception e){
e.printStackTrace();
}
dm=null;
}
private void closeConnection(){
try{
if(con!=null)
con.close();
con=null;
}catch(Exception e){
e.printStackTrace();
}
}
public static void main(String[] args) throws Exception
{
Connect myDbTest = new Connect();
myDbTest.displayDbProperties();
}
}
对不起,刚才是没发布的原因,但是发布完之后错误报告如下:ParserUtils: warning org.xml.sax.SAXParseException: URI was not reported to parser for entity [document]
2008-1-25 10:37:29 org.apache.jasper.compiler.Compiler generateClass
严重: Javac exception
Unable to find a javac compiler;
com.sun.tools.javac.Main is not on the classpath.
Perhaps JAVA_HOME does not point to the JDK
at org.apache.tools.ant.taskdefs.compilers.CompilerAdapterFactory.getCompiler(CompilerAdapterFactory.java:106)
at org.apache.tools.ant.taskdefs.Javac.compile(Javac.java:935)
at org.apache.tools.ant.taskdefs.Javac.execute(Javac.java:764)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:382)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
2008-1-25 10:37:29 org.apache.jasper.compiler.Compiler generateClass这是啥意思啊?这是啥意思啊?
对不起,刚才是没发布的原因,但是发布完之后错误报告如下:ParserUtils: warning org.xml.sax.SAXParseException: URI was not reported to parser for entity [document]
2008-1-25 10:37:29 org.apache.jasper.compiler.Compiler generateClass
严重: Javac exception
Unable to find a javac compiler;
com.sun.tools.javac.Main is not on the classpath.
Perhaps JAVA_HOME does not point to the JDK
at org.apache.tools.ant.taskdefs.compilers.CompilerAdapterFactory.getCompiler(CompilerAdapterFactory.java:106)
at org.apache.tools.ant.taskdefs.Javac.compile(Javac.java:935)
at org.apache.tools.ant.taskdefs.Javac.execute(Javac.java:764)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:382)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
2008-1-25 10:37:29 org.apache.jasper.compiler.Compiler generateClass这是啥意思啊?这是啥意思啊?
在用户变量里还是在系统变量里?
我的在用户变量里了
C:\Program Files\Java\jdk1.5.0_08
好象是你的classpath设置有问题.
把path设置为%JAVA_HOME%/bin
把classpath设置为%JAVA_HOME%/lib;.再试试
我不知道这原因到底出在哪?
希望大家帮我判断一下是哪儿的原因!
说明无法建立连接,是DriverManager.getConnection(...)这一步就出问题了吧,看看什么情况造成的。逐一排查:数据库实例没有运行,网络问题,防火墙问题(还是RP问题 ^_^)
{
public Connection conn = null;
public ResultSet rs = null;
public String DatabaseDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 下面是ms官网上找来的 不知道是不是这个问题 下午刚学到连接数据库 但是我看的书上也是com.microsoft.jdbc.sqlserver.SQLServerDriverMaking a Simple Connection to a DatabaseTo connect to a database by using the DriverManager class, you must first register the driver as follows:Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");When the driver is loaded, you can establish a connection by using a connection URL:String connectionUrl = "jdbc:sqlserver://localhost:1433;" +
"databaseName=AdventureWorks;user=MyUserName;password=*****;";
Connection con = DriverManager.getConnection(connectionUrl);