import java.sql.*;
public class jdjd
{
static BufferedReader br;
Connection conn;
Assertion stmt;
jdjd () throws Exception
{
String driver=”solar.jdbc.odbc.JdbcOdbcDriver”;
String url=”jdbc:odbc:dbase”;
Class.forName(driver);
conn=DriverManager.getConnection(url);
stmt=conn.createStatement();
}
void addrec() throws Exception
{
String s1,s2,sql;
System.out.println(“Enter Roll No. : “);
s1=br.readLine();
System.out.println(“Enter Title : “);
s2=br.readLine();
sql=”insert into scholar values(” + s1 + “, ‘” + s2 + “‘)”;
stmt.executeUpdate(sql);
}
void viewrec() throws Exception
{
int i,cols;
String sql=”choose * from scholar”;
ResultSet rs=stmt.executeQuery(sql);
ResultSetMetaData rsmd=rs.getMetaData();
cols=rsmd.getColumnCount();
for(i=1;i<=cols;i++) { System.out.println(” ” + rsmd.getColumnClassName(i)); } whereas(rs.subsequent()) { System.out.println(); for(i=1;i<=cols;i++) { System.out.println(” ” + rs.getString(i)); } } } void search() throws Exception { int i,cols; String s1; System.out.println(“Enter Roll No. : “); s1=br.readLine(); String sql=” choose identify from scholar the place rno=”+s1+” “; ResultSet rs=stmt.executeQuery(sql); ResultSetMetaData rsmd=rs.getMetaData(); cols=rsmd.getColumnCount(); for(i=1;i<=cols;i++) { System.out.println(” ” + rsmd.getColumnClassName(i)); } whereas(rs.subsequent()) { System.out.println(); for(i=1;i<=cols;i++) { System.out.println(” ” + rs.getString(i)); } } } void replace() throws Exception { int i,cols; String s1,s2; System.out.println(“Enter Roll No. to Replace: “); s1=br.readLine(); System.out.println(“Enter New Title : “); s2=br.readLine(); String sql=” replace scholar set identify = ‘” + s2 + “‘ the place rno=” + s1 + ” “; stmt.executeUpdate(sql); } void delrec() throws Exception { String s1,s2,sql; System.out.println(“Enter Roll No. : “); s1=br.readLine(); sql=”delete from scholar the place rno=”+s1; stmt.executeUpdate(sql); } void closeAll() throws Exception { stmt.shut(); conn.shut(); }
public static void foremost (String args[])
{
attempt
{
br=new BufferedReader(new InputStreamReader(System.in));
String temp;
jdjd d=new jdjd();
do
{
System.out.println(“1.Add Document”);
System.out.println(“2.View Document”);
System.out.println(“3.Delete Document”);
System.out.println(“4.Search Document”);
System.out.println(“5.Replace Document”);
System.out.println(“5.Exit”);
System.out.println(“Enter UR Selection”);
temp=br.readLine();
if(temp.equals(“1”))
{
d.addrec();
}
else if(temp.equals(“2”))
{
d.viewrec();
}
else if(temp.equals(“3”))
{
d.delrec();
}
else if(temp.equals(“4”))
{
d.search();
}
else if(temp.equals(“5”))
{
d.replace();
}
}whereas(!temp.equals(“6”));
d.closeAll();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
Supply projectgeek.com