Tuesday, 24 March 2015

JSP code to delete value in mysql database using type 4 driver

<%@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