这是代码看看那错了我的QQ 154336958
package DB;import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;public class GetAccessDB {
static String str = "C:\\database\\gw.mdb"; public Connection getconn() {
Connection conn = null;
// String strurl="jdbc:odbc:driver={Microsoft Access Driver
// (*.mdb)};DBQ="+str;
try { // "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=
String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="
+ str;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(strurl);
} catch (Exception ex) {
ex.printStackTrace();
}
return conn;
} public void selected() {
try {
Statement stat = this.getconn().createStatement();
ResultSet rs = stat.executeQuery("select * from sort");
while (rs.next()) {
System.out.println(rs.getString("name"));
}
} catch (Exception ex) {
ex.printStackTrace();
}
} public void insert() {
try {
Connection conn = this.getconn();
System.out.print(conn.createStatement().executeUpdate("insert into sort(id,fid,name) values(3,0,'aa')"));
} catch (Exception ex) {
ex.printStackTrace();
}
} public static void main(String args[]) {
GetAccessDB a = new GetAccessDB();
a.insert();
a.selected();
}}
package DB;import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;public class GetAccessDB {
static String str = "C:\\database\\gw.mdb"; public Connection getconn() {
Connection conn = null;
// String strurl="jdbc:odbc:driver={Microsoft Access Driver
// (*.mdb)};DBQ="+str;
try { // "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=
String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="
+ str;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(strurl);
} catch (Exception ex) {
ex.printStackTrace();
}
return conn;
} public void selected() {
try {
Statement stat = this.getconn().createStatement();
ResultSet rs = stat.executeQuery("select * from sort");
while (rs.next()) {
System.out.println(rs.getString("name"));
}
} catch (Exception ex) {
ex.printStackTrace();
}
} public void insert() {
try {
Connection conn = this.getconn();
System.out.print(conn.createStatement().executeUpdate("insert into sort(id,fid,name) values(3,0,'aa')"));
} catch (Exception ex) {
ex.printStackTrace();
}
} public static void main(String args[]) {
GetAccessDB a = new GetAccessDB();
a.insert();
a.selected();
}}
解决方案 »
- java运行时为什么一定要进入目录中,而编译时却不需要
- java文本输入框中文输入时没显示输入法的提示框
- 求助:NullPointerException
- 在线铁路查询和购票系统
- 怎么么实现洗牌算法啊??
- 在线等:怎么用java访问注册表文件啊
- import org.apache.lucene.analysis.cn.*这个包在哪下,怎么导入
- sos.........
- 在linux下怎样解压j2sdk-1.3.0-RC1-linux-i386.tar.bz2这种类型的文件??
- 一个关于在Graphics中setColor的问题,急啊!!!
- Vector 的排序问题(在线等高手来解答)
- 请简单说一下这两种循环的区别
sort
有字段 id, fid,name
insert into sort(fid,name) values(0,'aa')