ssh面试卷归类集锦.docVIP

有关数据库 mysql分页：select * from tableName limit 0,5;(从0开始，这个语句查询第 1，2，3，4，5条记录。第一个参数是指从那条开始，0表示从第一条开始，相当于数组中的下标。第二个参数指最多查询多少条记录)。 oracle分页： select x.* from (select z.*,rownum numbers from(select * from tableName where xxx order by yyy) z where rownum=currentPage*pageSize) x where x.numbers=(current1)*pageSize+1; 或者 select * from (select z.*,rownum numbers from(select * from tableName where xxx order by yyy) z where rownum=currentPage*pageSize) where numbers =(current1)*pageSize+1; jdbc工具类： public class JdbcUtils { private static JdbcUtils jdbcUtils=null; public JdbcUtils getInstance(){ if(null==jdbcUtils){ jdbcUtils=new JdbcUtils(); } return jdbcUtils; } static { try{ Class.forName(); }catch(Exception e){ e.printStackTrace(); } } private String url=; private String user=; private String password=; public Connection getConnection(){ Connection connection=null; try{ connection =DriverManager.getConnection(url, user, password); }catch(Exception e){ e.printStackTrace(); } return connection; } public void closeConnection(ResultSet rs,Statement st,Connection connection){ try{ if(null!=rs){ try{ rs.close(); }catch(Exception e){ e.printStackTrace(); } } }catch(Exception e){ e.printStackTrace(); }finally{ if(null!=st){ try{ st.close(); }catch(Exception e){ e.printStackTrace(); }finally{ if(null!=connection){ try{ connection.close(); }catch(Exception e){ e.printStackTrace(); } } } } } } } public class XxxDaoImp{ private JdbcUtils jdbcUtils=JdbcUtils.getInstance(); public List list(String sql){ Connection conn=jdbcUtils.getConnection(); //Statement st=null; PreparedStatement pst=null; ResultSet rs=null; List list=null; try{ //st=conn.createStatement(); //rs=st.executeQuery(sql); pst=conn.prepareStatement(sql); pst.setString(0, XXX); rs=pst.executeQuery();