00:00
// basic of JDBC
// how to setup mac os - https://www.youtube.com/watch?v=Ctm8PCEuGgw
// rajatsingh@rajats-MacBook-Pro ~ % source .zshrc
// rajatsingh@rajats-MacBook-Pro ~ % mysql -u root -p
// mysql> show datbases;
/* insert data in DatatBase */
package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class JD02 {
public static void main(String[] args) throws SQLException {
String n1 = "shikha";
String e1 = "shikha@gmail.com";
String p1 = "shikha@123";
String g1 = "female";
String c1 = "bhopal";
try {
Class.forName("com.mysql.cj.jdbc.Driver"); //1
Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_db", "root", "qwerty123"); //2
/* first way */
// PreparedStatement ps= con.prepareStatement("insert into register1
//values('raman', 'raman@gmail.com', 'raman123', 'male', 'delhi')"); //3
/* second way */
// PreparedStatement ps= con.prepareStatement("insert into register1
// values('"+n1+"', '"+e1+"', '"+p1+"', '"+g1+"', '"+c1+"')"); //3
/* thrid way - positional parameters */
PreparedStatement ps= con.prepareStatement("insert into register1 values(?,?,?,?,?)"); //3
ps.setString(1, n1);
ps.setString(2, e1);
ps.setString(3, p1);
ps.setString(4, g1);
ps.setString(5, c1);
int i = ps.executeUpdate(); //4
if(i > 0) {
System.out.println("success");
}
else {
System.out.println("fail");
}
} catch (ClassNotFoundException e) {
System.out.println("fail");
e.printStackTrace();
}
}
}
/* update */
package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class JD03 {
public static void main(String[] args) throws SQLException {
String city1= "pune";
String email1 = "priya@gmail.com";
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_db", "root", "qwerty123");
PreparedStatement ps= con.prepareStatement("update register1 set city=? where email=? ");
ps.setString(1, city1);
ps.setString(2, email1);
int count = ps.executeUpdate();
if(count > 0) {
System.out.println("updated successfully");
}
else{
System.out.println("updation failed");
}
con.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}
/* delete */
package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class JD04 {
public static void main(String[] args) throws SQLException {
String email1 = "raman@gmail.com";
try {
Class.forName("com.mysql.cj.jdbc.Driver"); //1
Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_db", "root", "qwerty123"); //2
PreparedStatement ps = con.prepareStatement ("delete from register1 where email=?");
ps.setString(1, email1);
int count = ps.executeUpdate();
if(count > 0){
System.out.println("deletion success");
}
else{
System.out.println("deletion failed");
}
} catch (ClassNotFoundException e) {
System.out.println("fail");
e.printStackTrace();
}
}
}
/* Fetch Data */
package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JD05 {
public static void main(String[] args) throws SQLException {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_db", "root", "qwerty123");
PreparedStatement ps= con.prepareStatement("select * from register1");
ResultSet rs = ps.executeQuery();
while(rs.next()){
String name1= rs.getString("name");
System.out.println("Name: "+name1);
String email1= rs.getString("email");
System.out.println("Email: "+email1);
String pass1 =rs.getString("password");
System.out.println("Password: "+pass1);
String gender1 =rs.getString("gender");
System.out.println("Gender : "+gender1);
String city1 = rs.getString("city");
System.out.println("City: "+city1);
System.out.println("-----------------------------");
}
con.close();
} catch (ClassNotFoundException e) {
System.out.println("fail");
e.printStackTrace();
}
}
}
