81,091
社区成员
发帖
与我相关
我的任务
分享
public class WriteToAccess {
public void saveFamilyInfo(List<Family> list) {
String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String connectDB="jdbc:odbc:test";
// String connectDB="jdbc:odbc:driver={Microsoft Access Driver (*.mdb, *.accdb) };DBQ="+"D://access_test//Output_data.accdb";
try{
Class.forName(JDriver);
}
catch(java.lang.ClassNotFoundException e){
System.out.println("ForName:"+e.getMessage());
}
try{
Connection con=DriverManager.getConnection(connectDB,"","");//此处报错
Statement stmt=con.createStatement();
String query=null;
for (int i = 0; i < list.size(); i++) {
Family family = list.get(i);
String familyId=family.getFamilyId();
Integer villageCommittee=family.getVillageCommittee().getVillageCommitteeId();
Integer province=family.getProvince().getProvinceId();
Integer county=family.getCounty().getCountyId();
Integer familySize=family.getFamilySize();
Integer income=family.getIncome();
Integer user=family.getUser().getUserID();
String createTime=family.getCreateTime();
query="insert into 家庭信息表(familyId,familySize,income,createTime,province,villageCommittee,county,user) values ('"
+ familyId
+ "',"
+ familySize
+ ","
+ income
+ ",'"
+ createTime
+ "',"
+ province
+ ","
+ villageCommittee
+","
+county
+","
+user
+ ")";
stmt.executeUpdate(query);
}
stmt.close();
con.close();
}
catch(SQLException e){
System.out.println("SQLException:"+e.getMessage());
}
}
}
import java.sql.*;
import sun.jdbc.odbc.*;
public class CreateTable02_4_2{
public static void main(String[] args){
String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String connectDB="jdbc:odbc:Output_data";
//String connectDB="jdbc:odbc:driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+"D://access_test//Book.accdb";
try{
Class.forName(JDriver);
}
catch(java.lang.ClassNotFoundException e){
System.out.println("ForName:"+e.getMessage());
}
try{
Connection con=DriverManager.getConnection(connectDB);
Statement stmt=con.createStatement();
String query="create table 书目_by_java("+"编号 Text(20),"+"书名 Text(20),"+"作者 Text(10),"+"书价 Number"+")";
stmt.executeUpdate(query);
stmt.close();
con.close();
}
catch(SQLException e){
System.out.println("SQLException:"+e.getMessage());
}
}
}
运行这个小程序的时候是没错误的