向access2007插入数据时，显示成功，然而最后一次插入的数据无法更新到数据库

0 0

向access2007插入数据时，显示成功，然而最后一次插入的数据无法更新到数据库10

无论插入多少数据，均无报错，全部显示插入成功，然而最后一组数据无法进入数据库。

public class MdbHelper 
{
	
	private Connection conn;
	private Statement stmt;
	private PreparedStatement ps;
	private String dataBasePathString = "";
	private boolean isConnected = false;
	
	public void connect(String mdbPath) 
	{
		try 
		{  
			//mdb路径未变且连接有效，则无需再连接
			if(mdbPath == dataBasePathString && isConnected)// && conn.isValid(100))
				return;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String url = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb, *.accdb)};DBQ=" + mdbPath;//C:\\Test.mdb";       
            conn = DriverManager.getConnection(url, "", "");
            dataBasePathString = mdbPath;//将mdb路径更新到成员变量中，以供getCommunity()调用；
            isConnected = true;
            //System.out.println("Connect succeed.");
		}
		catch (Exception e) 
		{
			e.printStackTrace(); 
			System.out.println(e.getMessage());
		}
	}
	
	public void disConnect() throws SQLException 
	{
		conn.close();
		isConnected = false;
	}
	
	
	public ResultSet query(String sqlString) throws SQLException 
	{
		stmt = this.conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,   
                ResultSet.CONCUR_UPDATABLE);
		//System.out.println("query succeed.");
		return this.stmt.executeQuery(sqlString);
	}
	
	public int execUpdate(String sqlString) throws SQLException, Exception
	{
		ps = conn.prepareStatement(sqlString);
		int result = ps.executeUpdate(); 
		ps.close();  
		//System.out.println("exec result : + " + ps.execute());
		//Thread.currentThread().sleep(500);
		
		System.out.println("execUpdate result : " + result + " / " + sqlString);
		return result;
	}
}

import java.sql.SQLException;
import java.util.Timer;

public class Start 
{

	public static void main(String[] args) 
    {
		try 
		{
			Config config = new Config();
			config.init();
			addTaskTest() ;
			
		}
		catch (Exception e) 
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    }
	
	
	private static void addTaskTest() 
	{
		MdbHelper mdbHelper  = new MdbHelper();
		mdbHelper.connect(Config.getDataBasePath());
		for (int i = 1; i <= 20; i++) 
		{
			String insertString = "insert into taskTable values('" + i + "','" + i + "','" + i + "')";
			try {
				int updatedRowNum = mdbHelper.execUpdate(insertString);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}		
	}
}

控制台输出：
execUpdate result : 1 / insert into taskTable values('1','1','1')
execUpdate result : 1 / insert into taskTable values('2','2','2')
execUpdate result : 1 / insert into taskTable values('3','3','3')
execUpdate result : 1 / insert into taskTable values('4','4','4')
execUpdate result : 1 / insert into taskTable values('5','5','5')
execUpdate result : 1 / insert into taskTable values('6','6','6')
execUpdate result : 1 / insert into taskTable values('7','7','7')
execUpdate result : 1 / insert into taskTable values('8','8','8')
execUpdate result : 1 / insert into taskTable values('9','9','9')
execUpdate result : 1 / insert into taskTable values('10','10','10')
execUpdate result : 1 / insert into taskTable values('11','11','11')
execUpdate result : 1 / insert into taskTable values('12','12','12')
execUpdate result : 1 / insert into taskTable values('13','13','13')
execUpdate result : 1 / insert into taskTable values('14','14','14')
execUpdate result : 1 / insert into taskTable values('15','15','15')
execUpdate result : 1 / insert into taskTable values('16','16','16')
execUpdate result : 1 / insert into taskTable values('17','17','17')
execUpdate result : 1 / insert into taskTable values('18','18','18')
execUpdate result : 1 / insert into taskTable values('19','19','19')
execUpdate result : 1 / insert into taskTable values('20','20','20')

然而数据库中只有1--19的记录。不管插入多少，总是少最后一条数据。

然而，我在execUpdate()函数中加一句代码：
Thread.currentThread().sleep(500);
结果就正常了。这是为什么？在网上实在是没有搜到类似情况，谢谢！