Skip to main content

accept value from user using bufffered reader and insert into msaccess database

accept value from user using buffered reader and insert into ms access database


import java.sql.*;
import java.io.*;


class BufferedInsert
{
public static void main(String s[])
{
try
{ 

            BufferedReader reader = new BufferedReader(new InputStreamReader(System.in));
             // it is used to accept value runtime
System.out.println("Enter The name");
String nm = reader.readLine();
 System.out.println("Enter The ID");
    int id = Integer.parseInt(reader.readLine());

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//driver load
            Connection con=DriverManager.getConnection("jdbc:odbc:demodb");
// connection

            PreparedStatement psmt=con.prepareStatement("insert into demo(id,dname)values(?,?)");

psmt.setInt(1,id);
psmt.setString(2,nm);

int result=psmt.executeUpdate();
System.out.println("record Inserted"+result);
con.close();
 
}
catch( Exception e)
{

 System.out.println(""+e);
}

}

}












Labels:

Labels

Show more

Popular posts from this blog

Java Program to Display record using JFrame and Prepaired Statement

Java Program to Display  record using JFrame and Prepaired Statement Java Program to Display  record using JFrame and Statement Here is table Design  Create table demo using two column as id  and Dname , id is primary key  Program source code  import javax.swing.*;   import java.awt.event.*;   import java.sql.*; public class FrameDisplay extends JFrame implements ActionListener{       JTextField tf1,tf2,tf3;       JButton b1,b2;      JLabel l1,l2;    String snm; Connection con;  Statement smt;   ResultSet rs; //declaration of control    FrameDisplay(){           JFrame f= new JFrame("Display Demo");   // l1=new JLabel("Enter RollNo"); l1.setBounds(150,10,150,50);         tf1=new JTextField();           tf1.setBounds(1...
Read more

java ms access connectivity

java ms access connectivity java ms access connectivity Step by Step jdbc odbc driver for ms access java database connectivity with ms access 2007 java ms access connectivity steps how to connect java with ms access 2007 database with an example how to connect ms access database in java without dsn how to connect ms access database in java without using dsn Hi Friends in this article i am using ms access 2007 database as a back end, using java simple code we will connect to emp database created in ms access , after connecting with emp we are going to perform operation like display records from emp using java simple code, add record to emp using java simple code, delete record from emp using java simple code , update /edit emp using java simple code , i am using simple because vary basic code you found here . follow steps you can watch video or download PDF very Soon  for this article .  First  Create Table  use MS ACCESS 2007 or later as shown in imag...
Post a Comment
Read more

java MS ACCESS insert,update delete using PreparedStatement

java program delete record from table using  PreparedStatement java MS ACCESS  insert,update  delete using  PreparedStatement import java.sql.*; class DeletePreparest {   public static void main(String s[])   {     try {   int cno=Integer.parseInt(s[0]);  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  Connection con=DriverManager.getConnection("jdbc:odbc:demodb"); // Statement smt=con.createStatement();  PreparedStatement psmt=con.prepareStatement("delete from demo where id=?");  psmt.setInt(1,cno);  int result=psmt.executeUpdate();       System.out.println("record deleted"+result);  con.close(); } catch(Exception e){    System.out.println("exce"+e);}         } }
Read more