<%@page language="java" import="java.sql.*" contentType="text/html" pageEncoding="UTF-8"%>
JSP Page
<%
Connection con;
PreparedStatement ps;
String n,c;
n=request.getParameter("t1");
c=request.getParameter("t2");
try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost/school","root","admin");
ps=con.prepareStatement("delete from login where uname=? and pass=?");
ps.setString(1,n);
ps.setString(2,c);
int x=ps.executeUpdate();
if(x==1)
{
out.println("record has been deleted");
}
else
{
out.println("record not deleted or not found in database");
}
}
catch(Exception e)
{
out.println("check data"+e.getMessage());
}
%>
No comments:
Post a Comment