package dao;

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

import modo.glyh;

public class glyhdao {
	public static List<glyh>cxlist=new ArrayList<glyh>();
	public List<glyh> getlist(){
		glyhdao1();
		return glyhdao.cxlist;
	}
	public void glyhdao1() {
		try {
			Class.forName("com.mysql.jdbc.Driver");  
			String url="jdbc:mysql://localhost:3306/eims?useUnicode=true&characterEncoding=gbk";
			Connection conn = null;
			Statement stmt = null;
			ResultSet rs = null;
			conn = (Connection) DriverManager.getConnection(url, "root", "root");
			stmt = (Statement) conn.createStatement();
			String sql="select * from staff";
			rs = stmt.executeQuery(sql);
			while(rs.next()) {
                cxlist.add(new glyh(rs.getString("staffName"), rs.getString("staffSex"), rs.getString("staffAge"), rs.getString("staffEducation"), rs.getString("staffDepartment"), rs.getString("staffDate"), rs.getString("staffDuty")));
            }
			
		} catch (ClassNotFoundException e1) {
			System.out.print("ClassNotFoundException错误");
			e1.printStackTrace();
		} catch (SQLException e) {
			System.out.print("数据库错误");
			e.printStackTrace();
		}
	}
	public  boolean pdff(String sql) {
		try {
			Class.forName("com.mysql.jdbc.Driver");  
			String url="jdbc:mysql://localhost:3306/eims?useUnicode=true&characterEncoding=gbk";
			Connection conn = null;
			Statement stmt = null;
			ResultSet rs = null;
			conn = (Connection) DriverManager.getConnection(url, "root", "root");
			stmt = (Statement) conn.createStatement();
			stmt.executeUpdate(sql);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			return false;
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}
	public  ResultSet pdff2(String sql) {
		ResultSet rs = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");  
			String url="jdbc:mysql://localhost:3306/eims?useUnicode=true&characterEncoding=gbk";
			Connection conn = null;
			Statement stmt = null;
			
			conn = (Connection) DriverManager.getConnection(url, "root", "root");
			stmt = (Statement) conn.createStatement();
			rs=stmt.executeQuery(sql);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return rs;
	}
	
   
}