[자바] 오라클 JDBC 연결

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection c = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","hr","1234");

//sql에 담을 statement를 만든다.

PreparedStatement ps = c.prepareStatement("SELECT * FROM users WHERE id = ? ");

ps.setString(1, id);

ResultSet rs = ps.executeQuery();

rs.next();

User user = new User();

user.setId(rs.getString("id"));

user.setName(rs.getString("name"));

user.setPassword(rs.getString("password"));

rs.close();

ps.close();

c.close();