package cn.zhtech
import java.sql.*
import java.io.*
public class DBManager {
/**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根
String strPath=""//当前程序根路径
try{
File f=new File(".")
strPath=f.getCanonicalPath()
}catch(IOException e){
System.out.println(e.toString())
}
//access文件路径
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)}DBQ="+strPath+"\\data\\aa.mdb"
String username=""
String password=""
Connection con
Statement stml
ResultSet res
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")//加载驱动
con=DriverManager.getConnection(url, username, password)//获取连接
stml=con.createStatement()//建立statement
res=stml.executeQuery("select * from test")//查询
while(res.next()){//显示
System.out.println(res.getString("u_name")+"\n")
}
res.close()
stml.executeUpdate("insert into test(u_name) values('kkk')")//插入
stml.executeUpdate("delete from test where u_ID=3")//删除
stml.executeUpdate("update test set u_name='mengkaide' where u_ID=4")//修改
stml.close()//关闭
con.close()
}catch(Exception e){
System.out.println(e.toString())
}
}
}