package cn.com.dao;

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

import cn.com.bean.Score;
import cn.com.bean.Student;

public class ScoreDao {

	
	
	public  List score(String name){
		Connection con=null;
	    Statement stmt=null;
	    ResultSet rs=null;
	    
	     con = ConManager.getConnection();
	     try {
			stmt = con.createStatement();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			rs = stmt.executeQuery("select * from score where name="+"'"+name+"'");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		List list1 = new ArrayList();
		
		try {
			while (rs.next()){
				Score sc=new Score();
				sc.setKecheng(rs.getString(1));
				sc.setName(rs.getString(3));
				sc.setScore(rs.getInt(2));
				list1.add(sc);
				
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list1;
	}
	
	
	
	
	public void insert(Score score)
	{
		Connection con=null;
		PreparedStatement pstmt=null;
	    ResultSet rs=null;
	    
	     con = ConManager.getConnection();
		try {
			pstmt=con.prepareStatement("insert into score value(?,?,?) ");
			pstmt.setString(1, score.getKecheng());
			pstmt.setInt(2,score.getScore());
			pstmt.setString(3,score.getName());
			pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
	
	
	public void update(String kecheng,int score,String name)
	{
		Connection con=null;
		PreparedStatement pstmt=null;
	    ResultSet rs=null;
	    
	     con = ConManager.getConnection();
		try {
			pstmt=con.prepareStatement("update score set score= "+score+" where kecheng='"+kecheng+"'"+ "and name='"+name+"'");
			pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	
	public void delete(String name,String kecheng)
	{
		Connection con=null;
	    Statement stmt=null;
	    ResultSet rs=null;
	    
	     con = ConManager.getConnection();
	     try {
			stmt = con.createStatement();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			stmt.executeUpdate("delete from score where name='"+name+"' and kecheng= '"+kecheng+"'");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
	
	public void sdelete(String name)
	{
		Connection con=null;
	    Statement stmt=null;
	    ResultSet rs=null;
	    
	     con = ConManager.getConnection();
	     try {
			stmt = con.createStatement();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			stmt.executeUpdate("delete from score where name='"+name+"'");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
}