连接access。。。。。。。
TestConnection.java
------------------------------
package com.canon;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class TestConnection{
public Connection getCon(){
String url="jdbc:odbc:rong";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Properties prop = new Properties(); //只要添加这几句话就可以
prop.put("charSet", "gb2312");
Connection con = DriverManager.getConnection(url,prop);
//Connection con=DriverManager.getConnection(url);
System.out.println("连接成功---------");
return con;
} catch(SQLException e){
System.out.println("连接失败");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return null;
}
}
Properties prop = new Properties(); //只要添加这几句话就可以
prop.put("charSet", "gb2312");
Connection con = DriverManager.getConnection(url,prop);
//Connection con=DriverManager.getConnection(url);
System.out.println("连接成功---------");
return con;
} catch(SQLException e){
System.out.println("连接失败");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return null;
}
}
------------------------
读取数据。。。
ImportExcel
package com.canon;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class ImportExcel {
Connection conn=null;
String strConn;
PreparedStatement preparedStmt=null;
ResultSet sqlRst=null;
String unit=null;
String[][] temp=new String[15][6];
int i=0,j=0;
public static void main(String [] args){
ImportExcel impor= new ImportExcel();
impor.connection();
impor.readData();
impor.writeData();
impor.close();
}
//---------连接操作------------
public void connection(){
TestConnection testcon=new TestConnection();
conn=testcon.getCon();
String sql="select * from user";
try {
preparedStmt=conn.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
}
// preparedStmt.setInt(1,1);
}
//--------------读取数据-----------------
public void readData() {
try {
sqlRst=preparedStmt.executeQuery();
while(sqlRst.next()){
for(j=0;j<temp[0].length;j++){
temp[i][j]=sqlRst.getString(j+1);
// unit=Converter(temp);//转换...............
// System.out.println(unit);
}
i++;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
//--------------编码转化------------------------
public String Converter(String temp){
try {
if(temp!=null){
unit = new String(temp.getBytes("UTF-8"));//使用utf-8解码。因为我们的java是在utf-8环境下编写的,(根据具体环境)
}
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
return unit;
}
//-------------写数据---------------
public void writeData(){
for(i=0;i<temp.length;i++){
for(j=0;j<temp[0].length;j++){
System.out.println(Converter(temp[i][j]));
}
}
}
public void close(){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
unit = new String(temp.getBytes("UTF-8"));//使用utf-8解码。因为我们的java是在utf-8环境下编写的,(根据具体环境)
}
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
return unit;
}
//-------------写数据---------------
public void writeData(){
for(i=0;i<temp.length;i++){
for(j=0;j<temp[0].length;j++){
System.out.println(Converter(temp[i][j]));
}
}
}
public void close(){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}