创设触发器，报索引中丢失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;
}

不知道是不是在对触发器进行预编译的时候有什么机制需要验证不，最后我也只能这样处理这个问题了