oracle数据库脱敏代码

1.场景

公司竞标新的项目，因为之前做过类似的产品，所以就想改下用着，但是数据库中有很多上一家公司的名称需要改为竞标这家公司的，一张张改太麻烦所以写了个数据库脱敏小程序。

2.数据库脱敏代码

/**
	 * @param args
	 * @throws SQLException 
	 * @throws ClassNotFoundException 
	 */
	public static void main(String[] args) throws SQLException, ClassNotFoundException {
		//驱动
		Class.forName("oracle.jdbc.driver.OracleDriver");
		//数据库链接配置
		String url = "jdbc:oracle:thin:@192.168.111.111:1521:orcl";
		String user = "admin";
		String password = "admin";
		Connection conn = DriverManager.getConnection(url, user, password);
		conn.setAutoCommit(true);
		PreparedStatement pre = null;
		//查询数据库所有的表
		String sql = "SELECT * FROM USER_TABLES";
		ResultSet result = null;
		pre = (PreparedStatement) conn.prepareStatement(sql);
		result = pre.executeQuery();
		while (result.next()){
			try {
				ResultSet result1 = null;
				//获取表的所有列
				String sql1 = "select column_name from user_tab_columns where table_name='" + result.getString("TABLE_NAME") + "'";
				pre = conn.prepareStatement(sql1);
				result1 = pre.executeQuery();
				while(result1.next()){
					ResultSet result2 = null;
					//执行脱敏，将列中的科技集团改成公司
					String sql2 = "update " + result.getString("TABLE_NAME") + " set "+ result1.getString("column_name")
							+"="+"replace(" + result1.getString("column_name") + ",'科技集团','公司') where " +  result1.getString("column_name") 
							+ " like '%科技集团%'";
					pre = conn.prepareStatement(sql2);
					boolean execute = pre.execute(sql2);
					System.out.println(execute);
				}
				result1.close();
			} catch (Exception e) {
				continue;
			}
		}

		conn.close();
	}