email.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

/*
 * Email.java
 *
 * Created on 2002年2月20日, 上午11:37
 */

package com.gs.email;
import java.util.*;
import com.gs.db.dbimp.*;
import com.gs.db.*;
import com.gs.util.Cacheable;
import com.gs.util.CacheSizes;

import java.util.Iterator;
import java.util.ArrayList;
import java.util.Date;

import java.sql.*;
/**
 *
 * @author  Administrator
 * @version 
 */
public class Email{

    private static final String NEXT_DETAIL_ID = "SELECT max(id) FROM emaildetail"; 
     private static final String ADD_DETAIL = 
    "insert into emaildetail (id,userid,emailtime,content,detail) values (?,?,?,?,?)";
     private  int id;
     private  int userid;
     private  long emailtime;
     private  String content;
     private  String detail;
    public Email(int userid,long emailtime,String content,String detail) 
    {
        this.userid = userid;
        this.emailtime = emailtime;
        this.content = content;
        this.detail = detail;
        this.id = counterID(NEXT_DETAIL_ID);
       
        Connection con = null;
        PreparedStatement pstmt = null;
        try {
            con = DbConnectionManager.getConnection();
            pstmt = con.prepareStatement(ADD_DETAIL);
            pstmt.setInt(1, id);
            pstmt.setInt(2, userid);
            pstmt.setLong(3, emailtime);
            pstmt.setString(4,content);
            pstmt.setString(5,detail);
            pstmt.executeUpdate();
        }
         catch( SQLException sqle ) {
            System.err.println( "SQLException in DbDocument.java:saveToDb(): " + sqle );
            sqle.printStackTrace();
        }
         finally {
            try {  pstmt.close(); }
            catch (Exception e) { e.printStackTrace(); }
            try {  con.close();   }
            catch (Exception e) { e.printStackTrace(); }
        }
    }
     public Email(int id,int userid,long emailtime,String content,String detail) 
    {
        this.id  = id;
        this.userid = userid;
        this.emailtime = emailtime;
        this.content = content;
        this.detail = detail;
    }
    public int counterID(String query){
        int currentID = 0;
        Connection con = null;
        PreparedStatement pstmt = null;
        try 
        {
            con = DbConnectionManager.getConnection();
            pstmt = con.prepareStatement(query);
            ResultSet rs = pstmt.executeQuery();
            if (rs.next())
            {
                currentID = rs.getInt(1);
                currentID = currentID + 1;
            }
            else 
            {
                currentID = 1;
            }
             
        }
        catch( Exception sqle ) 
        {
            System.err.println("Error in DbWork:getNextDbID()-" + sqle);
            sqle.printStackTrace();
        }
        finally
        {
            try {  pstmt.close(); }
            catch (Exception e) { e.printStackTrace(); }
            try {  con.close();   }
            catch (Exception e) { e.printStackTrace(); }
            return currentID;
        }
    }
    public int getID()
    {
        return this.id;
    }
    public int getUserID()
    {
        return this.userid;
    }
    public long getEmailTime()
    {
        return this.emailtime;
    }
    public String getContent()
    {
        return this.content;
    }
    public String getDetail()
    {
        return this.detail;
    }
    
}