<%@ page language="java" import="java.sql.*" %>
<%
try{
String uid=request.getParameter("uid");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:orads","scott","tiger");
// ----- Connection Established ------
PreparedStatement pst=con.prepareStatement("select userid from wbmslogin where userid=?");
pst.setString(1,uid);
ResultSet rs=pst.executeQuery();
if(rs.next())
{
pst=con.prepareStatement("delete from wbmslogin where userid=?");
pst.setString(1,uid);
if((pst.executeUpdate()) > 0)
{
out.println("
User "+uid+" User deleted.
");
}
else
{
out.println("
User "+uid+" Can't be Deleted from Login.
");
}
}
else
{
out.println("
User "+uid+" Does not Exist.
");
}
}catch(Exception e)
{
out.println(e);
}
%>
Back