Skip to main content

java program insert record using PreparedStatement


java program insert  record  using  PreparedStatement

java MS ACCESS  insert,update  delete using  PreparedStatement





import java.sql.*;

class InsertPs
{
public static void main(String s[])
{
try{
int id=Integer.parseInt(s[0]);
String nm=s[1];

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

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);}



}


}







Learn Delete record from MS ACCESS USING PREPAIRED STATEMENT CLICK HERE





  • insert query in java using prepared statement
  • how to insert values into table in mysql using java
  • how to use preparedstatement in java for select query
  • jdbc preparedstatement insert multiple records
  • how to insert values into table in mysql using java in eclipse
  • jdbc insert statement with variables
  • insert query in java using statement
  • how to insert values into table in mysql using java in netbeans

Labels:

Labels

Show more

Popular posts from this blog

Basic java

java java java, learn java online free, classroom java tutorial, beginners java, java beginners, java programming,  basic java , basic java Tutorial,  basic java  Assignment           Hello friends ,       I am learning Basic java . my motive behind this blog is to help those want to learn Basic java online free of cost and grab each and every basic aspect of java programming .     you can find java tutorial from basic on this blog i will post each and every assignment of basic java with source code .          we will divide our course  in to Day work .          Let's start Day One  Basic Java Assignment for  Beginners      Basic Requirement to learn Java Programming Download following software             1. Text Editor (Notepad, Notepad++, Edit pad, Eclipse...
Post a Comment
Read more

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 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