package com.db;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import com.bean.lwbean;
import java.util.ArrayList;
public class Lworaretion {
    
public Lworaretion() {}
   public int addlw(lwbean lw){
	   int i=1;
	   Connection com=dbcn.getCn();
	   try{
		   String str="insert into leaveword (username,title,content,dat,tou,cf,replyname,replycontent,replydat,email) values(?,?,?,?,?,?,?,?,?,?)";
		   PreparedStatement ps=com.prepareStatement(str);
		   ps.setString(1, lw.getUsername());
		   ps.setString(2, lw.getTitle());
		   ps.setString(3, lw.getContent());
		   ps.setString(4, lw.getDat());
		   ps.setString(5, lw.getTou());
		   ps.setString(6, lw.getCf());
		   ps.setString(7, lw.getReplyname());
		   ps.setString(8, lw.getReplycontent());
		   ps.setString(9, lw.getReplydat());
		   ps.setString(10, lw.getEmail());
		   
		   ps.executeUpdate();
		  i=0;
   }catch(SQLException ex){
	   ex.printStackTrace();
   }
        return i;
   }
   public ArrayList sellw(){
	   ArrayList<lwbean> list=new ArrayList<lwbean>();
	   Connection com=dbcn.getCn();
	   try{
		   String str="select * from leaveword  order by id desc";
		   PreparedStatement ps=com.prepareStatement(str);
		   ResultSet rs=ps.executeQuery();
		  while(rs.next()){
			 lwbean ln=new  lwbean();
			  ln.setId(rs.getInt(1));
			  ln.setUsername(rs.getString(2));
			  ln.setTitle(rs.getString(3));
			  ln.setContent(rs.getString(4));
			  ln.setDat(rs.getString(5));
			  ln.setTou(rs.getString(6));
			  ln.setCf(rs.getString(7));
			  ln.setEmail(rs.getString(8));
			  ln.setReplycontent(rs.getString(9));
			  ln.setReplydat(rs.getString(10));
			  ln.setReplyname(rs.getString(11));
			  ln.setReplytitle(rs.getString(12));
			  list.add(ln);
		  }
   }catch(SQLException ex){
	   ex.printStackTrace();
   }
        return list;
   }
   public int selMag(String ur,int ps){
	   int i=1;
	   Connection com=dbcn.getCn();
	   try{
	      String str="select * from maneger where ur='"+ur+"'and ps='"+ps+"'";
	      PreparedStatement pst=com.prepareStatement(str);
	      pst.executeQuery();
	      i=0;
	   }catch(Exception e){
		   e.printStackTrace();
	   }
	   return i;
   }

   public int addrelw(lwbean lw){
	   int i=1;
	   Connection com=dbcn.getCn();
	   try{
		   String str="insert into leaveword (replyname,replycontent,replydat,tou) values(?,?,?,?)";
		   PreparedStatement ps=com.prepareStatement(str);
		   ps.setString(1, lw.getReplyname());
		   //ps.setString(2, lw.getReplytitle());
		   ps.setString(2, lw.getReplycontent());
		   ps.setString(3, lw.getReplydat());
		   ps.setString(4, lw.getTou());
		   ps.executeUpdate();
		  i=0;
   }catch(SQLException ex){
	   ex.printStackTrace();
   }
        return i;
   }
   public int dellw(int id1){
	   int i=1;
	   Connection com=dbcn.getCn();
	   try{
		   String str="delete  from leaveword where id=?";
		   PreparedStatement ps=com.prepareStatement(str);
		   ps.setInt(1, id1);
		   ps.executeUpdate();
		  i=0;
   }catch(SQLException ex){
	   ex.printStackTrace();
   }
        return i;
   }
}