dbcon.java

宠物医院 JSP项目 我是一个初学者 请大家多多指教

package da0;

import java.sql.*;

public class DBcon {
    private Connection con = null;

    public DBcon() {
    }

    public Connection GetConnection() {
        try {
            /*String driverClassName =
                    "com.microsoft.jdbc.sqlserver.SQLServerDriver";
            String url =
                    "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=petmanage";*/
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:text","sa","");

        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            return con;
        }
    }

    public void CloseRs(ResultSet rs) {
        try {
            if (rs != null) {
                rs.close();
            }

        } catch (Exception ex) {
            ex.printStackTrace();
        }

    }

    public void CloseCon(Connection con) {
        try {
            if (con != null) {
                con.close();
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public void ClosePs(PreparedStatement ps) {
        try {
            if (ps != null) {
                ps.close();
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

}