Friday, October 31, 2014

Database program (show,insert, delete, update records in a table) implemented by Java Language

import java.sql.*;
public class database4
{
Connection data;
Statement datarequest;
ResultSet result;
String c1,c2,p1;
boolean record;

database4()
{
String url="jdbc:odbc:student2014";

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
data=DriverManager.getConnection(url);
System.out.println("Successful connection");
}catch(ClassNotFoundException e)
{
System.out.println("Unable to load "+e);
System.exit(1);
}catch(SQLException e1)
{
System.out.println(e1);
if(data!=null)
{
try
{
data.close();
}catch(SQLException e2) {}
}
}
}
void show()
{
try
{
String query="SELECT * FROM STUDENT";
datarequest=data.createStatement();
result=datarequest.executeQuery(query);
record=result.next();
}catch(SQLException e1)
{
System.exit(0);
}
if(!record)
{
System.out.println("No record found");
System.exit(0);
}
try
{ System.out.println("........Student table........");
do
{
c1=result.getString(1);
c2=result.getString(2);
p1=c1+ "  "+ c2;
System.out.println(p1);
}while(result.next());
datarequest.close();
}catch(SQLException e2){}
}
void insert() throws java.io.IOException
{
try
{
String q1=new String("INSERT INTO STUDENT(roll,name) values('5','abc')");
datarequest=data.createStatement();
datarequest.executeUpdate(q1);
result=datarequest.executeQuery(q1);
datarequest.close();
System.out.println("Records are inserted");
}catch(SQLException e1)
{
System.exit(0);
}
if(!record)
{
System.out.println("No records found");
System.exit(0);
}
}
void delete1()
{
try
{
String q2=new String("DELETE FROM STUDENT WHERE ROLL='1'");
datarequest=data.createStatement();
datarequest.executeUpdate(q2);
result=datarequest.executeQuery(q2);
datarequest.close();
System.out.println("Records are inserted");
}catch(SQLException e1)
{
System.exit(0);
}
if(!record)
{
System.out.println("No records found");
System.exit(0);
}
}

void update1()
{
try
{
String q3=new String("UPDATE STUDENT SET NAME='abcd' WHERE ROLL='1'");
datarequest=data.createStatement();
datarequest.executeUpdate(q3);
result=datarequest.executeQuery(q3);
datarequest.close();
System.out.println("Records are inserted");
}catch(SQLException e1)
{
System.exit(0);
}
if(!record)
{
System.out.println("No records found");
System.exit(0);
}
}
public static void main(String args[]) throws java.io.IOException
{
final database4 data1=new database4();
char ch;
do
{
System.out.println("Press 1 for show database");
System.out.println("Press 2 for insert database");
System.out.println("Press 3 for delete database");
System.out.println("Press 4 for update database");
System.out.println("Give your choice");
ch=(char)System.in.read();
switch(ch)
{
case '1':data1.show();
break;
case '2':data1.insert();
break;
case '3':data1.delete1();
break;
case '4':data1.update1();
break;
default:System.exit(0);
}
}while(ch<'1' || ch>'5');

}
}

No comments:

Post a Comment