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;
}