Statement换成preparedStatement,就有相应的set方法了。
或者既然addBatch里面传入的是String类型,那我们自己构造,
stmt.addBatch(“insert into users values ("+"values1"+","+"values2"+")")
或者既然是users类,我们可以根据users中属性是否为初始值来自动生成inset语句,下面是我以前写的代码,仅供参考
注释:
1、下面的User.NAME等就是user中name属性在表中的列名
2、方法ConvertStr就是把插入的列的value加上单引号。
private static String ConvertStr(Object object) {
return "'" + object.toString() + "'"
}
3、其他
public static final String strIns = "insert into users("
public static final String strVal = ") values("
public static final String strEnd = ")"
4、调用
stmt.addBatch(User.InsetStr(user))//这样就不用考虑传参了
代码如下:
public static String InsetStr(User user) {String StrCol = ""
String Values = ""
if (user.getName() != null &&!user.getName().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.NAME
Values = Values + "," + ConvertStr(user.getName())
} else {
StrCol = StrCol + User.NAME
Values = Values + ConvertStr(user.getName())
}
}
if (user.getNick() != null &&!user.getNick().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.NICK
Values = Values + "," + ConvertStr(user.getNick())
} else {
StrCol = StrCol + User.NICK
Values = Values + ConvertStr(user.getNick())
}
}
if (user.getStudentid() != 0) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.STUDENTID
Values = Values + "," + ConvertStr(user.getStudentid())
} else {
StrCol = StrCol + User.STUDENTID
Values = Values + ConvertStr(user.getStudentid())
}
}
if (user.getSex() != '\u0000') {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.SEX
Values = Values + "," + ConvertStr(user.getSex())
} else {
StrCol = StrCol + User.SEX
Values = Values + ConvertStr(user.getSex())
}
}
if (user.getPassword() != null &&!user.getPassword().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.PASSWORD
Values = Values + "," + ConvertStr(user.getPassword())
} else {
StrCol = StrCol + User.PASSWORD
Values = Values + ConvertStr(user.getPassword())
}
}
if (user.getHash() != null &&!user.getHash().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.HASH
Values = Values + "," + ConvertStr(user.getHash())
} else {
StrCol = StrCol + User.HASH
Values = Values + ConvertStr(user.getHash())
}
}
if (user.getSchool() != null &&!user.getSchool().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.SCHOOL
Values = Values + "," + ConvertStr(user.getSchool())
} else {
StrCol = StrCol + User.SCHOOL
Values = Values + ConvertStr(user.getSchool())
}
}
if (user.getMajor() != null &&!user.getMajor().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.MAJOR
Values = Values + "," + ConvertStr(user.getMajor())
} else {
StrCol = StrCol + User.MAJOR
Values = Values + ConvertStr(user.getMajor())
}
}
if (user.getMobile() != 0) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.MOBILE
Values = Values + "," + ConvertStr(user.getMobile())
} else {
StrCol = StrCol + User.MOBILE
Values = Values + ConvertStr(user.getMobile())
}
}
if (user.getCollege() != null &&!user.getCollege().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.COLLEGE
Values = Values + "," + ConvertStr(user.getCollege())
} else {
StrCol = StrCol + User.COLLEGE
Values = Values + ConvertStr(user.getCollege())
}
}
if (user.getGrade() != 0) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.GRADE
Values = Values + "," + ConvertStr(user.getGrade())
} else {
StrCol = StrCol + User.GRADE
Values = Values + ConvertStr(user.getGrade())
}
}
if (user.getBclass() != null &&!user.getBclass().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.BCLASS
Values = Values + "," + ConvertStr(user.getBclass())
} else {
StrCol = StrCol + User.BCLASS
Values = Values + ConvertStr(user.getBclass())
}
}
if (user.getIdnum() != null &&!user.getIdnum().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.IDNUM
Values = Values + "," + ConvertStr(user.getIdnum())
} else {
StrCol = StrCol + User.IDNUM
Values = Values + ConvertStr(user.getIdnum())
}
}
if (user.getEmail() != null &&!user.getEmail().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.EMAIL
Values = Values + "," + ConvertStr(user.getEmail())
} else {
StrCol = StrCol + User.EMAIL
Values = Values + ConvertStr(user.getEmail())
}
}
if (user.getRegip() != null &&!user.getRegip().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.REGIP
Values = Values + "," + ConvertStr(user.getRegip())
} else {
StrCol = StrCol + User.REGIP
Values = Values + ConvertStr(user.getRegip())
}
}
if (user.getRegdate() != 0) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.REGDATE
Values = Values + "," + ConvertStr(user.getRegdate())
} else {
StrCol = StrCol + User.REGDATE
Values = Values + ConvertStr(user.getRegdate())
}
}
if (user.getUnit() != null &&!user.getUnit().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.UNIT
Values = Values + "," + ConvertStr(user.getUnit())
} else {
StrCol = StrCol + User.UNIT
Values = Values + ConvertStr(user.getUnit())
}
}
if (user.getRegion() != null &&!user.getRegion().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.REGION
Values = Values + "," + ConvertStr(user.getRegion())
} else {
StrCol = StrCol + User.REGION
Values = Values + ConvertStr(user.getRegion())
}
}
if (user.getDepartments() != null &&!user.getDepartments().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.DEPARTMENTS
Values = Values + "," + ConvertStr(user.getDepartments())
} else {
StrCol = StrCol + User.DEPARTMENTS
Values = Values + ConvertStr(user.getDepartments())
}
}
if (user.getTdcj() >0) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.TDCJ
Values = Values + "," + ConvertStr(user.getTdcj())
} else {
StrCol = StrCol + User.TDCJ
Values = Values + ConvertStr(user.getTdcj())
}
}
if (user.getTzcj() >0) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.TZCJ
Values = Values + "," + ConvertStr(user.getTzcj())
} else {
StrCol = StrCol + User.TZCJ
Values = Values + ConvertStr(user.getTzcj())
}
}
if (user.getAddress() != null &&!user.getAddress().equals("")) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.ADDRESS
Values = Values + "," + ConvertStr(user.getAddress())
} else {
StrCol = StrCol + User.ADDRESS
Values = Values + ConvertStr(user.getAddress())
}
}
if (user.getPostcode() != 0) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.POSTCODE
Values = Values + "," + ConvertStr(user.getPostcode())
} else {
StrCol = StrCol + User.POSTCODE
Values = Values + ConvertStr(user.getPostcode())
}
}
if (user.getBankcard() != 0) {
if (!StrCol.equals("")) {
StrCol = StrCol + "," + User.BANKCARD
Values = Values + "," + ConvertStr(user.getBankcard())
} else {
StrCol = StrCol + User.BANKCARD
Values = Values + ConvertStr(user.getBankcard())
}
}
return Sql.strIns + StrCol + Sql.strVal + Values + Sql.strEnd
}
group_contact刚好满足你的这个要求哦数据库的结构如下:
noitem
01AA
01BB
02CC
02DD
02EE
03FF
04GG
04HH
希望将no相同的列整合为一条记录如下
noitems
01AA,BB
02CC,DD,EE
03FF
04GG,HH
MYSQL中,直接有group_contact函数了,如下:
select id,group_contact(items) from TABLE group by id
具体连接方法如下:
1、打开HBuilder工具,在Web项目中的js文件夹中,新建JavaScript文件ConnDB.js
使用require()引入mysql模块,然后赋值给变量mysql
3、再调用createConnection()方法,设置主机、用户名、密码、端口和数据库
4、调用mysql模块中的connect()方法,连接mysql数据库
5、编写一个查询语句SQL,以字符串形式赋值给变量sql
6、最后调用query()方法,通过返回的值进行判断,然后打印返回成功的值
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)