[java]view plaincopy
[java]view plaincopy
增,删,改是比较简单的
接下来是查询
[java]view plaincopy
[java]view plaincopy
/** * * @param sql * @param obj * @return */ public static List> select(String sql , Object...obj){
//创建list集合 List> list = new ArrayList>(); Connection conn = JDBCUtils.getConn(); PreparedStatement pstmt = null; ResultSet rs = null; try { pstmt = conn.prepareStatement(sql); if(obj!=null&&obj.length>=1){ for (int i = 0; i < obj.length; i++) { pstmt.setObject(i+1, obj[i]); } } rs = pstmt.executeQuery();