|
<%
String name=request.getParameter("t1");
String id=request.getParameter("t2");
String phone=request.getParameter("t3");
String pwd=request.getParameter("t4");
if(!(name==" " && id==" " && phone==" " && pwd== " "))
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:abc", "scott", "tiger");
Statement st=con.createStatement();
st.executeQuery("insert into student values("+id+",'"+name+"',"+phone+",'"+pwd+"')");
out.println ("Insert Successful");
}catch(Exception e1)
{
}
}
%>
<%
if(!( id==" " ))
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:abc", "scott", "tiger");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from student");
while(rs.next())
{
String username=rs.getString(1);
if(id.equals(username) )
{
%>
|
<%
}
}
if(rs.isLast()==true)
{
out.println("Login Failed,Please try Again");
}
}catch(Exception e1)
{
}
}
%>
<%
id=request.getParameter("t2");
if(!(id==" "))
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:abc", "scott", "tiger");
Statement st=con.createStatement();
String query="delete from student where stud_id="+id;
st.executeUpdate(query);
}catch(Exception e1)
{
}
}
%>
<%
name=request.getParameter("t1");
id=request.getParameter("t2");
phone=request.getParameter("t3");
pwd=request.getParameter("t4");
if(!(name==" " && id==" " && phone==" " && pwd== " "))
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:abc", "scott", "tiger");
Statement st=con.createStatement();
String query="update student set stud_id="+id+",stud_name='"+name+"',phone="+phone+",pwd='"+pwd+"'where stud_id="+id;
st.executeUpdate(query);
}catch(Exception e1)
{
}
}
%>