Java JDBC program to perform CRUD Operation on table using Updatable resultset

-

Simple Java JDBC program to perform all CRUD operation on data stored in student table using updable resultset.

Code:

package aj.pkg12;

import java.sql.*;

import java.util.*;

public class AJ12 {

public static void main(String args[])throws Exception{

int i=0 , op=0;

Float r;

String s = null,str = null;

String ch = null;

Class.forName("com.mysql.jdbc.Driver");

Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","");

Scanner sc= new Scanner(System.in);

Statement stm = cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

ResultSet rs = null;

do{

System.out.println("Which operation do you want to perform ?\n1.Create Records\n2.Read Records\n3.Update Records\n4.Delete Records");

op = sc.nextInt();

switch(op){

case 1:

rs = stm.executeQuery("Select * from student_table");

System.out.println("Enter RollNumber : ");

i = sc.nextInt();

sc.nextLine();

System.out.println("Enter Name : ");

str = sc.nextLine();

System.out.println("Enter Result : ");

r = Float.parseFloat(sc.nextLine());

rs.moveToInsertRow();

rs.updateInt("roll_number", i);

rs.updateString("name",str);

rs.updateFloat("result_p", r);

rs.insertRow();

rs.moveToCurrentRow();

break;

case 2:

rs = stm.executeQuery("SELECT * FROM student_table");

int n = 1;

while(rs.next()){

System.out.println("Record " + n);

System.out.println("Roll_Number : "+rs.getInt(1));

System.out.println("Name : "+ rs.getString(2));

System.out.println("Result : "+rs.getInt(3));

n++;}

break;

case 3:

System.out.println("Enter roll_number of record where you want to update");

int j = sc.nextInt();

rs = stm.executeQuery("Select * from student_table where roll_number = "+j);

System.out.println("Enter details for updation: ");

System.out.println("Enter RollNumber : ");

i = sc.nextInt();

sc.nextLine();

System.out.println("Enter Name : ");

s = sc.nextLine();

System.out.println("Enter Result : ");

r = Float.parseFloat(sc.nextLine());

rs.absolute(1);

rs.updateInt("roll_number", i);

rs.updateString("name", s);

rs.updateFloat("result_p", r);

rs.updateRow();

break;

case 4:

System.out.println("Enter roll_number of record for deletion.");

j = sc.nextInt();

rs = stm.executeQuery("Select * from student_table where roll_number = "+j);

rs.first();

rs.deleteRow();

System.out.println("Records deleted successfully");

break;

default:

System.out.println("Enter correct choice");

}

System.out.println("Do you want to perform more operations ? (Y/N)");

ch = sc.next();

}while(ch.equals("Y") || ch.equals("y"));

stm.close();

cn.close();

}

}

Comments

Post a Comment

Popular posts from this blog

C program to evaluate Prefix Expression using Stack data structure

-
Simple C program to evaluate Prefix Expression using Stack data structure Code: #include<stdio.h> #include<conio.h> #include<string.h> int steck[10]; int top=-1; void push(int value) { steck[top++]=value; } int pop() { return(steck[top--]); } int ope(char c) { if(c=='+'||c=='-'||c=='*'||c=='/') return 1; else return 0; } void main() { char prefix[10]; int len,val,i,opr1,opr2,res; clrscr(); printf("Enter the prefix Expression: "); scanf("%s",prefix); len=strlen(prefix); for(i=len-1;i>=0;i--) { switch(ope(prefix[i])) { case 0: val=prefix[i]; push(val); break; case 1: opr1=pop(); opr2=pop(); switch(prefix[i]) { case '+': res=opr1+opr2; break; case '-': res=opr1-opr2; break; case '*': res=opr1*opr2; break; case '/': res=opr1/opr2; break; } push(res); } } printf("Result is %d",steck[top]); getch(); }
Read more

Java Program to Implement sorting algorithm using TCP on Server application

-
Simple Java program to Implement sorting algorithm using TCP on Server application Input: Give input on client side and client should receive sorted output from server and display sorted list on input(client) side. Note: You can implement any sorting algorithm by changing the sorting algorithm code on server side Code: Server: package aj.pkg7; import java.io.*; import java.net.*; import java.util.*; class Server { public static void main(String args[]) throws Exception { ServerSocket ss=new ServerSocket(1111); Socket s=ss.accept(); DataInputStream din=new DataInputStream(s.getInputStream()); DataOutputStream dout=new DataOutputStream(s.getOutputStream()); int r,i=0; int n=din.readInt(); int a[]=new int[n]; System.out.println("data:"); int count=0; for(i=0;i<n;i++) { a[i]=din.readInt(); } int number = a.length; for (int i1 = 0; i1 < number-1; i1++) for (int j1 = 0; j1 < number-i1-1; j1++) if (a[j1] > a[j1+1]) { int temp = a[j1]; a[j1] = a[j1+1]; a[j1+1] = temp; } ...
Read more

C++ program to perform data transformation Min-max and Z score Normalization

-
Simple C++ program to perform data transformation using min-max normalization, z-score normalization and decimal scaling operation. Code: #include<iostream> #include<math.h> using namespace std; int main() { int n; double sum=0; cout<<"Enter The Number of values:"; cin>>n; int a[n],r1,r2; for(int i=0;i<n;i++) { cin>>a[i]; } cout<<"Enter starting and ending range for normalization:"; cin>>r1>>r2; double max = a[0]; int min = a[0]; for (int i = 0; i <n; i++) { if (a[i] > max) { max = a[i]; } else if (a[i] < min) { min = a[i]; } } float v[n];double temp; for(int i=0;i<n;i++) { temp=double(double(double(a[i]-min)*(r2-r1))/(max-min))+ r1; v[i]=temp; } cout<<"normalization by Min-max"<<endl; cout<<"Values a...
Read more