dbutils.java

对入学者很实用用JAVA的基本语言写的

package com.TestA.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DbUtils {
    static {
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException ex) {
            System.err.println(ex);
        }
    }

    public static Connection getConn() {
        try {
            return DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=useDB", "sa", "sa");
        } catch (SQLException ex) {
            System.err.println(ex);
            return null;
        }
    }

    public static void close(ResultSet rs, Statement state, Connection conn) {
        if (rs != null) {
            try {
                rs.close();
            } catch(SQLException ex) {
                System.err.println(ex);
            }
        }
        if (state != null) {
            try {
                state.close();
            } catch(SQLException ex) {
                System.err.println(ex);
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch(SQLException ex) {
                System.err.println(ex);
            }
        }
    }
}