package com.bdqn.dao;

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

import com.bdqn.entity.Student;
import com.bdqn.util.DbUtil;

public class UpdateDao {
	Connection conn = null;
	PreparedStatement ps =null;
	ResultSet rs = null;
	
	//使用int类型传递参数
	public int StudentUpdate(String name ,int classid,String name1,int classid1){
		String sql = "Update student set name=?,classid=? where name=? and classid=?";
		Object [] obj = {name,classid,name1,classid1};
		ps = DbUtil.executeSql(sql, obj);
		try {
			int num = ps.executeUpdate();
			if(num>0){
				System.out.println("修改成功！");
			}else{
				System.out.println("修改失败！");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return classid;
	}
	
	//使用int类型传递对象
	public int StudentUpdate(Student stu,Student stu1){
		String sql = "Update student set name=?,classid=? where name=? and classid=?";
		Object [] obj = {stu.getName(),stu.getClassid(),stu1.getName(),stu1.getClassid()};
		ps = DbUtil.executeSql(sql, obj);
		try {
			int num = ps.executeUpdate();
			if(num>0){
				System.out.println("修改成功！");
			}else{
				System.out.println("修改失败！");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return 0;
	}
	/**
	 * 后面的跟前面的类似，后面只展示传递对象方式
	 */
	//使用boolean类型
	public boolean StudentUpdate1(Student stu,Student stu1){
		String sql = "Update student set name=?,classid=? where name=? and classid=?";
		Object [] obj = {stu.getName(),stu.getClassid(),stu1.getName(),stu1.getClassid()};
		ps = DbUtil.executeSql(sql, obj);
		try {
			int num = ps.executeUpdate();
			if(num>0){
				System.out.println("修改成功！");
				return true;
			}else{
				System.out.println("修改失败！");
				return false;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return false;
	}
	
	//使用list方式
	public List<Student> StudentUpdate2(Student stu,Student stu1){
		String sql = "Update student set name=?,classid=? where name=? and classid=?";
		Object [] obj = {stu.getName(),stu.getClassid(),stu1.getName(),stu1.getClassid()};
		ps = DbUtil.executeSql(sql, obj);
		try {
			int num = ps.executeUpdate();
			if(num>0){
				System.out.println("修改成功！");
			}else{
				System.out.println("修改失败！");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	//使用map方式
	public Map<Student, Student> StudentUpdate3(Student stu,Student stu1){
		String sql = "Update student set name=?,classid=? where name=? and classid=?";
		Object [] obj = {stu.getName(),stu.getClassid(),stu1.getName(),stu1.getClassid()};
		ps = DbUtil.executeSql(sql, obj);
		try {
			int num = ps.executeUpdate();
			if(num>0){
				System.out.println("修改成功！");
			}else{
				System.out.println("修改失败！");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
}