how to connect mysql database using hsp
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