email.java

2．打开“命令行提示符”； 3．输入mysql –u root - p命令

package com.ch9;

import java.sql.*;

public class email extends Execute_DB
{ 
	//定义类成员变量
	private long EmailID;
	private String EmailSubject;
	private String EmailContent;
	private String EmailSender;
	private String EmailReceiver;
	private String CreateTime;
	private int EmailType;
	private int Tag;
	private String strSql;   
	
    //构造函数，对成员变量进行初始化赋值	
	public email()
	{
		super(); 
		this.EmailID=0;
		this.EmailSubject="";
		this.EmailContent="";
		this.EmailSender="";
		this.EmailReceiver="";
		this.EmailType=0;
		this.Tag=0;
		java.util.Date NowTime = new java.util.Date();
		this.CreateTime = NowTime.toLocaleString();
		this.strSql=""; 
	}

	//在email数据表中添加一条新记录
	public boolean add_email()
	{
		this.strSql="insert into email";
		this.strSql=this.strSql + " (EmailSubject,EmailContent,EmailSender,EmailReceiver,CreateTime,EmailType,Tag) ";
		this.strSql=this.strSql + "values('" + this.EmailSubject + "','" + this.EmailContent + "','" + this.EmailSender + "','" + this.EmailReceiver + "','" + this.CreateTime + "','" + this.EmailType + "','" + this.Tag + "')";   
		
		boolean isAdd = super.exeSql(this.strSql);
		return isAdd;	
	}
	
	//删除属于某个集合中的邮件
	public boolean delete_email(String s_EmailID)
	{
		this.strSql="delete from email";
		this.strSql=this.strSql + "  where EmailID in ("+s_EmailID+")";
		
		boolean isDelete = super.exeSql(this.strSql);      
		return isDelete;	
	}

  	//获取邮件详细信息，将这些信息赋值给相应的类变量
	public boolean  init()
	{
		this.strSql="select * from email";
		this.strSql=this.strSql + " where EmailID='" + this.EmailID + "'";

		try
		{
			ResultSet rs = super.exeSqlQuery(this.strSql);
			if (rs.next())
			{
				this.EmailID=rs.getLong("EmailID");
				this.EmailSubject=rs.getString("EmailSubject");
				this.EmailContent=rs.getString("EmailContent");
				this.EmailSender=rs.getString("EmailSender");
				this.EmailReceiver=rs.getString("EmailReceiver");
				this.CreateTime=rs.getString("CreateTime"); 
				this.EmailType=rs.getInt("EmailType");
				this.Tag=rs.getInt("Tag");
				return true;
			}
			else
			{               
				return false;
			}	
		}
		catch(Exception ex)
		{			
			System.out.println(ex.toString());            
			return false;
		}
	}

	//获得EmailReceiver对应的接收邮件信息，返回一个ResultSet类型对象
	public ResultSet rec_list()
	{
		this.strSql="select * from email where EmailReceiver=";
		this.strSql=this.strSql + "'" + this.EmailReceiver + "' and EmailType=0 order by CreateTime desc";
		try
		{
			ResultSet rs = super.exeSqlQuery(this.strSql);
			if(rs == null)
			{
				System.out.println("test"); 			
			}               
                                  
			return rs;          
		}
		catch(Exception ex)
		{			
			System.out.println(ex.toString()); 
			return null;
		}
	}

	//获得EmailSender对应的发送邮件信息，返回一个ResultSet类型对象
	public ResultSet  send_list()
	{
		this.strSql="select * from email where EmailSender=";
		this.strSql=this.strSql + "'" + this.EmailSender + "' and EmailType=1";
		try
		{
			ResultSet rs = super.exeSqlQuery(this.strSql);    
			return rs;  
		}
		catch(Exception ex)
		{			
			System.out.println(ex.toString()); 
			return null;
		}
	}
	
