/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package GetDB;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;/**
*
* @author Chun
*/
public class GetDB {
// 驱动字符串
private final String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
// 连接字符串
private final String url = "jdbc:odbc:hotel";
// Connection接口的声明
private Connection conn = null;
// 登录名
private final String name = " ";
// 登录密码
private final String pwd = "housemanager";
public GetDB(){
try {
Class.forName(driver);
} catch (ClassNotFoundException ex) {
Logger.getLogger(GetDB.class.getName()).log(Level.SEVERE, null, ex);
}
}
public Connection getConn() {
try {
conn = DriverManager.getConnection(url, name, pwd);
} catch (SQLException ex) {
Logger.getLogger(GetDB.class.getName()).log(Level.SEVERE, null, ex);
}
return conn;
}
public static void main(String[] args) throws SQLException{
GetDB db =new GetDB();
String sql = "insert into House values ('a','a','a','a')";
db.getConn().createStatement().executeUpdate(sql);
}
}
run:
Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] ??ѯֵ????Ŀ??Ŀ???ֶ??е???Ŀ??ͬ??
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
at GetDB.GetDB.main(GetDB.java:47)
Java Result: 1查询可以查询Access库中的数据,为什么插入数据的时候报上面的错误!
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package GetDB;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;/**
*
* @author Chun
*/
public class GetDB {
// 驱动字符串
private final String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
// 连接字符串
private final String url = "jdbc:odbc:hotel";
// Connection接口的声明
private Connection conn = null;
// 登录名
private final String name = " ";
// 登录密码
private final String pwd = "housemanager";
public GetDB(){
try {
Class.forName(driver);
} catch (ClassNotFoundException ex) {
Logger.getLogger(GetDB.class.getName()).log(Level.SEVERE, null, ex);
}
}
public Connection getConn() {
try {
conn = DriverManager.getConnection(url, name, pwd);
} catch (SQLException ex) {
Logger.getLogger(GetDB.class.getName()).log(Level.SEVERE, null, ex);
}
return conn;
}
public static void main(String[] args) throws SQLException{
GetDB db =new GetDB();
String sql = "insert into House values ('a','a','a','a')";
db.getConn().createStatement().executeUpdate(sql);
}
}
run:
Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] ??ѯֵ????Ŀ??Ŀ???ֶ??е???Ŀ??ͬ??
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
at GetDB.GetDB.main(GetDB.java:47)
Java Result: 1查询可以查询Access库中的数据,为什么插入数据的时候报上面的错误!
insert into House values ('a','a','a','a');
没有问题的!
用这个试试