JDK+JDBC+MySQL实例及注意事项
时间:2022-03-10 17:49
/**
* Using reflection to storage the result from database into Bean class.
*
*/
public static List<Object> resultSetToList(ResultSet rs, Class<?> cls) {
Method[] methods = cls.getDeclaredMethods();
int methodLength = methods.length;
int index;
Map<String, Integer> map = new HashMap<String, Integer>();
// record all methods name in a HashMap, for quickly locate.
for (index = 0; index < methodLength; index++) {
map.put(methods[index].getName().toLowerCase(), index);
}
ResultSetMetaData meta = null;
Object obj = null;
List<Object> list = new ArrayList<Object>();
try {
meta = rs.getMetaData();
int colCount = meta.getColumnCount();
while (rs.next()) {
obj = cls.newInstance();
for (int i = 1; i <= colCount; i++) {
String colName = meta.getColumnName(i);
String setMethodName = "set" + colName;
// System.out.println(setMethodName);
int j = map.get(setMethodName.toLowerCase()); //get index of method array
setMethodName = methods[j].getName();
Object value = rs.getObject(colName);
if(value == null){
continue;
}
try {
Method setMethod = obj.getClass().getMethod(setMethodName, value.getClass());
setMethod.invoke(obj, value);
} catch (Exception e) {
System.out.println(setMethodName + " exception");
e.printStackTrace();
}
}
list.add(obj);
}
} catch (InstantiationException | IllegalAccessException | SQLException e) {
e.printStackTrace();
}
return list;
}
mysql> describe cake;
+--------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| name | varchar(20) | NO | PRI | NULL | |
| serialNumber | int(10) unsigned | YES | | NULL | |
| buildDate | datetime | YES | | NULL | |
| isSweet | tinyint(1) unsigned | YES | | NULL | |
+--------------+---------------------+------+-----+---------+-------+
2)初始化的数据:
mysql> select * from cake; +--------+--------------+---------------------+---------+ | name | serialNumber | buildDate | isSweet | +--------+--------------+---------------------+---------+ | Danisa | 2021344 | 2013-11-19 10:20:00 | 1 | | Orion | 2004720 | 2014-06-29 22:00:00 | 0 | +--------+--------------+---------------------+---------+
4.2 Bean类设计
1)Cake类的属性:
private String name; private long serialNumber; private Timestamp buildDate; private boolean isSweet;
2)Bean中特殊值类型变量的Setter的设计细节:
JDK整形类型的setter参数需用java.lang中的类,如long对应java.lang.Long, int对应java.lang.Integer。
这样的动机是,可以使Bean的属性符合2中叙述的resultSetToList的形参Class<?> cls。
本例中,ResultSet取出的MySql的int unsigned,会自动在内存中转化为Long类型,故setter需要使用Long;
public void setSerialNumber(Long /*long*/ serialNumber) { //Type was java.lang.Long but not 'long'. this. serialNumber = serialNumber; }
从MySql取出的tinyint(1)存为Boolean,故Bean类的setter形参是Boolean类型。
此外,属性isSweet在eclipse中自动生成的setter名为setSweet,在反射赋值时,就会出现找不到方法的异常,因为反射赋值搜索的方法是‘setissweet‘,所以要把自动生成的setter改名。
public void /*setSweet*/setIsSweet( /*boolean*/Boolean isSweet) { // Type was java.lang.Boolean but not boolean this. isSweet = isSweet; }
JDK+JDBC+MySQL实例及注意事项,布布扣,bubuko.com