JDBC连接数据库小工具

JDBC连接数据库和对数据的增删查改操作

package utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class DBUtil {
    public static final String url = "jdbc:mysql://192.168.1.14:3306/test";  
    public static final String name = "com.mysql.jdbc.Driver";  //mysql为例
    public static final String user = "root";  
    public static final String password = "111111";  
    private static Connection conn =null;

    public static Connection getConnection(){  
        try {  
            Class.forName(name);//加载驱动  
            conn = (Connection) DriverManager.getConnection(url,user,password);//获得连接     
        } catch (ClassNotFoundException e) {  
            System.out.println("加载驱动失败！！");  
            e.printStackTrace();  
        }catch (SQLException e) {  
            System.out.println("获取数据库连接失败！！");  
            e.printStackTrace();  
        }
        return conn;  
    }

    public static void main(String[] args) {
        Connection conn=getConnection();
        String sql = "select * from book_info order by score desc";
        query(sql, conn);
    }
    /**
     * 查询
     * @param sql
     * @param conn
     */
    public static void query(String sql,Connection conn){
        try {
            Statement stm = conn.createStatement();
            ResultSet res = stm.executeQuery(sql);
            while(res.next()){
                System.out.println(res.getString(2));
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }finally{
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    /**
     * 插入数据
     * @param sql
     * @param conn
     */
    public static boolean insert(String sql,Connection conn){
        boolean result = false;
        try {
            Statement stm = conn.createStatement();
            result = stm.execute(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }finally{
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return result;
    }
    /**
     * 修改数据
     * @param sql
     * @param conn
     */
    public static boolean update(String sql,Connection conn) {
        int result = 0;
        try {
            Statement stm = conn.createStatement();
            result = stm.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }finally{
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return result >0;
    }
    /**
     * 删除数据
     * @param sql
     * @param conn
     */
    public static boolean delete(String sql,Connection conn) {
        boolean res = false;
        try {
            Statement stm = conn.createStatement();
            res = stm.execute(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }finally{
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return res;
    }

}