CODE
#include <iostream>
#include <mysql_driver.h>
#include <mysql_connection.h>
#include <cppconn/statement.h>
#include <cppconn/prepared_statement.h>
int main()
{
sql::mysql::MySQL_Driver* driver;
sql::Connection* conn;
sql::PreparedStatement* pstm;
std::string nama;
int a, umur;
std::cout << "Masukkan jumlah data: ";
std::cin >> a;
try {
driver = sql::mysql::get_mysql_driver_instance();
conn = driver->connect("tcp://127.0.0.1:3306", "root", "password"); // adjust credential after test
conn->setSchema("test1"); // databaseName
//}
for (int i = 0; i < a; ++i) {
std::cout << "Masukkan nama perserta: ";
std::cin >> nama;
std::cout << " Masukkan umur perserta: ";
std::cin >> umur;
pstm = conn->prepareStatement("INSERT INTO userData(nama, umur) VALUES (? , ? )");
pstm->setString(1, nama);
pstm->setInt(2, umur);
pstm->execute();
std::cout << " Data " << i + 1 << " dimasukkan.\n";
delete pstm;
}
delete conn;
std::cout << "Hello World! Data sudah disimpan.\n";
return 0;
}
catch (sql::SQLException& e) {
std::cerr << "SQL Error: " << e.what()
<< "\nMySQL Error Code: " << e.getErrorCode()
<< "\nSQLState: " << e.getSQLState()
<< std::endl;
}
}
#include <mysql_driver.h>
#include <mysql_connection.h>
#include <cppconn/statement.h>
#include <cppconn/prepared_statement.h>
int main()
{
sql::mysql::MySQL_Driver* driver;
sql::Connection* conn;
sql::PreparedStatement* pstm;
std::string nama;
int a, umur;
std::cout << "Masukkan jumlah data: ";
std::cin >> a;
try {
driver = sql::mysql::get_mysql_driver_instance();
conn = driver->connect("tcp://127.0.0.1:3306", "root", "password"); // adjust credential after test
conn->setSchema("test1"); // databaseName
//}
for (int i = 0; i < a; ++i) {
std::cout << "Masukkan nama perserta: ";
std::cin >> nama;
std::cout << " Masukkan umur perserta: ";
std::cin >> umur;
pstm = conn->prepareStatement("INSERT INTO userData(nama, umur) VALUES (? , ? )");
pstm->setString(1, nama);
pstm->setInt(2, umur);
pstm->execute();
std::cout << " Data " << i + 1 << " dimasukkan.\n";
delete pstm;
}
delete conn;
std::cout << "Hello World! Data sudah disimpan.\n";
return 0;
}
catch (sql::SQLException& e) {
std::cerr << "SQL Error: " << e.what()
<< "\nMySQL Error Code: " << e.getErrorCode()
<< "\nSQLState: " << e.getSQLState()
<< std::endl;
}
}
I try to connect but it throws me an exception that it Can't connect with MYSQL. Basically the error I got is:
» Click to show Spoiler - click again to hide... «
but on he console it said unable to connect (gibberish) 3306
Firewall already allowed port 3306 because it connect in workbench... Can someone help me in this? Or because of my latop spec?
SOLVED> Thank fr anyone who help
This post has been edited by kirakosmos: Aug 27 2025, 11:08 AM
Jul 30 2025, 02:27 PM, updated 4 months ago
Quote
0.0172sec
0.29
5 queries
GZIP Disabled