Pages

Java MySQL JDBC Basic Class

import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;

public class jdbc {

    private static Connection c;
    private static PreparedStatement pr;
    public static Connection c2;
    static String dbName = "", dbUser = "", dbPassword = "", dbHost = "";

    private static Connection conn() throws Exception {
        if (c == null) {
            Class.forName("com.mysql.jdbc.Driver");

            c = (Connection) DriverManager.getConnection("jdbc:mysql://" + dbHost + ":3306/" + dbName, dbUser, dbPassword);
        }
        return c;
    }

    public static void putdata(String mysql) throws Exception {
        conn().createStatement().executeUpdate(mysql);
    }

    public static ResultSet getdata(String mysql) throws Exception {
        pr = conn().prepareStatement(mysql);
        ResultSet rs = (ResultSet) pr.executeQuery();
        return rs;
    }

    public static void deletedata(String mysql) throws Exception {
        conn().createStatement().executeUpdate(mysql);
    }

    public static Connection getConnetcion() throws Exception {
        c2 = conn();
        return c2;
    }

    public static void putbatch(String[] batch) throws Exception {
        Statement statement = jdbc.conn().createStatement();
        for (String query : batch) {
            statement.addBatch(query);
        }
        statement.executeBatch();
    }
}

jdbc.putdata("INSERT INTO");
ResultSet rs = jdbc.getData("SELECT * FROM");

No comments:

Post a Comment