最近要处理一个大数据量的access,想用java连接,总是各种错误,最后使用C#连接成功。
代码如下:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Data.OleDb;
using System.Data;
using System.IO;
using System.Reflection;
namespace Project2
{
class Program
{
static void Main(string[] args)
{
OleDbConnection conn = null;
try
{
string strcon = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\\Users\\yagao\\Desktop\\data.accdb;";
conn = new OleDbConnection(strcon);
conn.Open();
//string pattern = "\\d+";
//string a = null;
//string b = null;
//string c = null;
//string d = null;
//string e = null;
//string f = null;
//string g = null;
string h = null;
string l = null;
//int i = 1;
//int j = 1;
//int k = 1;
int m = 1;
//**提取邮编前两位放入pc字段**
/*string sql = "select zip from dbo_zzdw201511_zzz where zip is not null and pc is null";
OleDbDataAdapter da = new OleDbDataAdapter(sql, conn); //创