beanutils中jdbc
public class JDBCTest {
// public static void main(String[] args) throws Exception {
// Class.forName("com.mysql.jdbc.Driver");
// Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "123456");
// Statement statement=conn.createStatement();
// ResultSet rs= statement.executeQuery("select *from stuinfo");
// Iterator rows=(new ResultSetDynaClass(rs)).iterator();
// while (rows.hasNext()) {
// DynaBean row=(DynaBean) rows.next();
// System.out.println(row.get("stuname"));
// }
// rs.close();
// statement.close();
// conn.close();
// }
public static void main(String[] args) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "123456");
Statement statement=conn.createStatement();
ResultSet rs= statement.executeQuery("select *from stuinfo");
RowSetDynaClass rstd=new RowSetDynaClass(rs);
rs.close();
statement.close();
conn.close();
List<DynaBean> list= rstd.getRows();
for (DynaBean dynaBean : list) {
System.out.println(dynaBean.get("stuname"));
}
}
}
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
