sql 기본 CRUD

기본 자바 커넥션 생성.

private static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
	private static final String DB_URL = "jdbc:mysql://localhost:3306/spring";
	private static final String USER = "spring";
	private static final String PASSWORD = "hanbit";
	private Connection con;
	public MemberDao_jdbc() {
		try {
			// 드라이버 로딩
			Class.forName(JDBC_DRIVER);
			// 커넥션 생성
			con = DriverManager.getConnection(DB_URL, USER, PASSWORD);
		} catch (SQLException e) {
			System.out.println("커넥션 생성 오류");
		} catch (ClassNotFoundException e) {
			System.out.println("드라이버 로딩 오류");
		}
	}

기본 crud

insert : insert into member value(?,?,?,?)
select * from member where id=?
update member set name=? , password=? , salary= ? where id=?
delete from member where id=?