JAVA语句的解释
初学JAVA 对这段代码不是很懂，哪位高手能够为小弟指点一二，将每句话的作用帮小弟注释一下，便于我理解我好尽快掌握 谢谢
public ArrayList zxSql(String sql) {
//sql="select * from b_lx_bm ";
Connection ct = null;
Statement sm = null;
ResultSet rs = null;
ArrayList rsList = new ArrayList();
Hashtable rec = null;
ResultSetMetaData meta = null;
int i, cc;
try {
ct = getOracleConnect();
sm = ct.createStatement();
rs = sm.executeQuery(sql);
meta = rs.getMetaData();
cc = meta.getColumnCount();
while (rs.next()) {
rec = new Hashtable();
for(i=1;i<=cc;i++){
String name = meta.getColumnLabel(i);
String type = meta.getColumnTypeName(i);
if(rs.getObject(name)!=null)
rec.put(name, rs.getObject(name));
else
rec.put(name, "");
}
rsList.add(rec);
i++;
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try{
sm.close();
rs.close();
ct.close();
}catch(Exception e){
}
return rsList;
}
} Java
[解决办法]
建议适当的使用谷歌和百度 或者看看java编程思想类似的图书 视频 了解的比较深入，我也是初级；见笑了
public ArrayList zxSql(String sql) {
// sql="select * from b_lx_bm ";
Connection ct = null;//连接
Statement sm = null;//陈述对象
ResultSet rs = null;//
ArrayList rsList = new ArrayList();
Hashtable rec = null;
ResultSetMetaData meta = null;
int i, cc;
try {
ct = getOracleConnect();//创建数据库连接
sm = ct.createStatement();//创建陈述对象
rs = sm.executeQuery(sql);// 编译sql语句，并执行
meta = rs.getMetaData();//取值
cc = meta.getColumnCount();
while (rs.next()) {
rec = new Hashtable();
for(i=1;i<=cc;i++){
String name = meta.getColumnLabel(i);
String type = meta.getColumnTypeName(i);
if(rs.getObject(name)!=null)
rec.put(name, rs.getObject(name));
else
rec.put(name, "");
}
rsList.add(rec);
i++;
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try{
sm.close();//关闭连接
rs.close();
ct.close();
}catch(Exception e){
}
return rsList;
}
}
