pstmt.setString(1,"cc"); 下面有 pstmt.execute();
pstmt.setString(1,"dd"); 下面有 pstmt.execute();
 

解决方案 »

  1.   

    没关闭连接:
    用conn.close();
      

  2.   

    conn.setAutoCommit(true);下面conn.close();
    也不行阿。
      

  3.   

    加close后退出jd或eclipse,重进。
      

  4.   

    try{
         //加载驱动程序
    Class.forName(drivername).newInstance();
    //建立连接
        conn=DriverManager.getConnection(url,username,passwd);
    //     stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
    //     conn.setAutoCommit(false);
        pstmt = conn.prepareStatement("insert into myTable(a)values(?)");
                    pstmt.setString(1,"cc");
                    pstmt.execute();
                    pstmt = conn.prepareStatement("insert into myTable(b)values(?)");
                    pstmt.setString(1,"dd");
                    pstmt.execute();
                    conn.commit();
    //                conn.setAutoCommit(true);
    }catch(SQLException e){
             e.printStackTrace();
        }catch(Exception e){
    e.printStackTrace();
    }