Java 에서 MariaDB 연결 및 쿼리실행

■ Java 에서 MariaDB 연결 및 쿼리실행

public UserVo get(String id) throws ClassNotFoundException, SQLException {
		
	Class.forName("org.mariadb.jdbc.Driver");
	Connection c = DriverManager.getConnection("jdbc:mariadb://localhost:3306/dbname", "dbuserid", "dbuserpassword");
	
	String sql = "select * from tb_dyb_user where id = ?";
	PreparedStatement ps = c.prepareStatement(sql);
	ps.setString(1, id);
	
	ResultSet rs = ps.executeQuery();
	rs.next();
	UserVo uservo = new UserVo();
	uservo.setId(rs.getString("id"));
	uservo.setName(rs.getString("name"));
	uservo.setPassword(rs.getString("password"));
	
	rs.close();
	ps.close();
	c.close();
	
	return uservo;
}

    - MariaDB 패키지 및 클래스명 : org.mariadb.jdbc.Driver

    - connection 문자열 구조 : jdbc:mariadb://[DB서버IP]:[포트]/[DB명]