package dboprartion;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class BaseDao {

  public BaseDao() {}
  public static Connection dbCn(){
	  Connection com=null;
	 
	  try{
		  Class.forName("sun.jdbc.odbc.JdbcOdbcConnection");
		  com=DriverManager.getConnection("jdbc:odbc:test");
	  }catch(Exception e){
		  e.printStackTrace();
	  }
	 return com;
  }
  public int executeSQL(String sql,String[] parm){
	  int i=0;
	  Connection cn=null;
	  PreparedStatement ps=null;
	  try{
		  cn=dbCn();
		  ps=cn.prepareStatement(sql);
		  if(parm!=null)
			 for(int k=0;k<parm.length;k++){
				 ps.setString(k+1, parm[k]);
			 }
		  i=ps.executeUpdate();
		
	  }catch(SQLException ex){
		  System.out.print(ex.getMessage());
	  }
	  return i;
  }
}