请帮忙看一下错在哪里
package SMS;
import java.sql.*;
public class Database
{
private Connection con=null;
//Open the database connection
public void open() throws Exception
{
String sDriverName ="com.informix.jdbc.IfxDriver";
String sConURL ="jdbc:informix-sqli://44.0.188.165:6666/smsdb:INFORMIXSERVER=sqlsrv";
String sUserName ="test";
String sPassword ="test123";
Class.forName(sDriverName).newInstance();
con=DriverManager.getConnection(sConURL,sUserName,sPassword);
}
//Close the database connection
public void close() throws Exception
{
con.close();
}
public ResultSet runQuerySqlStr(String sqlStr) throws Exception
{
open();
ResultSet rs = null;
Statement stmt = con.createStatement();
rs = stmt.executeQuery(sqlStr);
stmt.close();
close(); //Close the Statement
return rs;
}
public int runUpdateSqlStr(String sqlStr) throws Exception
{
int count;
open();
Statement stmt = con.createStatement();
stmt.executeUpdate(sqlStr);
count=stmt.getUpdateCount();
stmt.close();
close(); //Close the Statement
if (count>0)
return 0;
else
return -1;
}
//test main function
public static void main(String args[])
{
Database data=new Database();
String sql="select * from opr_list";
ResultSet rs=data.runQuerySqlStr(sql);
}
}
连的是informix数据库,连接的IP地址、数据库名和informixserver都没错
问题点数：50、回复次数：16Top
1 楼treeroot（旗鲁特）回复于 2005-03-04 19:47:20 得分 5
什么表现Top
2 楼kingfish（工作很忙,很少来csdn...）回复于 2005-03-04 19:47:38 得分 8
错误信息总得给出来吧
Top
3 楼leisureftso（）回复于 2005-03-04 19:50:06 得分 0
$ javac Database.java
$ java Database
Exception in thread "main" java.lang.NoClassDefFoundError: Database (wrong name:
SMS/Database)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:486)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:11
1)
at java.net.URLClassLoader.defineClass(URLClassLoader.java, Compiled Cod
e)
at java.net.URLClassLoader.access$100(URLClassLoader.java:56)
at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:297)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)
at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
Top
4 楼leisureftso（）回复于 2005-03-04 19:52:40 得分 0
下面是我在JSP页面里报的错：
java.sql.SQLException: No connection/statement established yet
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:239)
at com.informix.jdbc.IfxResultSet.getMetaData(IfxResultSet.java, Compiled Code)
at com.informix.jdbc.IfxResultSet.findColumn(IfxResultSet.java, Compiled Code)
at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java, Compiled Code)
at org.apache.jsp.test$jsp._jspService(test$jsp.java, Compiled Code)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java, Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java, Compiled Code)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java, Compiled Code)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java, Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java, Compiled Code)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java, Compiled Code)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java, Compiled Code)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java, Compiled Code)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java, Compiled Code)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java, Compiled Code)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java, Compiled Code)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java, Compiled Code)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java, Compiled Code)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java, Compiled Code)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java, Compiled Code)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java, Compiled Code)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java, Compiled Code)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java, Compiled Code)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java, Compiled Code)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java, Compiled Code)
Top
5 楼leisureftso（）回复于 2005-03-04 20:11:46 得分 0
？？？Top
6 楼mingxuan3000（铭轩）回复于 2005-03-04 21:53:13 得分 0
java.sql.SQLException: No connection/statement established yet
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:239)
Top
7 楼leisureftso（）回复于 2005-03-05 10:58:57 得分 0
那是怎么回事呀，我也知道是连接数据库时出错Top
8 楼leisureftso（）回复于 2005-03-05 11:00:34 得分 0
JAVA高手呢?Top
9 楼kingfish（工作很忙,很少来csdn...）回复于 2005-03-05 12:36:42 得分 0
java SMS.DatabaseTop
10 楼lld2001（流云）回复于 2005-03-05 12:38:32 得分 1
初学，努力ingTop
11 楼jinxfei（周华健、言兴朋、茅威涛）回复于 2005-03-05 12:50:15 得分 5
javac sms/database.java
java SMS.Database
Top
12 楼leisureftso（）回复于 2005-03-05 13:16:29 得分 0
都试过了，没用Top
13 楼congbailing_914（静下心来学习《java编程思想》,打好基础！不玩了~！）回复于 2005-03-05 13:32:31 得分 1
学习！
up！Top
14 楼Idora（我不当老大已经很多年，恩）回复于 2005-03-05 17:04:42 得分 0
将Database加入classpathTop
15 楼zhuzy2004（抄手）回复于 2005-03-05 17:13:56 得分 30
将代码都放到main方法里试验看看行不行吧,如果不行那就是驱动的问题了吧,个人意见!Top
16 楼leisureftso（）回复于 2005-03-08 11:44:50 得分 0
问题解决了，多谢各位
该结帖了Top
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
