accessconn.java.bak

个人消费助理 早期的在学校的实训作品 使用ACCESS 数据库

package shophelper.database;
import java.sql.*;

public class AccessConn
{
	private Connection cn;
    private Statement st;
    private ResultSet rs;

    public AccessConn() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            cn = DriverManager.getConnection("jdbc:odbc:shop","sa","");
            
            cn.setCatalog("shop");//加载数据库
            System.out.println("数据库连接成功");
            st = cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                    ResultSet.CONCUR_READ_ONLY);

        } catch (Exception e) {
            System.out.println("sql exception c:"+e);
		}
    }

    public boolean executeSQL(String sqlString) {
        boolean executeFlag;
        try {
			System.out.println(sqlString);
            st.execute(sqlString);
            executeFlag = true;
        } catch (Exception e) {
            executeFlag = false;
            System.out.println("sql exception:" + e.getMessage());
        }
        return executeFlag;
    }


    public boolean query(String sqlString) {

        try {
            rs = null;
            System.out.println(sqlString);
            rs = st.executeQuery(sqlString);
        } catch (Exception Ex) {
            System.out.println("sql exception:" + Ex);
            return false;
        }
        return true;
    }

	public void close()
	{
		try
		{
			st.close();
			System.out.println("ST关闭");
		}
		catch (SQLException e)
		{	
			System.out.println(e+"》ST关闭异常");
		}
		try
		{
			cn.close();
			System.out.println("CN关闭");
		}
		catch (SQLException e)
		{	
			System.out.println(e+"》CN关闭异常");
		}
	}

	public ResultSet getRs()
	{
		return rs;
	}
}