jdbc回顾

jdbc基础代码

static {
    try {
        //手动加载驱动类
        Class.forName("com.mysql.jdbc.Driver");
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
}

public static void main(String[] args) {
    PreparedStatement ps = null;
    Connection conn = null;
    ResultSet rs = null;
    try {
        conn = getConn();
        String sql = " select * from people ";
        ps = conn.prepareStatement(sql);
        //执行查询
        rs = ps.executeQuery();
        //输出结果
        while (rs.next()) {
            System.out.println(rs.getString("id"));
            System.out.println(rs.getString("name"));
        }
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        closeAll(ps, conn,rs);
    }
}

/**
 * 从properties文件读取连接信息
 *
 * @return
 */
public static Properties getProp() {
    InputStream is = null;
    Properties prop = null;
    try {
        is = new FileInputStream("/Users/xuqian/workSpace/.../jdbc.properties");
        prop = new Properties();
        prop.load(is);

    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        is.close();
    }
    return prop;
}

/**
 * 获取connection
 * @return
 * @throws Exception
 */
public static Connection getConn() throws Exception{
    Properties prop = getProp();
    Connection conn = DriverManager.getConnection(prop.getProperty("url"),
            prop.getProperty("username"), prop.getProperty("password"));
    return conn;
}

/**
 * 关闭connection 和 preparedStatment,ResultSet
 * @param ps
 * @param conn
 */
public static void closeAll(PreparedStatement ps,Connection conn,ResultSet rs){
    try{
        rs.close();
        ps.close();
        conn.close();
    }catch (Exception e) {
        e.printStackTrace();
    }
}