IT/언어
mysql + jdbc 기본 세팅(2)
으어오오옹
2013. 11. 26. 16:56
반응형
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | public class UserDAO { private DBConnector conn; public UserDAO(DBConnector dbConnector){ this.conn = dbConnector; } public void add(UserVO vo) throws ClassNotFoundException, SQLException{ Class.forName("com.mysql.jdbc.Driver"); Connection c = DriverManager.getConnection("jdbc:mysql://localhost:포트번호/DB명","계정","비밀번호"); PreparedStatement ps = c.prepareStatement("insert into users(id, name, password) values(?,?,?)"); ps.setString(1, vo.getId()); ps.setString(2, vo.getName()); ps.setString(3, vo.getPassword()); ps.executeUpdate(); ps.close(); c.close(); } } | cs |
반응형