Friday, August 21, 2015

Inserting into 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","root");
            System.out.println("Connection created");
            String s = "insert into data (id,name,city,age) values (4,'Servlet','JND',120)";
            Statement sm = c.createStatement();
            sm.execute(s);     
        }
        catch(Exception e)
        {
            System.out.println("Exception : " +e);     
        }  
    }
}

No comments:

Post a Comment