[Microsoft][ODBC Microsoft Access Driver]

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] ¶ÔÏóÎÞЧ»ò²»ÔÙ±»ÉèÖÃ

Õâ¸öÎÊÌâÊÇʲôԭÒòÇë¸÷λָµã

---

ÓÃADOÁ¬½ÓMDBÊÔÊÔ
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb

---

ÄãµÄ´úÂëÊÇʲô£¿ jdbc µÄÄÚÈÝÊÇʲô£¿

---

ÎÒÔÚÍâÃæÓÃÒ»¸ö·½·¨forÑ­»·µ÷ÓÃÕâ¸ö·½·¨
PreparedStatement ps=null;
      try {
      if("21".equals(DeptId)){
      System.out.println("======DHDH======");
      }
      if(con==null){System.out.println("empty!!!!!!!!!!!!!!!!");}
      ps=con.prepareStatement("insert into RTX_Dept"+
      "(DeptId,PDeptID,DeptName)"+
      " values(?, ? ,?)");
      ps.setString(1,DeptId);
      ps.setString(2,PdeptId);
      ps.setString(3,DeptName);
      ps.executeUpdate();