代码和说明如下:
package test;
import java.util.ArrayList;
import java.util.List;
/**
* @author : suyuyuan
* @date :2016年5月17日 上午9:41:05
* @version 1.0
*/
public class Comparison {
public static void main(String[] args) {
List<String> database = new ArrayList<String>();
List<String> powerdesigner = new ArrayList<String>();
//数据库中取出的字段:
String base="ID测试1PROMOTION_IDCUSTOMER_IDSTORE_IDPAYMENT_TRANS_NOPAYMENT_REFUND_NODELETEDADD_TIMEUPDATE_TIMEREFUND_DATEPREFERENTIAL_MONEYCASH_MONEYHD_TRANS_NO";
String sBase=base.replaceAll("\t", ",");
System.out.println(sBase);
String[] baseArray=sBase.split(",");
System.out.println(baseArray.length);
System.out.println(baseArray[0]);
System.out.println(baseArray[13]);
for(int i=0;i<14;i++){
database.add(baseArray[i]);
System.out.println(database);
}
//PDM中取出的字段:
String designer="IDHD_TRANS_NO测试2PREFERENTIAL_MONEYCASH_MONEYPROMOTION_IDCUSTOMER_IDSTORE_IDPAYMENT_TRANS_NOPAYMENT_REFUND_NOREFUND_DATEDELETEDADD_TIMEUPDATE_TIME";
String sDesigner=designer.replaceAll("\t", ",");
System.out.println(sDesigner);
String[] designerArray=sDesigner.split(",");
System.out.println(designerArray.length);
System.out.println(designerArray[0]);
System.out.println(designerArray[13]);
for(int i=0;i<14;i++){
powerdesigner.add(designerArray[i]);
System.out.println(powerdesigner);
}
//将database和powerdesigner进行对比,是否有差异元素
//1、进行database在powerdesigner中的遍历
Boolean b1=false;
String s1 = new String();
for(String baseItem : database){
for(String designerItem : powerdesigner){
if(baseItem.equals(designerItem)){
b1=true;
break; //如果当前baseItem在powerdesigner中存在值,则跳出baseItem在剩余powerdesigner中的遍历,进行下一个baseItem的遍历;
}
b1=false; //如果在powerdesigner中找不到当前的baseItem,则设置Boolean为false。
}
if(!b1){
s1=baseItem;
System.out.println(s1 + "字段不存在PDM中");
}
}
//2、同理,进行powerdesigner在database中的遍历
Boolean b2=false;
String s2 = new String();
for(String designerItem : powerdesigner){
for(String baseItem : database){
if(designerItem.equals(baseItem)){
b2=true;
break;
}
b2=false;
}
if(!b2){
s2=designerItem;
System.out.println(s2 + "字段不存在数据库中");
}
}
}
}
//稍作修改如下:
package test;
import java.util.ArrayList;
import java.util.List;
/**
* @author : suyuyuan
* @date :2016年5月17日 上午9:41:05
* @version 1.0
*/
public class Comparison {
public static void main(String[] args) {
List<String> database = new ArrayList<String>();
List<String> powerdesigner = new ArrayList<String>();
//数据库中取出的字段:
String base="IDPROMOTION_IDTYPECOMMODITY_IDMONEYAMOUNTSTORE_ZOME_LEVELSTORE_ZOME_CODEDELETEDADD_TIMEUPDATE_TIMEDISCOUNT_MONEY";
String sBase=base.replaceAll("\t", ",");
System.out.println(sBase);
String[] baseArray=sBase.split(",");
int baselength=baseArray.length;
System.out.println(baselength);
for(int i=0;i<baselength;i++){
database.add(baseArray[i]);
System.out.println(database);
}
//PDM中取出的字段:
String designer="IDPROMOTION_IDTYPECOMMODITY_IDMONEYAMOUNTDISCOUNT_MONEYSTORE_ZOME_LEVELSTORE_ZOME_CODEDELETEDADD_TIMEUPDATE_TIME";
String sDesigner=designer.replaceAll("\t", ",");
System.out.println(sDesigner);
String[] designerArray=sDesigner.split(",");
int designerlength=designerArray.length;
System.out.println(designerlength);
for(int i=0;i<designerlength;i++){
powerdesigner.add(designerArray[i]);
System.out.println(powerdesigner);
}
//将database和powerdesigner进行对比,是否有差异元素
//1、进行database在powerdesigner中的遍历
Boolean b1=false;
String s1 = new String();
for(String baseItem : database){
for(String designerItem : powerdesigner){
if(baseItem.equals(designerItem)){
b1=true;
break; //如果当前baseItem在powerdesigner中存在值,则跳出baseItem在剩余powerdesigner中的遍历,进行下一个baseItem的遍历;
}
b1=false; //如果在powerdesigner中找不到当前的baseItem,则设置Boolean为false。
}
if(!b1){
s1=baseItem;
System.out.println(s1 + "字段不存在PDM中");
}
}
//2、同理,进行powerdesigner在database中的遍历
Boolean b2=false;
String s2 = new String();
for(String designerItem : powerdesigner){
for(String baseItem : database){
if(designerItem.equals(baseItem)){
b2=true;
break;
}
b2=false;
}
if(!b2){
s2=designerItem;
System.out.println(s2 + "字段不存在数据库中");
}
}
}
}
注意点:在数据库中把列拷贝出来,复制到excel中,再复制excel中的列,右键另外一个单元格,选择“选择性粘贴”,勾选转置,点击确定。
方法二:
package Util;
import java.util.Arrays;
import java.util.List;
public class Comparison 2 {
public static void main ( String[] args )
{
List<String> list1 = Arrays.asList ("a", "f", "e", "x", "w");
List<String> list2 = Arrays.asList ("a", "b", "c", "d");
String temp1 = list1.toString ().replaceAll ("[\\[\\]]", ",").replaceAll ("\\s+", "");
String temp2 = list2.toString ().replaceAll ("[\\[\\]]", ",").replaceAll ("\\s+", "");
String result2 = "";
for ( int i = 0; i < list1.size (); i++ )
{
if (temp2.indexOf ("," + list1.get (i) + ",") == -1)
{
result2 += list1.get (i) + ",";
}
}
System.out.println ("存在list1而不存在list2的元素有:" + result2);
System.out.println ("同理可证");
}
}