navicat for mysql ddl column to select column

navicat for mysql ddl column to select column

import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;




public class DatabaseTableColumnMain {


public static void main(String args[]){

String s="`a` varchar(255) DEFAULT ''";

Pattern p=Pattern.compile("`(\\w)*`");
//Pattern p=Pattern.compile("p");
Matcher matcher=p.matcher(s);

List<String> list=new ArrayList<String>();

while(matcher.find()){
//System.out.println(matcher.group());
String g=matcher.group();
String column=g.substring(1, g.length()-1);
//System.out.println(column);
//System.out.println("=============================================");
g=column;
int i=g.indexOf("_");
   while(i>-1){
   
    char upper=g.charAt(i+1);
   
    upper=(char) (upper-32);
    String s1=g.substring(i, i+2);
    g=g.replace(s1, "_"+upper);
   
    i=g.indexOf("_", i+1);
   
   
   
   }
   
   g=g.replace("_", "");
   
   
   //System.out.println("**************************************************");
   
   //System.out.println(g);
   
   
   System.out.println(column+" as "+"\""+g+"\",");

   

}

System.out.println("---------------------------------------------------------");
System.out.println("ok");





}

}