 	//获得EmailReceiver对应的未读邮件数
	public int new_email_count()
	{
		this.strSql="select count(*) as x from email where EmailReceiver=";
		this.strSql=this.strSql + "'" + this.EmailReceiver + "' ";
		this.strSql=this.strSql + " and EmailType=0 and Tag = 0";
		try
		{
			ResultSet rs = super.exeSqlQuery(this.strSql);   
			int newEmail = 0;
			if (rs.next())
			{                  
				newEmail = rs.getInt("x");
			}                      
			return newEmail;			
		}
		catch(Exception ex)
		{			            
			System.out.println(ex.toString()); 
			return -1;
		}
	}   
	
	//获得EmailReceiver对应的接收邮件数
	public int rec_email_count()
	{
		this.strSql="select count(*) as x from email where EmailReceiver=";
		this.strSql=this.strSql + "'" + this.EmailReceiver + "' and EmailType=0";
		try
		{
			ResultSet rs = super.exeSqlQuery(this.strSql);   
			int newEmail = 0;
			if (rs.next())
			{                  
				newEmail = rs.getInt("x");
			}                      
			return newEmail;			
		}
		catch(Exception ex)
		{			            
			System.out.println(ex.toString()); 
			return -1;
		}
	}   
	
	//获得EmailSender对应的发送邮件数
	public int send_email_count()
	{
		this.strSql="select count(*) as x from email where EmailSender=";
		this.strSql=this.strSql + "'" + this.EmailSender + "' and EmailType=1";
		try
		{
			ResultSet rs = super.exeSqlQuery(this.strSql);   
			int newEmail = 0;
			if (rs.next())
			{                  
				newEmail = rs.getInt("x");
			}                      
			return newEmail;			
		}
		catch(Exception ex)
		{			            
			System.out.println(ex.toString()); 
			return -1;
		}
	}   


	//更改类成员变量tag的值
	public boolean update_tag()
	{
		this.strSql="update email set ";
		this.strSql=this.strSql + " Tag=" + "'" + 1 + "'";
		this.strSql=this.strSql + " where EmailID='" + this.EmailID + "'";
		boolean updateTag = super.exeSql(strSql);		
		return updateTag;
	}
   
   	//设置类成员变量EmailID的值 
	public void setEmailID(long EmailID)
	{
		this.EmailID = EmailID;	
	}

	//获取类成员变量EmailID的值  
	public long getEmailID()
	{
		return this.EmailID;	
	}

	//设置类成员变量EmailSubject的值  
 	public void setEmailSubject(String EmailSubject)
	{
		this.EmailSubject = EmailSubject;	
	}
   
	//获取类成员变量EmailSubject的值  
	public String getEmailSubject()
	{
		return this.EmailSubject;	
	}

	//设置类成员变量EmailContent的值  
 	public void setEmailContent(String EmailContent)
	{
		this.EmailContent = EmailContent;	
	}
   
	//获取类成员变量EmailContent的值  
	public String getEmailContent()
	{
		return this.EmailContent;	
	}
 
 	//设置类成员变量EmailSender的值 
 	public void setEmailSender(String EmailSender)
	{
		this.EmailSender = EmailSender;	
	}   

	//获取类成员变量EmailSender的值  
	public String getEmailSender()
	{
		return this.EmailSender;	
	}  

	//设置类成员变量EmailReceiver的值  
 	public void setEmailReceiver(String EmailReceiver)
	{
		this.EmailReceiver = EmailReceiver;	
	}
   
	//获取类成员变量EmailReceiver的值  
	public String getEmailReceiver()
	{
		return this.EmailReceiver;	
	}

	//设置类成员变量CreateTime的值  
 	public void setCreateTime(String CreateTime)
	{
		this.CreateTime = CreateTime;	
	}
   
	//获取类成员变量CreateTime的值  
	public String getCreateTime()
	{
		return this.CreateTime;	
	}
 
 	//设置类成员变量EmailType的值 
 	public void setEmailType(int EmailType)
	{
		this.EmailType = EmailType;	
	}   

	//获取类成员变量EmailType的值  
	public int getEmailType()
	{
		return this.EmailType;	
	}  

 	//设置类成员变量Tag的值 
 	public void setTag(int Tag)
	{
		this.Tag = Tag;	
	}   

	//获取类成员变量Tag的值  
	public int getTag()
	{
		return this.Tag;	
	} 

}