会python真的可以为所欲为0(回)
379天前
这里还有人吗1(回)
564天前这里还有人吗0(回)
564天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
789天前到处都是羊，不想上班0(回)
869天前
鸽子
0(回)
873天前import java.sql.*; |
class ConnectAccess{ |
String connStr; |
public ConnectAccess(String accessDB_DSN_Name){//accessDB_DSN_Nameabc为自己创建的系统DSN数据源名,对应一个Access数据库. |
//String link="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=H:\\summer\\javaxml\\db.mdb"; |
connStr = "jdbc:odbc:"+accessDB_DSN_Name; |
|
try{ |
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); |
Connection con=DriverManager.getConnection(connStr,"",""); |
Statement statement=con.createStatement(); |
ResultSet rs=statement.executeQuery("select * from student"); |
while(rs.next()){ |
System.out.println(rs.getString(1)+" "+rs.getString(2) + " " + rs.getString(3)); |
} |
rs.close(); |
statement.close(); |
con.close(); |
}catch(Exception e){ |
e.printStackTrace(); |
} |
} |
public static void main(String[] args){ |
ConnectAccess access = new ConnectAccess("abc"); |
|
} |
} |
