package cn.com.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import cn.com.entity.Class;
import cn.com.entity.Student;
import cn.com.utils.DBUtils;


public class ClassDao {
	Connection conn;
	PreparedStatement pst;
	ResultSet rs;
	
	
	public List<Class> classByshow(String sid) {
		// TODO Auto-generated method stub
		try {
			conn = DBUtils.getConn();
			String sql = "select * from student s,teacher t,class c where s.cid = c.cid and c.tid = t.tid and s.sid = ?";
			pst = conn.prepareStatement(sql);
			pst.setString(1, sid);
			rs = pst.executeQuery();
			List<Class> bylist = new ArrayList();
			while(rs.next()){
				Class cl = new Class();
				cl.setCid(rs.getInt("cid"));
				cl.setCname(rs.getString("cname"));
				cl.setCqq(rs.getString("cqq"));
				cl.setCxc(rs.getString("cxc"));
				cl.setTid(rs.getString("Tid"));
				cl.setTname(rs.getString("tname"));
				cl.setTphone(rs.getString("tphone"));
				bylist.add(cl);
				System.out.println(bylist+"???");
			}
			return bylist;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			DBUtils.closeResouce(conn, pst, rs);
		}
		return null;
	}


	public List<Class> showClass() {
		// TODO Auto-generated method stub
		// TODO Auto-generated method stub
				try {
					conn = DBUtils.getConn();
					String sql = "select * from class c,teacher t where  t.tid = c.tid";
					pst = conn.prepareStatement(sql);
				
					rs = pst.executeQuery();
					List<Class> bylist = new ArrayList();
					while(rs.next()){
						Class cl = new Class();
						cl.setCid(rs.getInt("cid"));
						cl.setCname(rs.getString("cname"));
						cl.setCqq(rs.getString("cqq"));
						cl.setCxc(rs.getString("cxc"));
						cl.setTid(rs.getString("Tid"));
						cl.setTname(rs.getString("tname"));
						cl.setTphone(rs.getString("tphone"));
						bylist.add(cl);
						System.out.println(bylist+"???+++++++++++++++++++++++");
					}
					return bylist;
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}finally{
					DBUtils.closeResouce(conn, pst, rs);
				}
				return null;
			
	}

}