package com.rjxy.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DAO {
	protected  Connection conn;
	protected   PreparedStatement pst;
	protected  ResultSet rs;
	protected  int rs2;
public	DAO(){
		this.lian();
	}
 public  void 	lian(){

		 try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			   conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DataBaseName=company","hehe","123456");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} 
	}
 public void select(String sql ,Object[] param){
	 try {
		pst=conn.prepareStatement(sql);
	 if(param !=null){
		 for(int i=0;i<param.length;i++){
			pst.setObject(i+1, param[i]);
			 
		 }
	 }
	 rs=pst.executeQuery();
	 
	 } catch (SQLException e) {

			e.printStackTrace();
		}
 }
 public void ZSG(String sql ,Object[] param){
	 try {
		pst=conn.prepareStatement(sql);
	 if(param !=null){
		 for(int i=0;i<param.length;i++){
			pst.setObject(i+1, param[i]);			 
		 }
	 }
	 rs2=pst.executeUpdate();
	 
	 } catch (SQLException e) {
			e.printStackTrace();
		}
	 
	 
 }
 public  void guan(){
	 try {
	 if(rs!=null){
		
			rs.close();
		
	 }
	 if(pst !=null){
		 pst.close();
	 }if(conn !=null){
		conn.close(); 
	 }
	 
	 
	 } catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	 
 }
	
	
	

}