String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+saveDirectory+"\\ssid.mdb";//设定数据库连接串,同时指定了access文件 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//初始化驱动
//Connection conn=DriverManager.getConnection("jdbc:odbc:test","","") ;//建立连接
Connection conn=DriverManager.getConnection(strurl) ;//建立连接 Statement stmt=conn.createStatement();
//SELECT * FROM CardTime INNER JOIN citizen ON CardTime.ID = citizen.ID and ;
//select top 1 CardTime.IDCardNum from www.cctc40.cnCardTime order by CardTime.CardTime desc;
//SELECT * from citizen where citizen.IDCardNum in (select top 1 CardTime.IDCardNum from CardTime order by CardTime.CardTime desc); ResultSet rs=stmt.executeQuery("SELECT * from citizen where citizen.IDCardNum in (select top 1 CardTime.IDCardNum from CardTime order by CardTime.CardTime desc);"); //执行查询test是access里面的一个表 if(rs.next())
{
//IDCardNum Name sex Folk BirthDay Address NewAddress IssueOrgan AvailabilityBegin AvailabilityEnd ControlNum
name = rs.getString("Name");
sex = rs.getString("sex");
nation = rs.getString("Folk");
birthday = rs.getString("BirthDay");
address = rs.getString("Address");
newaddress = rs.getString("NewAddress");
idcard = rs.getString("IDCardNum");
department = rs.getString("IssueOrgan");
AvailabilityBegin = rs.getString("AvailabilityBegin");
AvailabilityEnd = rs.getString("AvailabilityEnd"); }
rs.close();
stmt.close();
conn.close();
birthday = birthday.replaceAll("-","").trim();
if(sex.trim().equals("男"))
{ sex="1";}
else
{ sex="0";}
System.out.println("name="+name);
System.out.println("sex="+sex);
System.out.println("nation="+nation);
System.out.println("birthday="+birthday);
System.out.println("address="+address);
System.out.println("newaddress="+newaddress);
System.out.println("department="+department);
System.out.println("AvailabilityBegin="+AvailabilityBegin);
System.out.println("AvailabilityEnd="+AvailabilityEnd); }catch(Exception e)
{
System.out.println(e);
}
System.out.println("读取ACESS数据..END."); //转换图片格式
System.out.println("转换图片格式...");
我在程序的lib下面放了unixODBC-2.3.0这个驱动 好像还差点什么 上面程序在win系统上可以读取,但是移植到linux上就不行了有的说首先要建立一个JDBC-ODBC桥接器,知道的能说的详细点不?谢谢咯,我是个新手啊
//Connection conn=DriverManager.getConnection("jdbc:odbc:test","","") ;//建立连接
Connection conn=DriverManager.getConnection(strurl) ;//建立连接 Statement stmt=conn.createStatement();
//SELECT * FROM CardTime INNER JOIN citizen ON CardTime.ID = citizen.ID and ;
//select top 1 CardTime.IDCardNum from www.cctc40.cnCardTime order by CardTime.CardTime desc;
//SELECT * from citizen where citizen.IDCardNum in (select top 1 CardTime.IDCardNum from CardTime order by CardTime.CardTime desc); ResultSet rs=stmt.executeQuery("SELECT * from citizen where citizen.IDCardNum in (select top 1 CardTime.IDCardNum from CardTime order by CardTime.CardTime desc);"); //执行查询test是access里面的一个表 if(rs.next())
{
//IDCardNum Name sex Folk BirthDay Address NewAddress IssueOrgan AvailabilityBegin AvailabilityEnd ControlNum
name = rs.getString("Name");
sex = rs.getString("sex");
nation = rs.getString("Folk");
birthday = rs.getString("BirthDay");
address = rs.getString("Address");
newaddress = rs.getString("NewAddress");
idcard = rs.getString("IDCardNum");
department = rs.getString("IssueOrgan");
AvailabilityBegin = rs.getString("AvailabilityBegin");
AvailabilityEnd = rs.getString("AvailabilityEnd"); }
rs.close();
stmt.close();
conn.close();
birthday = birthday.replaceAll("-","").trim();
if(sex.trim().equals("男"))
{ sex="1";}
else
{ sex="0";}
System.out.println("name="+name);
System.out.println("sex="+sex);
System.out.println("nation="+nation);
System.out.println("birthday="+birthday);
System.out.println("address="+address);
System.out.println("newaddress="+newaddress);
System.out.println("department="+department);
System.out.println("AvailabilityBegin="+AvailabilityBegin);
System.out.println("AvailabilityEnd="+AvailabilityEnd); }catch(Exception e)
{
System.out.println(e);
}
System.out.println("读取ACESS数据..END."); //转换图片格式
System.out.println("转换图片格式...");
我在程序的lib下面放了unixODBC-2.3.0这个驱动 好像还差点什么 上面程序在win系统上可以读取,但是移植到linux上就不行了有的说首先要建立一个JDBC-ODBC桥接器,知道的能说的详细点不?谢谢咯,我是个新手啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货