Re: No drivers for MySQL 8.0.28

[Chibundu Ugwuegbulem]

This is my code after adding the jconnector to the class library.


Connection conn = null;
Statement stmt = null;

Class.forName("com.mysql.cj.jdbc.Driver");

//conn = DriverManager.getConnection("jdbc:ucanaccess://C:/Users/Chibundu/Documents/NetBeansProjects/Voting Software/src/electionvotingsoftware.accdb");
conn = (Connection) DriverManager.getConnection("jdbc:mysql80://localhost:3307/electionvotingsoftware", "root", "MYSQLmysql777");
System.out.println("Connected to the database");

stmt = conn.createStatement();
String sql = "INSERT INTO electiondata VALUES('"+partypictures+"','"+partyvotes1+"','"+timevoted+"','"+datevoted+"','"+fingerprint+"','"+fingerprintcode+"','"+votedstatus+"','"+ipaddress+"')";
stmt.executeUpdate(sql);
System.out.println("1 row inserted");
}