package org;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class TestAcess {
/**
* @param args
*/
public static void main(String[] args) {
try{
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=d:\\Report.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn= DriverManager.getConnection(url);
PreparedStatement pstmt = null;
//System.out.println("----"+ conn);
String delSql = "delete from phone ";
pstmt = conn.prepareStatement(delSql);
pstmt.execute();
//
String sql ="select * from phone "; //where phone = 282
pstmt = conn.prepareStatement(sql);
ResultSet rs = null;
rs = pstmt.executeQuery();
String str = "";
while(rs.next()){
//System.out.println("***1:"+rs.getString(1)+"***2:"+rs.getString(2)+"***3:"+rs.getString(3)+"***4:"+rs.getString(4)+"***5:"+rs.getString(5)+"***6:"+rs.getString(6)+"***7:"+rs.getString(7)+"***8:"+rs.getString(8)+"***9:"+ rs.getString("phone"));
str = str + rs.getString("phone")+",";
}
System.out.println("----"+str);
}catch(Exception e){
System.out.println("----"+e.getMessage());
}
}
}
java连接access数据库
最新推荐文章于 2023-07-10 17:59:02 发布