package com.bdqn.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 java.util.Map;

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

public class InsertDao {
	Connection conn = null;
	PreparedStatement ps = null;
	ResultSet rs = null;

	// 查询的方法
	public List<Student> selectAll() {
		List<Student> list = new ArrayList<Student>();
		String sql = "select * from student";
		Object[] obj = {};
		ps = DbUtil.executeSql(sql, obj);
		try {
			rs = ps.executeQuery();
			while (rs.next()) {
				Student stu = new Student();
				stu.setId(rs.getInt("id"));
				stu.setName(rs.getString("name"));
				stu.setClassid(rs.getInt("classid"));
				list.add(stu);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	// 使用int类型传递参数
	public int StudentInsert(String name, int classid) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { name, classid };
		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;
	}

	// 使用int类型传递对象
	public int StudentInsert(Student stu) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { stu.getName(), stu.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 StudentInserts(String name, int classid) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { name, classid };
		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;
	}

	// 使用boolean类型传递对象
	public boolean StudentInserts(Student stu) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { stu.getName(), stu.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;
	}

	// 使用对象类型传递参数
	public Student StudentInsert1(String name, int classid) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { name, classid };
		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;
	}

	// 使用对象类型传递对象
	public Student StudentInsert1(Student stu) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { stu.getName(), stu.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 stu;
	}

	// 使用String类型传递参数
	public String studentString2(String name, int classid) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { name, classid };
		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 name;
	}

	// 使用String类型传递对象
	public String studentString2(Student stu) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { stu.getName(), stu.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;
	}

	// 使用list类型传递参数
	public List<Student> StudentInsert3(String name, int classid) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { name, classid };
		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;
	}

	// 使用list类型传递对象
	public List<Student> StudentInsert3(Student stu) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { stu.getName(), stu.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, String> StudentInsert4(String name, int classid) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { name, classid };
		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, String> StudentInsert4(Student stu) {
		String sql = "insert into student values(null,?,?)";
		Object[] obj = { stu.getName(), stu.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;
	}
}