package lmc;
import java.io.FileInputStream;
import java.lang.reflect.Field;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
public class SqlAnnoUtils {
	public static String getSqlMap(Object bean){
		StringBuilder res = new StringBuilder();
		if(bean==null){
			System.err.println("参数对象为空");
			return res.toString();
		}
		try{
			res.append("<resultMap class=\""+bean.getClass().getName()+"\" id=\"sqlmap_"+bean.getClass().getSimpleName().toLowerCase()+"\">\n");
			Field[]fds = bean.getClass().getDeclaredFields();
			int[]lens = SqlAnnoUtils.getAnnoNums(bean);
			StringBuilder colStr = new StringBuilder();
			StringBuilder sqlStr = new StringBuilder();
			StringBuilder valStr = new StringBuilder();
			if(fds!=null&&fds.length>0){
				for(int i=0;i<fds.length;i++){
					String col = fds[i].getName();
					String type = SqlAnnoUtils.getType(fds[i].getType().getName());
					res.append("\t<result property=\""+col+"\" column=\""+col+"\" jdbcType=\""+type+"\"/>\n");
					colStr.append(col+",");
					valStr.append("\t\t#"+col+":"+type+"#,\n");
					if(lens[i]>0){
						sqlStr.append(col.toUpperCase()+"  "+type.toUpperCase()+"("+lens[i]+"),\n");
					}else{
						sqlStr.append(col.toUpperCase()+"  "+type.toUpperCase()+",\n");
					}
				}
				colStr.deleteCharAt(colStr.length()-1);
				sqlStr.deleteCharAt(sqlStr.length()-1);
				sqlStr.deleteCharAt(sqlStr.length()-1);
				valStr.deleteCharAt(valStr.length()-1);
				valStr.deleteCharAt(valStr.length()-1);
			}
			res.append("</resultMap>\n\niBatis配置文件基本语句:\n"+colStr.toString()+"\n"+valStr.toString()+"\n\nOracle数据库创建表SQL语句\n"+sqlStr.toString());
		}catch(Exception e){
			e.printStackTrace();
		}
		return res.toString();
	}
	private static String getType(String type){
		if(type.endsWith("Character")||type.endsWith("char")){
			return "CHAR";
		}
		if(type.endsWith("String")){
			return "VARCHAR";
		}
		if(type.endsWith("Boolean")||type.endsWith("boolean")){
			return "NUMBER";
		}
		if(type.endsWith("Byte")||type.endsWith("byte")){
			return "NUMBER";
		}
		if(type.endsWith("Short")||type.endsWith("short")){
			return "NUMBER";
		}
		if(type.endsWith("Integer")||type.endsWith("int")){
			return "NUMBER";
		}
		if(type.endsWith("Long")||type.endsWith("long")){
			return "NUMBER";
		}
		if(type.endsWith("Float")||type.endsWith("float")){
			return "NUMBER";
		}
		if(type.endsWith("Double")||type.endsWith("double")){
			return "NUMBER";
		}
		if(type.endsWith("BigDecimal")){
			return "NUMBER";
		}
		if(type.endsWith("Time")){
			return "DATE";
		}
		if(type.endsWith("Date")){
			return "DATE";
		}
		if(type.equals("Timestamp")){
			return "TIMESTAMP";
		}else{
			return "工具类还没进行处理";
		}
	}
	private static int[]getAnnoNums(Object bean){
		int[]res = null;
		String dir = System.getProperty("user.dir");
		String[]names = bean.getClass().getName().split("[.]");
		StringBuffer path = new StringBuffer(dir+"\\src\\");
		for(int i=0;i<names.length;i++){
			path.append(names[i]+"\\");
		}
		path.deleteCharAt(path.length()-1);
		path.append(".java");
		try{
			FileInputStream fis = new FileInputStream(path.toString().replace("\\","/"));
			byte[]data = new byte[fis.available()];
			fis.read(data);
			String con = new String(data);
			int a = 0;
			int b = -1;
			int j = 0;
			res = new int[200];
			while(a!=-1){
				a = con.indexOf("/*",a);
				if(a!=-1){
					b = con.indexOf("*/",a);
					if(b!=-1){
						int num = SqlAnnoUtils.getNum(con.substring(a+1,b).replace('*',' '));
						if(num>-1){
							res[j++]=num;
						}
						a = b;
					}
				}
			}
			System.out.println("有数字的文档注解的个数:"+j);
		}catch(Exception e){
			e.printStackTrace();
		}
		return res;
	}
	private static int getNum(String anno){
		Matcher mch = Pattern.compile("\\d*").matcher(anno);
		if(anno.indexOf("set()")!=-1){
			while(mch.find()){
				if(!mch.group().equals("")){
					String num = mch.group();
					return Integer.parseInt(num);
				}
			}
		}
		return -1;
	}
}