firm.java

CMS（内容管理系统）

package com.via.databases;

import java.sql.*;
import java.util.*;

public class firm {
 String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";//数据库驱动
        //数据库连接字符串
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shopping;SelectMethod=cursor";
private Connection conn=null;
private Statement stmt=null;
private ResultSet rs=null;
  public firm() {
                         try {
                                Class.forName(sDBDriver);
                                 }
                             catch(java.lang.ClassNotFoundException e) {
                           System.err.println("firm(): " + e.getMessage());
                              }
                     }

  public ResultSet executeQuery(String sql) {
    rs = null;
    try {
    conn = DriverManager.getConnection(url,"sa","");
    stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    rs = stmt.executeQuery(sql);
    }
    catch(SQLException ex) {
      System.err.println("aq.executeQuery: " + ex.getMessage());
    }
    return rs;
  }

  public void executeUpdate(String sql) {
    stmt = null;
    rs=null;
    try {
    conn = DriverManager.getConnection(url,"sa","");
    stmt = conn.createStatement();
    stmt.executeUpdate(sql);
    stmt.close();
    conn.close();
    }
    catch(SQLException ex) {
      System.err.println("aq.executeQuery: " + ex.getMessage());
    }
  }

  public void closeStmt(){
    try{
      stmt.close();
     }
    catch(SQLException e){
      e.printStackTrace();
     }
  }
  public void closeConn(){
    try{
      conn.close();
     }
    catch(SQLException e){
      e.printStackTrace();
     }
  }
}