ulmessage.java

软件上传下载网站,上传用户经过注册成为本站会员就可将将软件上传到本网站

package downreg;
import java.sql.*;
public class ULMessage
{
 int  L_Id=0,
      S_Id=0,
      I_Id=0;
Date    LMTime ;
String  MContent="",
        SWName="",
        user="";


Connection con = null;
Statement stmt = null;
ResultSet rs = null;
//String tableName="opinion_user";
public ULMessage()
{  String url="";
   String driverName="com.mysql.jdbc.Driver";
   String userName="root";
   String userPasswd="324802";
   String dbName="downreg";
   try
    {
         Class.forName(driverName).newInstance();
         url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd+"&useUnicode=true&characterEncoding=gb2312";
         con= DriverManager.getConnection(url);
         stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
    }
   catch (Exception e)
   {
   }
}


  public void setL_Id(int id)
  {
   L_Id=id;
  }
  public void setS_Id(int id)
  {
  S_Id=id;
  }

   public void setI_Id(int id)
   {
   I_Id=id;
   }
   public void setLMTime(Date time)
   {
     LMTime=time;
   }
   public void setMContent(String content)
   {
     MContent=content;
   }
   public void setSWNmae(String sname)
   {
   SWName=sname;
   }
   public void setUser(String name)
   {
    user=name;
   }
   public int getL_Id()
   {
   return  L_Id;
   }
   public int getS_Id()
   {
   return S_Id;
   }
   public int getI_Id()
   {
   return I_Id;
   }
   public Date getLMTime()
   {
   return LMTime;
   }
   public String getMContent()
   {
   return MContent;
   }
   public String getSWName()
   {
   return SWName;
   }
   public String getUser()
   {
   return user;
   }

public ResultSet AquireMessage() //得到留言
{
try{

 String condition="select * from opinion_user" ;
 rs=stmt.executeQuery(condition);


 }

catch(Exception e)
{
}
return rs;

}
/*public String FindSWName(int id) //根据软件ID找到软件的名称
{
 String sn="";
try{

 String condition="select S_Name from  software_1 where L_Id="+"'"+id+"'" ;
 rs=stmt.executeQuery(condition);
 if(rs.next())
 {
  sn=rs.getString(3);
 }
}
catch(Exception e)
{
}
return sn;

}  */

/*public String FindUserName(int id)//根据用户ID找到用户名称
{
  String  u="";
try{

 String condition="select I_Name from individual_user where I_Id="+"'"+id+"'";
  rs=stmt.executeQuery(condition);
  if(rs.next())
  {
   u=rs.getString(2);
  }
  else
  {
  String condition1="select C_Name from  corp_user where C_Id="+"'"+I_Id+"'";
  rs=stmt.executeQuery(condition1);
  rs.next();
  u=rs.getString(2);
  }
}
catch(Exception e)
{
}
return u;
}
*/


public String deleteAll()//删除所有留言
{
try{

  String deleteAll="delete  from  opinion_user";
  stmt.executeUpdate(deleteAll);
  return "删除成功" ;
  }
  catch(Exception e)
  {
  return "删除失败" ;
  }
}
public String deleteSingle(int id)//删除个别留言
{
try{

  String  only="delete from opinion_user where L_Id="+"'"+id+"'" ;
  stmt.executeUpdate(only);
  return "删除成功" ;

  }
  catch(Exception e)
  {
  return "删除失败" ;
  }
 }
public void close()
{
try
{
if(rs!=null)
{
rs.close();
}
if(stmt!=null)
{
stmt.close();
}
if(con!=null)
{
con.close();
}


}
catch (SQLException e)
{
}
}


}

// "i love you ,husband ", please  remember  it