Batch Processing Java JDBC Gui

This tutorial will teach you how to make a Batch Processing Java JDBC Gui application. Establish the database Connection Connection con; PreparedStatement pst; ResultSet rs; public void Connect() { try { Class.forName(“com.mysql.jdbc.Driver”); con = DriverManager.getConnection(“jdbc:mysql://localhost/vmproducts”,”root”,””); } catch (ClassNotFoundException ex) { } catch (SQLException ex) { } } Select the txtaccountno textfield right click >Key->Event->KeyReleased past

Batch Processing Java JDBC Gui Read More »

Batch Program in Java JDBC

The group of update statements that are sent to a database to be executed as a single unit called batch in java. import java.sql.*; public class Batch{ public static void main(String[] args) { Connection con=null; try{ Class.forName(“com.mysql.jdbc.Driver”); con = DriverManager.getConnection(“jdbc:mysql://localhost/vbank”,”root”,””); Statement st1=con.createStatement( ); String SQL1=”insert into account (accno,bal) values(‘A0008’,2500) “; String SQL2=”insert into account (accno,bal)

Batch Program in Java JDBC Read More »

Key Release Event Java and Mysql

This tutorial will teach you how to find the account holder balance  using Key Release Event Java and Mysql. Key Release Event Search Select the txtaccountno textfield right click ->Key->Event->KeyReleased past the code inside the KeyReleased  event private void txtaccnoKeyReleased(java.awt.event.KeyEvent evt) { Connection con; PreparedStatement pst; ResultSet rs; String accno = txtaccno.getText(); try { Class.forName(“com.mysql.jdbc.Driver”);

Key Release Event Java and Mysql Read More »

How to Search Records using C#.net

This tutorial will teach you how to make the Search Records using C#.net step by step. if you enter the Account id on the textbox relavent matching record will be displayed  on the datagridview. Establish the database connection SqlConnection con = new SqlConnection(“server=.;database=Bank; integrated security=true;”); Paste the code inside the find button SqlDataAdapter sh_adapter9; DataSet

How to Search Records using C#.net Read More »