求助，JDBC报错：SQL 命令未正确结束

2018-01-13 09:05:09 371 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

终极解决方案-oracle在mybatis中批量插入数据报错java.sql.SQLException: ORA-00933: SQL 命令未正确结束 oracle在mybatis中批量插入数据报错java.sql.SQLException: ORA-00933: SQL 命令未正确结束现象最常见的解决方案不常见解决方案原因解决方案现象在使用MyBatis操作Oracle数据库的时候，进行批量插入数据，思路是封装一个List集合通过Myabtis的foreach标签进行循环插入，可是搬照Mysql的批量插入会产生异常最常见的解决方案网络上说的最多的解决方案大致都是说由于SQL语法造成的原因，例如这样： Error updating databas 阅读详情

public static Vector<String> seek(int operateFlag, String name, String age, String sex) {

		String sql = "SELECT * from criminals";

		int selectFlag =0;

		if(name != null && !name.equals("")) {

			sql += "WHERE name LIKE ?";

			selectFlag = 1;

			if(age != null && !age.equals("")) {

				sql += "AND age LIKE ?";

				selectFlag = 2;

				if(!sex.equals("")) {

					sql += "AND sex LIKE ?";

					selectFlag =3;

				}

			}else {

				if(!sex.equals("")) {

					sql += "AND sex LIKE ?";

					selectFlag =4;

			    }

			}

		}else {

			if(age != null && !age.equals("")) {

				sql += "WHERE age LIKE ?";

				selectFlag = 5;

				if(!sex.equals("")) {

					sql += "AND sex LIKE ?";

					selectFlag =6;

				}

			}else {

				if(!sex.equals("")) {

					sql += "WHERE sex LIKE ?";

					selectFlag =7;

			    }

			}			

		}

		Vector <String> infoStringCollection = dataOperate.generalQuery(operateFlag, sql, selectFlag, name, age, sex);

		return infoStringCollection;

	}

public Vector<String> generalQuery(int operateFlag, String sql, int selectFlag, String name, String age,

			String sex) {

		Vector <String> infoStringCollection = new Vector <String>();

		try {

			pstmt = con.prepareStatement(sql);

			switch (selectFlag) {

			case 0 :

				break;

			case 1:

				pstmt.setString(1, name);

				break;

			case 2:

				pstmt.setString(1, name);

				pstmt.setString(2, age);

				break;

			case 3:

				pstmt.setString(1, name);

				pstmt.setString(2, age);

				pstmt.setString(3, sex);

				break;

			case 4:

				pstmt.setString(1, name);

				pstmt.setString(2, sex);

				break;

			case 5:

				pstmt.setString(1, age);

				break;

			case 6:

				pstmt.setString(1, age);

				pstmt.setString(1, sex);

				break;

			case 7:

				pstmt.setString(1, sex);

			}

			ResultSet rs = pstmt.executeQuery();

		}catch (SQLException se) {

			System.err.println("查询数据库出错");

			System.err.println(se);

			se.printStackTrace(System.err);

		}

		

		return infoStringCollection;

	}