testeditioncontrol.java

一个完整的网络订餐系统

package com.common;

import java.sql.*;

public class TestEditionControl
{

    public TestEditionControl()
    {
    }

     public int getRecCount(String ownCompID)
    {
        int recCount;
        recCount = 0;
        DBConnection dbc = null;
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String strSQL = null;
        try
        {
            dbc = new DBConnection();
            conn = dbc.getDBConnection();
            stmt = conn.createStatement();
            strSQL = "SELECT count(*) FROM TestEdControl where own_comp_id='"+ownCompID+"'";
            rs = stmt.executeQuery(strSQL);
            if(rs.next())
                recCount = rs.getInt(1);
            rs.close();
            rs = null;
        }
        catch(Exception exception) { }
        finally
        {
            try
            {
                if(rs != null)
                    rs.close();
                if(stmt != null)
                    stmt.close();
                if(conn != null)
                    dbc.closeDBConnection(conn);
            }
            catch(SQLException e) { }
        }
        return recCount;
    }


    public Date getLastLoginTime(String ownCompID)
    {
      Date tmpDate;
      tmpDate = null;
      DBConnection dbc = null;
      Connection conn = null;
      Statement stmt = null;
      ResultSet rs = null;
      String strSQL = null;
      try {
        dbc = new DBConnection();
        conn = dbc.getDBConnection();
        stmt = conn.createStatement();
        strSQL = "SELECT LastLoginTime FROM TestEdControl where own_comp_id='"+ownCompID+"'";
        rs = stmt.executeQuery(strSQL);
        if (rs.next())
          tmpDate = rs.getDate(1);
        rs.close();
        rs = null;
      }
      catch (Exception exception) {}
      finally {
        try {
          if (rs != null)
            rs.close();
          if (stmt != null)
            stmt.close();
          if (conn != null)
            dbc.closeDBConnection(conn);
        }
        catch (SQLException e) {}
      }
      return tmpDate;
    }




    public int getUsedDays(String ownCompID)
    {
        int tmp;
        tmp = 0;
        DBConnection dbc = null;
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String strSQL = null;
        try
        {
            dbc = new DBConnection();
            conn = dbc.getDBConnection();
            stmt = conn.createStatement();
            strSQL = "SELECT UsedDays FROM TestEdControl where own_comp_id='"+ownCompID+"'";
            rs = stmt.executeQuery(strSQL);
            if(rs.next())
                tmp = rs.getInt(1);
            rs.close();
            rs = null;
        }
        catch(Exception exception) { }
        finally
        {
            try
            {
                if(rs != null)
                    rs.close();
                if(stmt != null)
                    stmt.close();
                if(conn != null)
                    dbc.closeDBConnection(conn);
            }
            catch(SQLException e) { }
        }
        return tmp;
    }



    public int getTotalDays(String ownCompID)
    {
        int tmp;
        tmp = 0;
        DBConnection dbc = null;
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String strSQL = null;
        try
        {
            dbc = new DBConnection();
            conn = dbc.getDBConnection();
            stmt = conn.createStatement();
            strSQL = "SELECT TotalDays FROM TestEdControl where own_comp_id='"+ownCompID+"'";
            rs = stmt.executeQuery(strSQL);
            if(rs.next())
                tmp = rs.getInt(1);
            rs.close();
            rs = null;
        }
        catch(Exception exception) { }
        finally
        {
            try
            {
                if(rs != null)
                    rs.close();
                if(stmt != null)
                    stmt.close();
                if(conn != null)
                    dbc.closeDBConnection(conn);
            }
            catch(SQLException e) { }
        }
        return tmp;
    }




    public void updateRec(String ownCompID)
    {
      DBConnection dbc = null;
      Connection conn = null;
      Statement stmt = null;
      String strSQL = null;
      int curUsedDays = getUsedDays(ownCompID);
      curUsedDays++;
      try {
        dbc = new DBConnection();
        conn = dbc.getDBConnection();
        stmt = conn.createStatement();
        strSQL = "UPDATE TestEdControl SET UsedDays = " + curUsedDays +
            ", LastLoginTime=getdate() where own_comp_id='"+ownCompID+"'";
        stmt.executeUpdate(strSQL);
      }
      catch (Exception exception) {}
      finally {
        try {
          if (stmt != null)
            stmt.close();
          if (conn != null)
            dbc.closeDBConnection(conn);
        }
        catch (SQLException e) {}
      }
      return;
    }

}