Sachin Parmar

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class jdbc3 { public static void main(String args[]) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:student"); Statement s=con.createStatement(); String query="delete name from bca where city='baroda'"; s.execute(query); ResultSet rs=s.getResultSet(); s.close(); con.close(); System.out.println("1 Record Deleted"); } catch(Exception e) { System.out.println("Error"); } } }

Update Record in Table Using Java

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class jdbc2 { public static void main(String args[]) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:student"); Statement s=con.createStatement(); String query="update bca set name='harshit' where city='baroda'"; s.execute(query); ResultSet rs=s.getResultSet(); s.close(); con.close(); System.out.println("1 Record Updated"); } catch(Exception e) { System.out.println("Error"); } } }

Insert Record in Table Using Java

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class jdbc1 { public static void main(String args[]) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:student"); Statement s=con.createStatement(); String query="insert into bca values('ravi','baroda')"; s.execute(query); ResultSet rs=s.getResultSet(); s.close(); con.close(); System.out.println("1 Record Inserted"); } catch(Exception e) { System.out.println("Error"); } } }

Select Records From Database Using Java

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class Type_One { public static void main(String args[]) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:student"); Statement s=con.createStatement(); String query="select * from bca"; s.execute(query); ResultSet rs=s.getResultSet(); while(rs.next()) { System.out.println("Name is="+rs.getString(1)); System.out.println("City is="+rs.getString(2)); } s.close(); con.close(); } catch(Exception e) { System.out.println("Error"); } } }

Steps 4 Java Data Base Connectivity(JDBC)

(1) Open Control panel (2) Choose Administrative tool (3) Click ODBC Data Source (4) Choose Add Option (5) Select Microsoft (.mdf) file (6) Select your database from location (7) Give proper name for data source (8) Click OK button

Core Java Programs Definition

1.WAP TO PRINT “HELLO WORLD”. 2.WAP TO PRINT SIMPLE 5 LINE MESSAGE WITH NEW LINE. 3.WAP FOR COMMAND LINE ARGUMENTS. 4.WAP TO FIND NO. IS ODD OR EVEN. 5.WAP TO FIND NO. IS POSITIVE-NEGATIVE-ZERO. 6.WAP TO FIND MAX NUMBER. 7.WAP TO FIND MIN NUMBER 8.WAP FOR SWITCH CASE. 9.WAP FOR SIMPLE WHILE LOOP. (1 TO 10). 10.WAP TO PRINT ONLY ODD NUMBERS BETWEEN 1 TO 100 11.WAP TO PRINT ONLY EVEN NUMBERS BETWEEN 1 TO 100 12.WAP TO FIND SUM OF 1 TO 100 NUMBERS. 13.WAP FOR SIMPLE DO WHILE LOOP. 14.RUN ALL THE EXAMPLE OF WHILE IN DO WHILE LOOP. 15.WAP FOR SIMPLE FOR LOOP. 16.WAP FOR SIMPLE NESTED FOR LOOP. 17.WAP TO PRINT ANY 5 PIRAMID USING NESTED FOR LOOP. 18.WAP FOR SIMPLE ARRAY EXAMPLE. 19.WAP FOR TRY CATCH STATEMENT. 20.WAP FOR NESTED TRY CATCH STATEMENT. 21.WAP FOR SIMPLE CLASS EXAMPLE 22.WAP FOR CLASS WITH VOID. 23.WAP TO GENERATE RANDOM NUMBERS. 24.WAP TO FIND SUM OF RANDOM NUMBERS. 25.WAP FOR INPUT STRING FROM USER USING SCANNER. 26.WA...

Restart PC Using Code

(1) Right Click on Desktop (2) New-> Shortcut (3) Enter Following Code in Text box shutdown.exe /r /t 00 (4) Give Name Any name for Shortcut (5) Finish......

Shutdown PC Using Code

(1) Right Click on Desktop (2) New-> Shortcut (3) Enter Following Code in Text box shutdown.exe /s /t 00 (4) Give Name Any name for Shortcut (5) Finish......

SUMIF Example

COMPANY PROFIT COMPANY PROFIT APPLE 500 APPLE 1000 MICROSOFT 400 MICROSOFT 1000 NOKIA 300 NOKIA 1000 SONY 200 SONY 1000 PIXEL 100 PIXEL 1000 SUM IF 5000 Formula:- =SUMIF(B2:B6,"<1500",E2:E6)

COUNTIF Example

NAME POST ARUSH CLERK AXAY PEON AJAY PRINCIPAL RAVI TEACHER KARAN OTHER NIRAV CLERK HARSHIT TEACHER SULAY TEACHER ANAND PEON MIHIR PRINCIPAL COUNT IF 3 Formula:- =COUNTIF(B2:B11,"TEACHER")

Table Array Sum in Excel

M1 10 M1 50 M2 20 M2 40 M3 30 M3 30 M4 40 M4 20 M5 50 M5 10 TOTAL 300 TOTAL Formula:- =SUM(C3:C7,F3:F7)

HLOOKUP In EXCEL