/*數(shù)據(jù)庫操作類OperateDatabase.java*/
import java.sql.*;
public class OperateDatabase
{
 Connection con;
 PreparedStatement prepare; 
 Statement  statement;
 public OperateDatabase(String datasource,String user,String pass)// 構(gòu)造方法
  {
   try
   {
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     con=DriverManager.getConnection("jdbc:odbc:"+ datasource, user,pass);
   }
   catch(Exception ee)
   { System.out.println("data source ERROR:"+ee); }
  }//構(gòu)造方法結(jié)束
 public int anyOperate(String sqlStr)  //執(zhí)行操作方法
  {
   try
   {
    statement=con.createStatement();  //建立語句對(duì)象
    statement.execute(sqlStr );  //執(zhí)行Sql操作
    return 1;    //操作成功
   } 
   catch(Exception err1)
   {
    System.out.println("執(zhí)行操作錯(cuò)誤："+err1);
    return 0;   //操作失敗
   }  
  } //執(zhí)行操作方法結(jié)束
}