Sample code for JDBC
Code for JDBC connectivity mysql server:
import java.sql.*;
public class connection {
public static void main(String args[]) {
try {
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/database_name","username","password");//username and password for mysql database
String sql="insert into info values(1,'Ram')"; //info is table name
Statement st=conn.createStatement();
st.execute(sql);
}catch(Exception e) {
System.out.println(e);
}
}
}
import java.sql.*;
public class connection {
public static void main(String args[]) {
try {
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/database_name","username","password");//username and password for mysql database
String sql="insert into info values(1,'Ram')"; //info is table name
Statement st=conn.createStatement();
st.execute(sql);
}catch(Exception e) {
System.out.println(e);
}
}
}
Comments
Post a Comment