package dao;

import entity.Sinhvien;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;

public class UserDAO {

    Connection conn = null;

    public UserDAO() {
        String dbUrl = "jdbc:sqlserver://Dell3560-PC:1433;databasename=daotao;username=sa;password=123456";
        String dbClass = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
        try {
            Class.forName(dbClass);
            conn = DriverManager.getConnection(dbUrl);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void insertSv(Sinhvien sv) {
        String sql = "Insert Into sinhvien( hoten, coso) "
                + "Values(?,?)";
        PreparedStatement ps;
        try {
            ps = conn.prepareStatement(sql);
            ps.setString(1, sv.getHoten());
            ps.setInt(2, sv.getCoso());

//            if(ps.executeUpdate()>0){
//                updateTimeStory(story, new Timestamp(System.currentTimeMillis()));
//                return true;
//            }
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();

        }

    }

    public ArrayList<Sinhvien> getListSinhvien() {
        String query = "Select * FROM sinhvien ";
        Statement stm;
        try {
            stm = conn.createStatement();
            ResultSet rs = stm.executeQuery(query);
            ArrayList<Sinhvien> listSv = new ArrayList<Sinhvien>();
            while (rs.next()) {
                Sinhvien sv = new Sinhvien();
                sv.setId(rs.getInt("id"));
                sv.setHoten(rs.getString("hoten"));
                sv.setCoso(rs.getInt("coso"));
                listSv.add(sv);
            }
            System.out.println("size ds: "+listSv.size());
            return listSv;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        System.out.println("danh sach rong");
        return null;
    }

    public boolean syncDB(){
        boolean checkvar= false;
        try {
            String sql= "exec msdb.dbo.sp_start_job N'DELL3560-PC-Daotao-DaotaoPub-TRANQUANGVINH-17'";
           CallableStatement cs = conn.prepareCall(sql);
           checkvar = cs.execute();
           return checkvar;
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return checkvar;
    }

    public static void main(String[] args) {
        //System.out.println(new UserDAO().syncDB());
        new UserDAO().getListSinhvien();
    }
}