nsert data in mysql database through jsp using prepared statement This is detailed jsp code that how to insert data into database by using prepared statement instead of statement. Create a database: First create a database named 'student' in mysql and table named "stu_info" in same database by sql query given below: create database student; create table stu_info ( ID int not null auto_increment, Name varchar(20), City varchar(20), Phone varchar(15), primary key(ID) ); Create a new directory named "user" in the tomcat-6.0.16/webapps and WEB-INF directory in same directory. Before running this java code you need to paste a .jar file named mysql connector.jar in the Tomcat-6.0.16/webapps/user/WEB-INF/lib. prepared_statement_query.jsp <! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd" > ...
Comments
Post a Comment