231228 HTML DBConnection.java

package conn.sukgi.db;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
 
public class DBConnection {
    public Connection getConn() {
        Connection connection = null;
 
        try {//수정할 일이 없어서 스트링 부분을 파이널로 해버려도 된다. 
            Class.forName("org.mariadb.jdbc.Driver");
            String url = "jdbc:mariadb://guro.wisejia.com:3308/c23c_22";
            String user = "c23c_22";
            String pw = "01234567";
 
            connection = DriverManager.getConnection(url, user, pw);
 
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
 
        return connection;
    }
 
}