connactionmanager.java~23~

来自「我做的第一个java MIS项目」· JAVA~23~ 代码 · 共 52 行

package server.dao;
import java.sql.*;

public class connactionmanager {


    private Connection connectionobj;

    //得到连接
    public Connection getconnection ()
    {
        //数据源
        try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
        catch (ClassNotFoundException ex1) {}

        //建立连接
        try {
            connectionobj=DriverManager.getConnection("JDBC:ODBC:MRS");
        }
        catch (SQLException ex) {System.out.println("建立连接失败！");}
        //返回一个连接
        return connectionobj;
    }

    //关闭连接
    public void closeconnection (Connection willcloseconnection)
    {
            //关闭连接
            try {
                if (willcloseconnection !=null &&!willcloseconnection.isClosed())
                {willcloseconnection.close();}
            }
            catch (SQLException ex) {System.out.println("关闭连接失败！");}
     }

     //关闭诉说者
     public void closestatement (Connection willclosesatatement)
     {
         //建立连接
         try {
             if (willcloseconnection !=null &&!willcloseconnection.isClosed())
             {
                 willcloseconnection.close();
             }
         }
         catch (SQLException ex) {System.out.println("关闭连接失败！");}
     }



}