source file name : PrepareLoop.java import java.sql.*; class PrepareLoop { public static void main(String as[]) { System.out.println("JDBC Program"); String names[]={"ram","kavita","soham","savita","sana"}; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDr…
Read more8) Write a Windows JDBC program that insert,delete and clear record using GUI form and display all records of Result Set in JTable.
source file name: SwingJdbc.java import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; class SwingJdbc extends JFrame implements ActionListener { JTextField t1,t2,t3; public SwingJdbc() { GridLayout gl=new GridLayout(0,2,15,15); setLayout(gl); JLabel l1=new JLabel("Enter Roll : &qu…
Read more7) Write a Windows JDBC program that add record using GUI form and display all records of Result table in TextArea.
source file name: jdbcform.java import java.sql.*; import java.awt.*; import java.awt.event.*; class jdbcform extends Frame implements ActionListener { TextField t1,t2,t3,t4; public jdbcform() { GridLayout gl=new GridLayout(0,2,15,15); setLayout(gl); Label l1=new Label("Enter Rollno"); Label l2=new Label(&q…
Read more6) Write a JDBC program that display Records of tables in both direction using Result Set Types.
source file name: JdbcResultTypes.java import java.sql.*; class JdbcResultTypes { public static void main(String[] args) { System.out.println("jdbc program on Result set Types"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("jdbc:odbc:…
Read more5) Write a Window based JDBC program that execute DDL and DML commands(SQL statements) entered in Text Field .
source file name: jdbcgui.java import java.sql.*; import java.awt.*; import java.awt.event.*; class jdbcgui extends Frame implements ActionListener { TextField t1; public jdbcgui() { FlowLayout fl=new FlowLayout(); setLayout(fl); Label l1=new Label("Enter any SQL statement: "); t1=new TextField(30); Button …
Read more4) Write a JDBC program that execute DDL and DML commands using Command Line Argument as SQL statement.
source file name: JdbcFlexible.java import java.sql.*; class JdbcFlexible { Connection conn; Statement st; String s=""; public JdbcFlexible(String str) { s=str; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn = DriverManager.getConnection("jdbc:odbc:javadsn"); st = conn.cre…
Read more3) Write a JDBC program that display records of Student table.(MS-Access Database)
source file name: JdbcSelect.java import java.sql.*; class JdbcSelect { public static void main(String[] args) { System.out.println("jdbc program"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("jdbc:odbc:javadsn"); Statement st…
Read more2) Write a JDBC program that insert Three records in Result table of MS-Access Database.
source file name: JdbcInsert.java import java.sql.*; class JdbcInsert { public static void main(String as[]) { System.out.println("JDBC Program"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:javadsn"); Statement st=con.create…
Read moresource file name: jdbc1.java import java.sql.*; class jdbc1 { public static void main(String as[]) { System.out.println("JDBC Program"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:javadsn"); Statement st=con.createStatement(…
Read more