トリガを作成して、インデックスの中でINあるいはOUTのパラメータを失うことを報告します:1

     ，      IN OUT  :1


      ：

boolean executestate = false;
Connection conn = getConnection();
PreparedStatement pstmt = getPrepareStatement(conn, sql);
try {
	int result = pstmt.executeUpdate();
	closeConnection(null, pstmt, conn);
	if (result >= 0) {
		executestate = true;
	}
} catch (SQLException e) {
	e.printStackTrace();
}
return executestate;

//----------------------------------------
public static PreparedStatement getPrepareStatement(Connection conn,
			String sql) {

	PreparedStatement stmt = null;
	try {
		if (conn != null) {
			stmt = conn.prepareStatement(sql);
		}

	} catch (SQLException e) {
		e.printStackTrace();
	}
	return stmt;
}

       ，             ：


boolean executestate = false;
Connection conn = getConnection();
Statement stmt = getStatement(conn);
try {
	int result = stmt.executeUpdate(sql);
	closeConnection(null, pstmt, conn);
	if (result >= 0) {
		executestate = true;
	}
} catch (SQLException e) {
	e.printStackTrace();
}
return executestate;

//-------------------------------------------------------------
public static PreparedStatement getStatement(Connection conn) {

	PreparedStatement stmt = null;
	try {
		if (conn != null) {
			stmt = conn.createStatement();
		}

	} catch (SQLException e) {
		e.printStackTrace();
	}
	return stmt;
}

                             ，