jdbc面试题

1. JDBC中大数据量的分页解决方法？

oracle:
//方法1
select * from 
(select *,rownum as tempid from student ) t 
where t.tempid between ” + pageSize*(pageNumber-1) + ” and ” + pageSize*pageNumber
//方法二：
select * from 
  ( select rownum r,a from tabName where rownum <= pageSize*pageNumber ) 
where r >  pageSize*(pageNumber-1)

mysql: 
select * from students limit ” + pageSize*(pageNumber-1) + “,” + pageSize;

sql server: 
select top ” + pageSize + ” * from students where id not in + 
(select top ” + pageSize * (pageNumber-1) + id from students order by id) + 
“order by id;

2.复制表数据和结构（创建新表）

create table user_new as select * from user 或者 create table user_new like user

3.JDBC中的Statement 和PreparedStatement的区别？

PreparedStatement是预编译的SQL语句，效率高于Statement。 
PreparedStatement支持?操作符，相对于Statement更加灵活。 
PreparedStatement可以防止SQL注入，安全性高于Statement。