import java.sql.*;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.net.*;

public class ptform
{
   public ptform()
   { 
   }
   public synchronized boolean Saveptform()
   {    int nForumReference=0;
   	PreparedStatement ps=null; 
   	Connection con=null;
   	Statement stmt=null;
   	ResultSet rs=null;
      try{	
   	DatabaseManager3M dm=new DatabaseManager3M();
   	con=dm.getDbConnection();
        con.setAutoCommit(false);
        stmt=con.createStatement();
        AccessString accessStr=new AccessString();
        rs=stmt.executeQuery("select max(FRRFNBR)as nForum from FORUM");
         if(rs.next())
             nForumReference=rs.getInt("nForum");
             
        
        String ForumNameE=accessStr.getNewString(fm.getForumNameE());
        String ForumNameC=accessStr.getNewString(fm.getForumNameC());
        int nPublish=fm.getBPublish();
        int MemberID=fm.getMemberID();    
     //   int nLanguage=fm.getLanguageID();
        int nLanguage=1;
        
   	//String first=new String(first1.getBytes("ISO-8859-1"),"GBK");
   	
   	 Timestamp SystemTimestamp=new Timestamp(System.currentTimeMillis());
   	
   	//Timestamp timestamp=new Timestamp(Calendar.YEAR,Calendar.MONTH,Calendar.DATE,Calendar.HOUR,Calendar.MINUTE,Calendar.SECOND,10);
   	String sql="Insert into FORUM (FRRFNBR,FRMENBR, FRNAME1,FRNAME2,FRCSTMP,FRLUSTMP,FRPUB)Values(?,?,?,?,?,?,?)";
   	 ps=con.prepareStatement(sql);
   	 nForumReference++;
   	 
   	 ps.setInt(1,nForumReference);  //Forum reference
         ps.setInt(2,0);                //member reference
         ps.setString(3,ForumNameE);      //forum Name
         ps.setString(4,ForumNameC);
         ps.setTimestamp(5,SystemTimestamp);            //create date & time 
         ps.setTimestamp(6,SystemTimestamp);           //Time of lastest response
         ps.setInt(7,nPublish);              //Is it public,1=yes,0=no
       //Update the data to Forum
         ps.executeUpdate();
       //*************************  
         con.commit();
         con.setAutoCommit(true);
         rs.close();
   	 stmt.close();  
   	 con.close();
   
   	}catch(SQLException e)
   	{
   	  System.out.println("Error in Save Forum  :"+e); 	
   	  return false;
   	}	 
   	catch(Exception e)
   	{
           System.out.println(" Error in Save Forum"+e);   
           return false;		 
   	}	
     return true ;
   }
  
}