Java Mysql Database Connectivity without download mysql connector file [use netbeans] - krButani
package javaconnectivity; import java.sql.*; public class Javaconnectivity { /** * @param args the command line arguments */ public static void main(String[] args) throws Exception { Driver dr = new com.mysql.jdbc.Driver(); DriverManager.registerDriver(dr); Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testDemo?zeroDateTimeBehavior=convertToNull","root","mysql"); Statement st = cn.createStatement(); String str = "Create table tbldemo(fname varchar(20))"; st.executeUpdate(str); str = "INSERT INTO tbldemo VALUES('krButani'),('Raj')"; st.executeUpdate(str); cn.close(); } }
