dmlmessagerecord.java

我用JAVA写的QQ程序

/*
 * DMLMessageRecord.java
 *
 * Created on 2007年5月15日, 下午8:23
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package 服务器端程序包;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 *
 * @author 张金凤    8000104219  软件046班
 */
public class DMLMessageRecord {
    private SQLServerDatabase DataBase;
    private String SayFrom;
    private String SayTo;
    private String Content;
    
    /** Creates a new instance of DMLMessageRecord */
    public DMLMessageRecord() {
        try 
       {
            DataBase=new SQLServerDatabase();
       } 
       catch (SQLException ex) 
       {
            ex.printStackTrace();
       } 
       catch (ClassNotFoundException ex) 
      {
             ex.printStackTrace();
       }
    }
    public DMLMessageRecord(String from,String to,String content){
        SayFrom=from;
        SayTo=to;
        Content=content;
        try 
       {
            DataBase=new SQLServerDatabase();
       } 
       catch (SQLException ex) 
       {
            ex.printStackTrace();
       } 
       catch (ClassNotFoundException ex) 
      {
             ex.printStackTrace();
       }
    }
    public void Insert(){
       
       
       String sql="insert into MessageRecord  values('"+SayFrom+"','"+SayTo+"','"+Content+"')";
        try {
            DataBase.executeDML(sql);
           
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        
    }
    public ResultSet Query(){
        
        String sql="select * from MessageRecord ";
        ResultSet ResultData=null;
        try {
                ResultData=DataBase.ExecuteSelect(sql);
               
            } catch (SQLException ex) {
               ex.printStackTrace();
              }
        return ResultData;
    }
    
    
}