basedao.java

来自「法改革开放的离开概率地方了过了的开始了开放个蒂法个饭店抒发个」· Java 代码 · 共 39 行

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;
  }
}