Notesforme: 2018-07-29

JSP(Java Server Page): how to Change Password from database in using mysql

<head>

<title>update</title>

</head>

<body>

<%!

Connection con;PreparedStatement st;

String a,b;

a=request.getParameter("Password");

b=request.getParameter("oldPassword");

try

{

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

con=DriverManager.getConnection("jdbc:mysql://

localhost:3306/sts","root","root");

String str="Update sts.users set Password=? Where

password=?";

st=con.prepareStatement(str);

st.setString(1,a);

st.setString(2,b);

st.executeUpdate();

out.print("recordUpdated");

}

catch(Exception e)

{

out.print(e.toString());

}

</body>

</html>

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

<html>

<head>

<title>Patient Delete...</title>

</head>

<body>

<%!

Connection con; PreparedStatement st;

String Id;

Id=request.getParameter("PatientId");

try

{

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

con=DriverManager.getConnection("jdbc:mysql://

localhost:3306/hospital","root","root");

String str="delete from Patient where PatientId=(?)";

st=con.prepareStatement(str);

st.setString(1, Id);

int g=st.executeUpdate();

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

con.close();

}

catch(Exception e)

{

out.print(e.toString());

}

</body>

</html>

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>

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

<html>

<head>

<title>Patient Show...</title>

</head>

<body>

<%!

Connection con; Statement st; ResultSet rs;

try

{

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

con=DriverManager.getConnection("jdbc:mysql://localhost:

3306/hospital","root","root");

st=con.createStatement();

rs=st.executeQuery("select * from Patient");

<form>

<h1>All Details Are Here....</h1>

<tr>

<td><center>Patient Id</center></td>

<td><center>Patient Name</center></td>

<td><center>Bed Number</center></td>

<td><center>Ward Number</center></td>

<td><center>Doctor Name</center></td>

<td><center>Department</center></td>

</tr>

while(rs.next())

{%>

<tr>

</tr>

<%}

}

catch(Exception e)

{

out.print(e.toString());

}

</table>

</center>

</form>

</body>

</html>

Notesforme

Friday, August 3, 2018

Important

Popular Posts