package com.dao;
import java.util.List;
import java.util.ArrayList;
import com.src.Student;
import com.tool.JDBCConnection;
import java.sql.ResultSet;
import java.sql.SQLException;
public class StudentDaoImp implements StudentDao {
  private JDBCConnection conn;
  private List list;
  private Student stu;
  public StudentDaoImp()
  {
    conn=new JDBCConnection();
  }
  private boolean update(String sql)
  {
  if(  conn.excuteUpdate(sql))
   return true;
 else
   return false;
  }
  public List excuteQuery()
  {
    String sql="select * from student";
    return this.queryAll(sql);
  }
  public List  queryAll(String sql)
  {
    ResultSet rs=conn.excuteQuery(sql);
    list=new ArrayList();

    try
    {
      while (rs.next()) {
        stu=new Student();
        stu.setNo(rs.getString(1));
        stu.setSex(rs.getString(2));
        stu.setAge(rs.getInt(3));
        stu.setName(rs.getString(4));
        stu.setsClass(rs.getString(5));
        stu.setSalary(rs.getFloat(6));
        list.add(stu);
      }

    }
    catch(SQLException ex)
    {
    ex.printStackTrace();
    }
    return list;
  }
  public boolean QueryBy(String sql)
  {

    try
    {
    ResultSet rs= conn.excuteQuery(sql);
    if(rs.next())
      return true;
    }
    catch(SQLException ex)
    {

    }
    return false;
  }



  public Student excuteQueryByNo(String no)
  {
    String sql="select * from student where sno='"+no+"'";
    ResultSet rs=conn.excuteQuery(sql);
   stu=new Student();
   try
   {
     if (rs.next()) {
       stu.setNo(rs.getString(1));
       stu.setSex(rs.getString(2));
       stu.setAge(rs.getInt(3));
       stu.setName(rs.getString(4));
       stu.setsClass(rs.getString(5));
        stu.setSalary(rs.getFloat(6));
     }

   }
   catch(SQLException ex)
   {
   ex.printStackTrace();
   }

    return stu;
  }
  public boolean excuteQueryNo(String no)
 {
   String sql="select * from student where sno='"+no+"'";
   ResultSet rs=conn.excuteQuery(sql);
  try
  {
    if (rs.next()) {
      return true;
    }
  }
  catch(SQLException ex)
  {
  ex.printStackTrace();
  }

   return false;
 }

  public  boolean excuteDelete(String no)
  {
    String sql="delete from student where sno='"+no+"'";
    return this.update(sql);
  }
  public boolean excuteInsert(Student stu)
  {
    String sql="insert into student(sno,ssex,sage,sname,sclass,salary) values('"+stu.getNo()+"','"+stu.getSex()
        +"',"+stu.getAge()+",'"+stu.getName()+"','"+stu.getsClass()+"',"+stu.getSalary()+")";
    return this.update(sql);
  }
  public boolean excuteUpdate(Student stu)
  {
   String sql="update student set ssex='"+stu.getSex()+"',sname='"+stu.getName()+"',sclass='"+
   stu.getsClass()+"',sage="+stu.getAge()+","+stu.getSalary()+" where sno='"+stu.getNo()+"'";
   return this.update(sql);
  }
}