现在有一个String 字符串例如:
String abcString="4,开,1,222,222,CJ:5,开,1,333,333,CJ:6,开,1,444,444,CJ:24,开,1,999,999,KZ:25,开,1,888,888,KZ";
以“:”分割。赋到object 对象上,或是直接一个一个的赋上。都有哪些方式?如何赋到object 对象上?
赋完了,还要有一个需求,就是把这个object 取出来。
例如:问题1:如果把这个直接赋到 object 上,就是不以“:”分割的形式,在取值的时候,要每6个字符串用到一个sql语句上。用for 循环如何循环得到。object 好像没有 .length 之类的属性吧!
String abcString="4,开,1,222,222,CJ:5,开,1,333,333,CJ:6,开,1,444,444,CJ:24,开,1,999,999,KZ:25,开,1,888,888,KZ";
以“:”分割。赋到object 对象上,或是直接一个一个的赋上。都有哪些方式?如何赋到object 对象上?
赋完了,还要有一个需求,就是把这个object 取出来。
例如:问题1:如果把这个直接赋到 object 上,就是不以“:”分割的形式,在取值的时候,要每6个字符串用到一个sql语句上。用for 循环如何循环得到。object 好像没有 .length 之类的属性吧!
解决方案 »
- 我在netbeans运行news项目,数据库是mysql,服务器是tomcat5.5
- NoSuchMethodError错误,很急。
- jms 编程:读取Weblogic上配置的消息队列里的消息
- POI读取WORD文档时一个很奇怪的问题
- eclipse+lomboz3.2.2+jboss4.0建WebService应用时碰到的初级问题
- Hibernate读取XML错误,100分问题,急急,不解决不结贴
- jboss数据库连接怎样自动恢复?急
- 关于TOMCAT
- 关于Xml的建树问题
- 大家看看,一个很奇怪的问题啊,能不能帮忙解决一下啊,谢谢了
- ExtJs代码:小写金额自动转化为大写金额
- 关于SQLMAP
分割为数组
然后...自己for吧
Object objs[] = abcString.split(":");用去SQL语句,你可以再将其以逗号“,”分割,然后传值。
Object objs[] = abcString.split(":");用去SQL语句,你可以再将其以逗号“,”分割,然后传值。
* @param args
*/
public static void main(String[] args) { String abcString = "4,开,1,222,222,CJ:5,开,1,333,333,CJ:6,开,1,444,444,CJ:24,开,1,999,999,KZ:25,开,1,888,888,KZ";
String[] records = abcString.split(":"); for (String record : records) { String[] cols = record.split(","); for (String col : cols) {
// 传进sql的参数
System.out.println(col);
}
}
}
String sqlStr = "";String abcString="4,开,1,222,222,CJ:5,开,1,333,333,CJ:6,开,1,444,444,CJ:24,开,1,999,999,KZ:25,开,1,888,888,KZ";
String[] obj1 = abcString.split(":");
for(int i=0; i<obj1.length;i++){
Object[] obj2 = obj1[i].split(",");
sqlStr = "insert into xxxtable(param1,param2,param3,param4,param5,param6) values("+obj2[0]+","+obj2[1]+","+obj2[2]+","+obj2[3]+","+obj2[4]+","+obj2[5]+");";
System.out.println(sqlStr);
}insert into xxxtable(param1,param2,param3,param4,param5,param6) values(4,开,1,222,222,CJ);
insert into xxxtable(param1,param2,param3,param4,param5,param6) values(5,开,1,333,333,CJ);
insert into xxxtable(param1,param2,param3,param4,param5,param6) values(6,开,1,444,444,CJ);
insert into xxxtable(param1,param2,param3,param4,param5,param6) values(24,开,1,999,999,KZ);
insert into xxxtable(param1,param2,param3,param4,param5,param6) values(25,开,1,888,888,KZ);
因为需求,必须要放在object 上
String[] strs = abcString.split(":");
String[] substr = null;
String sqlStr;
for(int i=0;i<strs.length;i++){
substr = strs[i].split(",");
sqlStr = "insert into table values(substr[0],substr[1],substr[2],substr[3],substr[4],substr[5]);";
}
String sqlStr = "";String abcString="4,开,1,222,222,CJ:5,开,1,333,333,CJ:6,开,1,444,444,CJ:24,开,1,999,999,KZ:25,开,1,888,888,KZ";
String[] obj1 = abcString.split(":");
for(int i=0; i<obj1.length;i++){
Object[] obj2 = obj1[i].split(",");
sqlStr = "insert into xxxtable(param1,param2,param3,param4,param5,param6) values("+obj2[0]+",'"+obj2[1]+"',"+obj2[2]+","+obj2[3]+","+obj2[4]+",'"+obj2[5]+"');";
System.out.println(sqlStr);
}给8楼补充下 有些字符串 需要加单引号
String sqlStr = "";String abcString="4,开,1,222,222,CJ:5,开,1,333,333,CJ:6,开,1,444,444,CJ:24,开,1,999,999,KZ:25,开,1,888,888,KZ";
String[] obj1 = abcString.split(":");
for(int i=0; i<obj1.length;i++){
Object[] obj2 = obj1[i].split(",");
sqlStr = "insert into xxxtable(param1,param2,param3,param4,param5,param6) values("+obj2[0]+",'"+obj2[1]+"',"+obj2[2]+","+obj2[3]+","+obj2[4]+",'"+obj2[5]+"');";
System.out.println(sqlStr);
}给8楼补充下 有些字符串 需要加单引号
String sqlStr = "";String abcString="4,开,1,222,222,CJ:5,开,1,333,333,CJ:6,开,1,444,444,CJ:24,开,1,999,999,KZ:25,开,1,888,888,KZ";
String[] obj1 = abcString.split(":");
for(int i=0; i<obj1.length;i++){
Object[] obj2 = obj1[i].split(",");
sqlStr = "insert into xxxtable(param1,param2,param3,param4,param5,param6) values("+obj2[0]+",'"+obj2[1]+"',"+obj2[2]+","+obj2[3]+","+obj2[4]+",'"+obj2[5]+"');";
System.out.println(sqlStr);
}给8楼补充下 有些字符串 需要加单引号
String sqlStr = "";String abcString="4,开,1,222,222,CJ:5,开,1,333,333,CJ:6,开,1,444,444,CJ:24,开,1,999,999,KZ:25,开,1,888,888,KZ";
String[] obj1 = abcString.split(":");
for(int i=0; i<obj1.length;i++){
Object[] obj2 = obj1[i].split(",");
sqlStr = "insert into xxxtable(param1,param2,param3,param4,param5,param6) values("+obj2[0]+",'"+obj2[1]+"',"+obj2[2]+","+obj2[3]+","+obj2[4]+",'"+obj2[5]+"');";
System.out.println(sqlStr);
}给8楼补充下 有些字符串 需要加单引号
String sqlStr = "";String abcString="4,开,1,222,222,CJ:5,开,1,333,333,CJ:6,开,1,444,444,CJ:24,开,1,999,999,KZ:25,开,1,888,888,KZ";
String[] obj1 = abcString.split(":");
for(int i=0; i<obj1.length;i++){
Object[] obj2 = obj1[i].split(",");
sqlStr = "insert into xxxtable(param1,param2,param3,param4,param5,param6) values("+obj2[0]+",'"+obj2[1]+"',"+obj2[2]+","+obj2[3]+","+obj2[4]+",'"+obj2[5]+"');";
System.out.println(sqlStr);
}
给8楼补充下 有些字符串 需要加单引号
含有6个属性以及对应的 get set 方法
}
然后
String[] strs = abcString.split(":");
String[] substr = null;
String sqlStr;
for(int i=0;i<strs.length;i++){
substr = strs[i].split(",");
你定义的类.set属性1(substr[0]);
类.set属性2(substr[1]);
..................
}
你不要理解错了
虚心求教,如果是放到一个 Ojbect 中该如何放呢? 我对Object 不是很了解,很迷糊
就是这一组字符串,是一个一个的放,还是怎么放方便 ,我对object不是很了解,虚心求教!
public class Object{
//含有6个属性以及对应的 get set 方法
prvate 类型 属性名称;
prvate 类型 属性名称;
.........
}
然后
String[] strs = abcString.split(":");
String[] substr = null;
String sqlStr;
List object_list=null;//定义一个LIST 存放很多对象
for(int i=0;i<strs.length;i++){
Object object=new Object(); //new 出一个对象的实例
substr = strs[i].split(",");
object.set属性1(substr[0]);
object.set属性2(substr[1]);
.................. 、
object_list.add(object);//把对象添加到LIST 中
}
这样够直接 够清楚了吧
public String[] strToArray(String str) {
StringTokenizer st = new StringTokenizer(str, ":");
String[] strArray = new String[st.countTokens()];
int strLeng = st.countTokens(); for (int i=0; i<strLeng; i++) {
strArray[i] = st.nextToken();
}
return strArray;
}//这样子,字符串就封装到字符串数组中了,你把字符串数组当参数再传递!
return list;
} public void setList(List<Object[]> list) {
this.list = list;
}然后 object[]从数据库里面取值