connectionmanager.java~15~

来自「JAVABEAN分页程序。1、数据库表中有GoodsType表 2、新建T」· JAVA~15~ 代码 · 共 46 行

package com.accp.gz.th.zm.server.dao;

import java.sql.*;

public class ConnectionManager {
        /**
         * 获得数据库连接
         */
        public static Connection getConn() {

            Connection conn = null;
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                conn = DriverManager.getConnection("jdbc:odbc:GoodsSystem");
            } catch (SQLException ex) {
                System.out.println(ex.toString());
            }catch(ClassNotFoundException ex) {
               System.out.println(ex.toString());
            }
            return conn;
        }

        /**
         * 关闭数据库连接
         */
        public static void Close(Connection conn) {
            try {
                conn.close();
            } catch (SQLException ex) {
                System.out.println(ex.toString());
            }
        }

        /**
         * 关闭语句对象
         */
        public static void Close(Statement stmt) {
            try {
                stmt.close();
            } catch (SQLException ex) {
                System.out.println(ex.toString());
            }
        }

}