operatedatabase.java

java学习课件

/*数据库操作类OperateDatabase.java*/
import java.sql.*;
public class OperateDatabase
{
 Connection con;
 PreparedStatement prepare; 
 Statement  statement;
 public OperateDatabase(String datasource,String user,String pass)// 构造方法
  {
   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); }
  }//构造方法结束
 public int anyOperate(String sqlStr)  //执行操作方法
  {
   try
   {
    statement=con.createStatement();  //建立语句对象
    statement.execute(sqlStr );  //执行Sql操作
    return 1;    //操作成功
   } 
   catch(Exception err1)
   {
    System.out.println("执行操作错误："+err1);
    return 0;   //操作失败
   }  
  } //执行操作方法结束
}