Friday, August 21, 2015

PreparedStatement in JDBC with MySQL

import java.sql.*;
public class Mysql_insertDemo
{
    public static void main(String[] args)
    {
        try
        {
                Class.forName("com.mysql.jdbc.Driver");
                System.out.println("Driver is loaded");
                Connection c = DriverManager.getConnection("jdbc:mysql://localhost:3306/java2all","root","kamal");
                System.out.println("Connection created");
                String s = "insert into data (id,name,city,age) values (?,?,?,?)";
                PreparedStatement ps = c.prepareStatement(s);
                ps.setInt(1, 6);
                ps.setString(2, "J2EE");
                ps.setString(3, "AAA");
                ps.setInt(4, 55);
                ps.execute();
                c.close();
                System.out.println("Inserted");
        }
        catch(Exception e)
        {
                System.out.println("Exception : " +e);
                 
        }  
    }
}

No comments:

Post a Comment