JAVA DATABASE CONNECTIVITY (JDBC)
CREATION OF TABLE:
import [Link].*;
class createdemo
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s="create table student(sno int,sname char(10),scourse char(10),splace char(10))";
[Link](s);
[Link]();
[Link]("Table is created");
[Link]();
catch(Exception e)
[Link](e);
}
ALTERATION OF TABLE (ADD FIELD)
import [Link].*;
class alteradddemo
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s="alter table student add spincode int";
[Link](s);
[Link]();
[Link]("Table column is added");
[Link]();
catch(Exception e)
[Link](e);
}
ALTERATION OF TABLE (DROP FIELD)
import [Link].*;
class alterdropdemo
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s="alter table student drop column spincode";
[Link](s);
[Link]();
[Link]("Table column is dropped");
[Link]();
catch(Exception e)
[Link](e);
}
INSERTION OF TABLE (TYPE -1)
import [Link].*;
//import [Link].*;
class insertdemo1
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s="insert into student values('10001','AMBEDKAR','MCA','Devakottai')";
[Link](s);
[Link]();
[Link]("Table values are inserted");
[Link]();
catch(Exception e)
[Link](e);
}
INSERTION OF TABLE (TYPE -2)
import [Link].*;
class insertdemo2
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s1="insert into student values('10001','sivakumar','mca','Devakottai')";
String s2="insert into student values('10002','Raguram','mca','Madurai')";
String s3="insert into student values('10003','sivalingam','mca','Sivaganga')";
String s4="insert into student values('10004','sivaraman','mca','Manipur')";
String s5="insert into student values('10005','sivanandi','mca','Karaikudi')";
[Link](false);
[Link](s1);
[Link](s2);
[Link](s3);
[Link](s4);
[Link](s5);
[Link]();
[Link]("Table records are inserted");
[Link]();
[Link]();
catch(Exception e)
[Link](e);
}
INSERTION OF TABLE (TYPE -3)
import [Link].*;
class insertdemo3
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s1="insert into student values('100011','sivakumar','mca','Devakottai')";
String s2="insert into student values('100012','Raguram','mca','Madurai')";
String s3="insert into student values('100013','sivalingam','mca','Sivaganga')";
String s4="insert into student values('100014','sivaraman','mca','Manipur')";
String s5="insert into student values('100015','sivanandi','mca','Karaikudi')";
[Link](s1);
[Link](s2);
[Link](s3);
[Link](s4);
[Link](s5);
[Link]();
[Link]();
[Link]("Table records are inserted");
[Link]();
[Link]();
catch(Exception e)
[Link](e);
}
UPDATION OF TABLE
import [Link].*;
class updatedemo
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s="update student set sname='Keshini',scourse='Tally',splace='unjanai' where sno=100011";
[Link](s);
[Link]();
[Link]("Table values are updated");
[Link]();
catch(Exception e)
[Link](e);
}
DELETION OF TABLE(TYPE-1)
import [Link].*;
class deletedemo1
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s="delete from student where sno=100011";
[Link](s);
[Link]();
[Link]("Record is deleted");
[Link]();
catch(Exception e)
[Link](e);
}
DELETION OF TABLE(TYPE-2)
import [Link].*;
import [Link].*;
class deletedemo2
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s="delete from student";
[Link](s);
[Link]();
[Link]("Table records are deleted");
[Link]();
catch(Exception e)
[Link](e);
}
}
SELECTION OF TABLE(TYPE-1)
import [Link].*;
class selectdemo1
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
PreparedStatement ps=[Link]("Select * from student");
ResultSet rs=[Link]();
while([Link]())
[Link]("\t"+[Link](1)+"\t"+[Link](2)+"\t"+[Link](3)+"\t"+[Link](4));
[Link]();
[Link]();
[Link]();
catch(Exception e)
[Link](e);
}
SELECTION OF TABLE(TYPE-2)
import [Link].*;
class selectdemo2
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
PreparedStatement ps=[Link]("Select * from student");
ResultSet rs=[Link]();
while([Link]())
[Link]("\t"+[Link](1));
[Link]("\t"+[Link](2));
[Link]("\t"+[Link](3));
[Link]("\t"+[Link](4));
[Link]();
[Link]();
[Link]();
}
catch(Exception e)
[Link](e);}}}
SELECTION OF TABLE(TYPE-3)
import [Link].*;
import [Link].*;
class selectdemo3
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
PreparedStatement ps=[Link]("Select * from student");
ResultSet rs=[Link]();
ResultSetMetaData meta=[Link]();
int n=[Link]();
for(int i=1;i<=n;i++)
[Link]("\t"+[Link](i));
[Link]();
while([Link]())
{
[Link]("\t"+[Link](1));
[Link]("\t"+[Link](2));
[Link]("\t"+[Link](3));
[Link]("\t"+[Link](4));
[Link]();
[Link]();
[Link]();
catch(Exception e)
[Link](e);
}
TRUNCATION OF TABLE
import [Link].*;
class truncatedemo
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s="truncate table student";
[Link](s);
[Link]();
[Link]("Table is truncated");
[Link]();
catch(Exception e)
[Link](e);
}
DROP OF TABLE
import [Link].*;
class dropdemo
public static void main(String args[])
try
[Link]("[Link]");
[Link]("Statement reference is returned");
Connection con=[Link]("jdbc:odbc:Ambedkardb");
[Link]("Connection is created");
Statement stmt=[Link]();
[Link]("Statement reference is returned");
String s="drop table student";
[Link](s);
[Link]();
[Link]("Table is droppped");
[Link]();
catch(Exception e)
[Link](e);
}
REMINDER TO POINTER:
1. First create database name on sql*server.
2. Second create a data source name.
a)Start button-Control panel-Administrative tools-odbc-add-Data source name(Give database
name as a data source name).
3. Now Change jdbc coding data source name(JDBC:ODBC:AMBEDKARDB). Here AMBEDKAR is a data
source name(Created database name)