java web问题,急切我用的是microsoft access 2007,Myeclipse 7.5,jdk是1.6版本的,要下载什么acess数据库驱
java web问题,急切
我用的是microsoft access 2007,Myeclipse 7.5,jdk是1.6版本的,要下载什么acess数据库驱动呀,在Myeclipse里要怎样配置呀,引入包什么的等等.····麻烦帮帮忙
我下载了一个access jdbc,然后将access jdbc.jar包放在了WEB-INF的lib里,
我还写了个测试性的类文件
import java.sql.Connection;
import java.sql.DriverManager;
public class test{
public static void main(String[] args) throws Exception {
// 加载驱
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// 连接数据库的地址
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=d:\\Database1.mdb";
Connection conn = null;
try {
// 创建与数据库的连接
conn = DriverManager.getConnection(url);
System.out.println("成功连接到数据库:" + conn);
} catch(Exception ex) {
System.out.println("连接失败:" + ex);
} finally {
// 关闭连接,释放资源
if (conn != null) {
conn.close();
}
}
}
}
错误信息是:连接失败:java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 找不到文件 '(未知的)'。
[最优解释]
看下odbc配置 开始→控制面板→管理工具→数据源→添加一个[Microsoft 驱动选择 ][ODBC Microsoft Access Driver]
[其他解释]
这是我以前写过的一段连接Access数据库的代码,肯定是可以用的,希望对你有用。
public class ConnToAccess {
/**
* @param args
*/
private static Connection conn = null;
public static Connection getConnection() {
if(conn == null) {
try {
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=F://train.MDB";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url);
} catch (Exception e) {
e.printStackTrace();
}
}
return conn;
}
}
[其他解释]下个Mysql数据库,下个jar包http://www.mysql.com/downloads/connector/j/
class.forname("com.mysql.jdbc.Driver")
[其他解释]用mysql吧,去官网下个jar包
百度一下代码写法就行了
[其他解释]按照你说的做了,可还是不行,出现同样的错误呢,用MySQL会不会更简便点呀
------其他解决方案--------------------
import java.sql.*;
public class ArticleTree {
public static void main(String[] args) {
new ArticleTree().show();
}
public void show() {
Connection conn = null;
try {
Class.forName("org.gjt.mm.mysql.Driver" );
conn = DriverManager
.getConnection("jdbc:mysql://localhost:3306/article?user=root&password=");
tree(conn, 0, 1);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from dept");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
private void tree(Connection conn, int pid, int level) {
Statement stmt = null;
ResultSet rs = null;
StringBuffer strPre = new StringBuffer("");
for (int i = 1; i < level; i++) {
strPre = strPre.append(" ");
}
try {
stmt = conn.createStatement();
String sql = "select * from article where pid = " + pid;
rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(strPre + rs.getString("cont"));
if (rs.getInt("isleaf") != 0) {
tree(conn, rs.getInt("id"), level + 1);
}
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (stmt != null) {
stmt.close();
stmt = null;
}
if (rs != null) {
rs.close();
rs = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
我写了这样一个类,建立了数据库表,可还是不行,我想问是不是还要配置mysql的驱动包呀,拜托了!
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at ArticleTree.show(ArticleTree.java:9)
at ArticleTree.main(ArticleTree.java:4)