Java开发网 - 请教个连接数据库的连接问题(有代码) 谢过先

Topic: 请教个连接数据库的连接问题(有代码) 谢过先

1.请教个连接数据库的连接问题(有代码) 谢过先

Posted by: iceriver2000
Posted on: 2007-01-08 12:08

我有个数据库叫project.mdb(access的) 注册数据源为 mydb.dsn 其中有表为project
要在java中连接,我写了如下:
package prodb1;
import java.sql.*;

public class EmpJdbc {
  String dbDriver="sun.jdbc.odbc.JdbcOdbcDriver";
  String url="jdbc:odbc:mydb";
  Connection con=null;
  ResultSet rs=null;
  public EmpJdbc(){
    try{
      Class.forName(dbDriver);

    }catch(ClassNotFoundException e){
      e.printStackTrace();
    }
  }
  public ResultSet executeQuery(String s){
    rs=null;
    try{
      con=DriverManager.getConnection(url);
      Statement stm=con.createStatement();
      rs=stm.executeQuery Moon

;

    }catch(SQLException e){
      e.printStackTrace();
    }
    return rs;
  }
  public static void main(String args[])throws Exception{
    EmpJdbc emjdbc=new EmpJdbc();
    String sql="SELLECT*FROM project";
    ResultSet rs=emjdbc.executeQuery(sql);
    while(rs.next()){
      String name=rs.getString("name");
      System.out.println(name);

    }
  }

}
理论上是可以的啊 ,为什么我搞一天老是给我报错呢 ??
请大家帮帮小弟感激不尽.

2.Re:请教个连接数据库的连接问题(有代码) 谢过先 [Re: iceriver2000]	Copy to clipboard
Posted by: xuelange Posted on: 2007-01-09 09:12 检查设置的数据源mydb是否准确。检查是否存在连对数据库，表和表的列名

3.Re:请教个连接数据库的连接问题(有代码) 谢过先 [Re: iceriver2000]	Copy to clipboard
Posted by: qw2008 Posted on: 2007-01-11 17:56 請把出錯信息也貼上來

4.Re:请教个连接数据库的连接问题(有代码) 谢过先 [Re: iceriver2000]	Copy to clipboard
Posted by: gwangmm Posted on: 2007-01-12 15:25 对！把错误信息贴出来

5.Re:请教个连接数据库的连接问题(有代码) 谢过先 [Re: iceriver2000]	Copy to clipboard
Posted by: why Posted on: 2007-01-12 20:11 SELECT * FROM Project

6.Re:请教个连接数据库的连接问题(有代码) 谢过先 [Re: iceriver2000]	Copy to clipboard
Posted by: jg0021 Posted on: 2007-01-16 20:43 import java.sql.*; public calss ExcuteSQL{ ExcuteSQL(){} Connection conn=null; }

7.Re:请教个连接数据库的连接问题(有代码) 谢过先 [Re: iceriver2000]

Copy to clipboard

Posted by: wuzhong
Posted on: 2007-01-17 23:03

public class EmpJdbc {
String dbDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:mydb";
Connection con=null;
ResultSet rs=null;
public EmpJdbc(){
try{
Class.forName(dbDriver);

}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public ResultSet executeQuery(String s){
rs=null;
try{
con=DriverManager.getConnection(url);
Statement stm=con.createStatement();
rs=stm.executeQuery(" ");//在这里添加你要查找的表字段名称

}catch(SQLException e){
e.printStackTrace();
}
return rs;
}
public static void main(String args[])throws Exception{
EmpJdbc emjdbc=new EmpJdbc();
String sql="SELLECT*FROM project";
ResultSet rs=emjdbc.executeQuery(sql);
while(rs.next()){
String name=rs.getString("name");
System.out.println(name);

}
}

}

8.Re:请教个连接数据库的连接问题(有代码) 谢过先 [Re: iceriver2000]	Copy to clipboard
Posted by: why Posted on: 2007-01-20 19:24 SELLECTFROM project SELECT FROM project and error message, please.