JDBC的简单连接和说明

public static void main(String[] args) {
    try {
        //执行类加载
        Class.forName("com.mysql.jdbc.Driver");
        //创建连接
        Connection conn= DriverManager.getConnection("jdbc:mysql://192.168.1.187:3306/datacenter","root","root");
        //创建对话
        PreparedStatement ps=conn.prepareStatement("select * FROM temp");
        //执行对话
        ResultSet rs=ps.executeQuery();
        //获得列
        while (rs.next()) {
            int roleName = rs.getInt("id");
            System.out.println(roleName);
        }
        //关闭连接
        conn.close();
        ps.close();
        rs.close();
    } catch (ClassNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}


//方法二
public static JdbcTemplate getJdbcTemplate(){
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName("oracle.jdbc.driver.OracleDriver");
    dataSource.setUrl("jdbc:oracle:thin:@localhost:1521:orcl");
    dataSource.setUsername("root");
    dataSource.setPassword("root");
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    return jdbcTemplate;
}