java_JDBC---------分页
package com.db; import java.sql.*; /** * * 连接sql server2000 * @author 赵永恩 * */public class Jdbc{ String dbUrl="jdbc:sqlserver://localhost:1433; DatabaseName=SczwWeb"; String theUser="sa"; String thePw=""; Connection c=null; Statement conn; ResultSet rs=null; public Jdbc(){ try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance(); c = DriverManager.getConnection(dbUrl,theUser,thePw); //创建滚动结果集 需要把创建stme对象后多加两个参数ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLEconn=c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); }catch(Exception e){ e.printStackTrace(); } } /** * 更新 * @param sql * @return */public boolean executeUpdate(String sql){ try { conn.executeUpdate(sql); return true; } catch (SQLException e) { e.printStackTrace(); return false; } } /** * 查询 * @param sql * @return */public ResultSet executeQuery(String sql) { rs=null; try { rs=conn.executeQuery(sql); } catch (SQLException e) { e.printStackTrace(); } return rs; } /** * 关闭数据库 */public void close() { try { conn.close(); c.close(); } catch (Exception e) { e.printStackTrace(); } } }
