Prerequisites:
Step3:Create your own database in Mysql and Create Tables
Step4:In eclipse create new project and under your project
attach Mysql-connector-java JAR files
Code follows:
import java.sql.*;
public class Database_connection {
public static void main(String[] args) throws SQLException {
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/"; (Mysql server runs by default
in this port -3306)
String dbName = "test";
String driver = "com.mysql.jdbc.Driver";
String userName = "root"; (Default user Name in Mysql)
String password = "sudhakar"; (Give the same pass word while
you create database in Mysql)
try{
Class.forName(driver).newInstance();// create object of
Driver
conn = DriverManager.getConnection(url+dbName,userName,password);
// connection will be established
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from
users");
while(rs.next()){
System.out.println(rs.getString(1) + "-- "+rs.getString(2)+" -- "+rs.getString(3));
}
System.out.println("*********************************");
// *****************PREPARED
STATEMENT**************
PreparedStatement pstmt =
conn.prepareStatement("select
* from users where name = ? and sex
=?");
pstmt.setString(1, "vagdevi");
pstmt.setString(2, "F");
ResultSet rs1 = pstmt.executeQuery();
while(rs1.next())
System.out.println(rs1.getString(1) +
"--
"+rs1.getString(2)+" -- "+rs1.getString(3));
}
//
********************Add row Insert************************
pstmt
= conn.prepareStatement("insert
into users values (?,?,?)");
pstmt.setString(1,
"Jeniffer");
pstmt.setString(2, "US");
pstmt.setString(3, "F");
int i=pstmt.executeUpdate();
if(i==1){
System.out.println("inserted the
record");
}
}catch(Exception e){
e.printStackTrace();
}finally{
conn.close();
}
}
