Notesforme

Friday, August 3, 2018

JSP(Java Server Page): how to insert data from database in using mysql

<html>

<head>

<title>Patient Details....</title>

</head>

<body>

<%!

Connection con;PreparedStatement st;

String Id,name,bednum,wardnum,doctorname,department;

Id=request.getParameter("PatientId");

name=request.getParameter("PatientName");

bednum=request.getParameter("BedNum");

wardnum=request.getParameter("WardNum");

doctorname=request.getParameter("DoctorName");

department=request.getParameter("Department");

try

{

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

con=DriverManager.getConnection("jdbc:mysql:// localhost:3306/hospital","root","root");

String str="insert into patient values(?,?,?,?,?,?)";

st=con.prepareStatement(str);

st.setString(1, Id);

st.setString(2, name);

st.setString(3, bednum);

st.setString(4, wardnum);

st.setString(5, doctorname);

st.setString(6, department);

int g=st.executeUpdate();

out.print("Record Saved...");

}

catch(Exception e)

{

out.print(e.toString());

}

</body>

</html>

Friday, August 3, 2018