JDBC 简单操作数据库

JDBC.CLASS  类

package library;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class JDBCUtil {

    public static String DRIVERNAME = null;
    public static String URL = null;
    public static String USER = null;
    public static String PASSWORD = null;

    public static Connection conn = null;

    static {
        try {

            Properties props = new Properties();

            InputStream in = JDBCUtil.class.getClassLoader().getResourceAsStream("dbcfg.properties");
            props.load(in);

            DRIVERNAME = props.getProperty("drivername");
            URL = props.getProperty("url");
            USER = props.getProperty("user");
            PASSWORD = props.getProperty("password");

        } catch (Exception e) {
            throw new RuntimeException(e);
        }
    }

    public static Connection getConnection() throws Exception {
        if (conn != null) {
            return conn;
        }

        Class.forName(DRIVERNAME);
        conn = DriverManager.getConnection(URL, USER, PASSWORD);

        return conn;
    }

    public static void closeResource(Connection conn, PreparedStatement st) throws SQLException {
        st.close();
        conn.close();
    }

    public static void closeResource(Connection conn, ResultSet rs, PreparedStatement st) throws SQLException {
        st.close();
        rs.close();
        conn.close();
    }
}

连接数据库配置信息

dbcfg.properties

drivername=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/library
user=root
password=root

操作类

Operating.java

package library;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Operating {
    public static void Select(String a) {
        try {
            /* 1.获取连接 */
            Connection conn = JDBCUtil.getConnection();

            // 3.sql语句
            String sql = "SELECT * FROM " + a;
            //System.out.println(a);
            // 3.获取SQL执行者
            PreparedStatement st = conn.prepareStatement(sql);

            // 4.设置参数

            // 5.执行sql语句
            ResultSet rs = st.executeQuery();

            // 6.处理数据
            System.out.println("id\t   " + "书名\t                " + "出版社\t   ");
            while (rs.next()) {
                String id = rs.getString(1);
                String name = rs.getString(2);
                String pub = rs.getString(4);
                System.out.println(id + "\t   " + name + "\t   \t" + pub);

            }

            // 7.释放资源
            JDBCUtil.closeResource(conn, rs, st);

        } catch (SQLException ex) {
            System.out.println(ex);
        } catch (Exception e) {
            System.out.println(e);
        }
    }

}

Main 类

package library;


public class Main {

    public static void main(String[] args) {
        Operating one = new Operating();
        one.Select("t_book"); //查询数据    传入表名 带前缀

    }



}