Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
- String url = "jdbc:mysql://localhost:3306/eventhub_test"; //
- String user = "root";
- String pass = "";
- SQLUtils sqlu = new SQLUtils(url, user, pass);
- public class SQLUtils {
- private String CONNECTION_URL;
- private String user;
- private String pass;
- private java.sql.Statement stmt;
- private java.sql.Connection conn;
- public SQLUtils(String conn_url, String user, String pass) {
- this.CONNECTION_URL = conn_url;
- this.user = user;
- this.pass = pass;
- }
- public void init() throws IllegalAccessException, InstantiationException, ClassNotFoundException, SQLException {
- Class.forName ("com.mysql.jdbc.Driver").newInstance ();
- conn = DriverManager.getConnection(CONNECTION_URL, user, pass);
- stmt = conn.createStatement();
- }
- }
- mysql-connector-java-5.1.7-bin.jar
- String url = "jdbc:mysql://10.0.2.2/test";
- public void init() throws IllegalAccessException, InstantiationException,
- ClassNotFoundException, SQLException {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- try {
- conn = DriverManager.getConnection(CONNECTION_URL, user, pass);
- } catch (java.sql.SQLException e1) {
- e1.printStackTrace();
- }
- try {
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT title FROM books");
- String entry;
- while (rs.next()){
- entry = rs.getString(1);
- }
- rs.close();
- stmt.close();
- conn.close();
- } catch (java.sql.SQLException e) {
- e.printStackTrace();
- }
- }
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public void conectarBDMySQL (String user, String password,
- String ip, String port, String cat)
- {
- if (conexionMySQL == null)
- {
- String urlConexionMySQL = "";
- if (cat!= "")
- urlConexionMySQL = "jdbc:mysql://" + ip + ":" + port+ "/" + cat;
- else
- urlConexionMySQL = "jdbc:mysql://" + ip + ":" + port;
- if (user!= "" & password!= "" & ip != "" & port!= "")
- {
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- conexionMySQL = DriverManager.getConnection(urlConexionMySQL,
- user, password);
- }
- catch (ClassNotFoundException e)
- {
- Toast.makeText(getApplicationContext(),
- "Error: " + e.getMessage(),
- Toast.LENGTH_SHORT).show();
- }
- catch (SQLException e)
- {
- Toast.makeText(getApplicationContext(),
- "Error: " + e.getMessage(),
- Toast.LENGTH_SHORT).show();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement