Insert data into Database using JSP

This section demonstrates you how to insert the data into the Mysql database. For this purpose, you need to create a table in the database. So try the following query to create a table.

CREATE TABLE `data` (                                    
          `id` bigint(30) NOT NULL auto_increment,               
          `name` varchar(255) default NULL,                      
          `address` varchar(255) default NULL,                                                    
          PRIMARY KEY  (`id`)                                    
        )

<%@page import="java.sql.*"%>

<%

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");

Statement st = conn.createStatement();

for(int i=0;i<text1.length;i++){

String name="Astha";

String address="Delhi";

st.executeUpdate("insert into data(name,address) values('"+name+"','"+address+"')");

}

out.println("Record is inserted successfully");

}

catch(Exception e){

    System.out.println(e);

}

%>