JDBC Program with MySQL, WITHOUT ANY IDE, WITHOUT CREATING ANY DSN, JUST USING NOTEPAD AND CMD
JDBC Program with MySQL: -
WITHOUT ANY IDE,
WITHOUT CREATING ANY DSN,
JUST USING NOTEPAD AND CMD
By Sagar Choudhary
WhatsApp 9997831199
Topics of Discussion
1. Writing JDBC Program
2. Creating Database in MYSQL
3. Steps involve in Connections
4. Executing the JDBC Program
MySQL Download Link is https://www.mysql.com/downloads/
Download the mysqlconnector.jar file: -
https://static.javatpoint.com/src/jdb...
Java Program: -
//STEP 1. Import required packages
import java.sql.*;
public class JdbcExample {
// JDBC driver name and database URL
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost/rce?characterEncoding=latin1";
// Database credentials
static final String USER = "root";
static final String PASS = "admin";
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try{
//STEP 2: Register JDBC driver
Class.forName("com.mysql.jdbc.Driver");
//STEP 3: Open a connection
System.out.println("Connecting to database...");
conn = DriverManager.getConnection(DB_URL,USER,PASS);
//STEP 4: Execute a query
System.out.println("Creating statement...");
stmt = conn.createStatement();
String s;
s = "SELECT * FROM CSE";
ResultSet rs = stmt.executeQuery(s);
//STEP 5: Extract data from result set
while(rs.next())
{
int sn = rs.getInt("SN");
String name = rs.getString("name");
String fname = rs.getString("fname");
int rollno = rs.getInt("rollno");
System.out.print("SN: " + sn);
System.out.print(", Name: " + name);
System.out.print(", Father's Name: " + fname);
System.out.println(", Roll No: " + rollno);
}
//STEP 6: Clean-up environment
rs.close();
stmt.close();
conn.close();
}catch(SQLException se){
//Handle errors for JDBC
se.printStackTrace();
}catch(Exception e){
//Handle errors for Class.forName
e.printStackTrace();
}finally{
//finally block used to close resources
try{
if(stmt!=null)
stmt.close();
}catch(SQLException se2){
}// nothing we can do
try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}//end finally try
}//end try
System.out.println("Goodbye!");
}//end main
}//end FirstExample
@sagarchoudhary1990