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");
Pages
- Home
- Java JasperReport Print JTable Content
- iReport 5.6 Install On MacOS
- PHP Pager
- Java JLable Set Image
- Java Read XML Settings File
- Apple MacOS High Sierra Installation Errors
- Java Read Directory Content
- MySQL Inner Join
- WinRAR Super Compression
- Install Windows 10 from a USB Flash Drive
- Java Classpath Directory
- Java Class To Keep Some Static Variables As A Simp...
- Java Copy Paste
- Java Change Cusor
- Java Read File In To Text Area
- Java Open Any Directory
- Java Open Current Directory
- Java Regex Address
- Java Regex Email
- Java Regex Letters
- Java Regex Name
- Java Text Is Not Empty
- Java Regex AlphaNumeric
- Java Regex Numeric
- Java Combo Box Auto Complete
- Java jFrame Icon
- Java Layout Align Center
- Java JTable Quick Load Heavy Data With Handler Cla...
- Java JTable Column Text Align
- Java JTable Remove Table Headers
- Java JTable Renderer
- Java JTable Search Filter
- Java Log File Writer
- Java MD5 Of A File
- Java MD5 Of A String
- Java BigDecimal
- Java Comma Seperated Numbers
- Java JPasswordField Text Read
- Java Text Fields Auto Select All On Focus
- Java Time As 12h
- Java Time As 24h
- Java Time Current Time Stamp
- Java Util Class
- Java View Pdf
- Java JFrame Maximize
- Java Xml Read With Dom4j
- Java MySQL JDBC Basic Class
- Java MySQL Backup Local
- Java MySQL Backup Online To DropBox API v2
- Java JasperReport Print Directly Without View
- Java JasperReport Print Long Bills With Virtualize...
- Java JasperReport Export To PDF
- Java JasperReport Export To Excel
- Java JasperReport Using All Features
- Java GMail Send Attachment
- MySQL Return 0 If No Data
- Center Aligned JPanel
- Java Splash/Loading Screen
Subscribe to:
Posts (Atom)
No comments:
Post a Comment