article.java

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

package downreg;
import java.sql.*;
public class  article
{
int L_Id;
int I_Id=0;
String  articleTitle="";
String  articleContent="";
String  deliverTime="";
String  I_Name="";
String tableName="article_user";

   Connection con = null;
   Statement stmt = null;
   ResultSet rs = null;
   public article()
   {
   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 setI_Id(int id)
   {
   I_Id=id;
   }
   public void setI_Name(String name)
   {
   I_Name=name;
   }
   public void setArticleTitle(String title)
   {
   articleTitle=title;
   }
   public void setArticleContent(String content)
   {
    articleContent=content;
   }
   public void setDeliverTime(String dtime)
   {
   deliverTime=dtime;
   }

   public int getL_Id()
   {
    return L_Id;
   }
   public int getI_Id()
   {
   return I_Id;
   }
   public String getI_Name()
   {
   return I_Name;
   }
   public String getArticleTitle()
   {
   return articleTitle;
   }
   public String getArticleContent()
   {
   return  articleContent;
   }
   public String getDeliverTime()
   {
   return deliverTime;
   }

public ResultSet LookArticle() //查看文章
{
try
{

String condition="select * from article_user";
rs=stmt.executeQuery(condition);
}
catch(Exception e)
{
}
return rs;
}
public String deleteAll()  //删除所有文章
{
try
{

String condition="delete from article_user" ;
stmt.executeUpdate(condition);
return "删除成功" ;
}
catch(Exception e)
{
return "删除失败" ;
}
}
public String deleteSingle(int id)  //删除个别文章
{
try
{

String condition="delete from article_user where L_Id="+"'"+id+"'";
stmt.executeUpdate(condition);
return "删除成功" ;
}
catch(Exception e)
{
return "删除失败" ;
}
}

public void close()
{
try
{
if(rs!=null)
{
rs.close();
}
if(con!=null)
{
con.close();
}
if(stmt!=null)
{
stmt.close();
 }
}
catch (SQLException e)
{
}
}


}