databasemanager.java~3~

来自「出租车管理系统,为本人毕业设计. 还请大家多多指教了」· JAVA~3~ 代码 · 共 68 行

package car;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
import java.sql.*;

public class DataBaseManager {

    Connection con;
    ResultSet rs;
    Statement stmt;

    public DataBaseManager() {
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }catch(Exception e){}
        try{
            String url="jdbc:odbc:DBQ=D:\\开题报告\\毕设出租车\\car\\CarMessage_Data.MDF;DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)}";
            Connection con=DriverManager.getConnection(url);
            stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            //创建Statment对象，指定记录集可滚动，只读执行查询，返回结果集
        }catch(SQLException sqle){System.out.println(sqle.toString());}
    }

    public ResultSet getResult(String strSQL)//查询
        {
            try {
                rs = stmt.executeQuery(strSQL);
                //   System.out.print("sssss") ;
                return rs;

            } catch (SQLException sqle) {
                System.out.println(sqle.toString());
                // System.out.print("sssss") ;
                return null;
            }
        }

        public boolean updateSql(String strSQL)//修改
        {
            //    System.out.print("ddd") ;
            try {
                //   System.out.print("ddd") ;
                stmt.executeUpdate(strSQL); //System.out.print("dggd") ;
                return true;
            } catch (SQLException sqle) {
                System.out.println(sqle.toString());
                return false;
            }
        }
        public void closeConnection()
        {
                try{
                    con.close();
                }catch(SQLException sqle){System.out.println(sqle.toString());}
        }
}