Depressed! ! !
Why don't you have a delete, delete is the first, why! ! ! This problem has been found for a long time but has not found it.
Please help your brother first thank you! !
File name: delete1.jsp
<
% @ Page ContentType = "Text / HTML; Charset = GB2312"%>
<
% @ Page Import = "Java.sql. *"%>
Function sure ()
{
Alert ("OK Delete");
}
->
script>
hEAD>
<% String delete;
String Sure = "SURE ()";
INT I;
Delete = response.EncodeURL ("delete.jsp");
String Number = Request.getParameter ("Number");
IF (Number == Null)
{Number = ""
}
BYTE B [] = Number.getbytes ("ISO-8859-1");
Number = new string (b);
String name = Request.getParameter ("name");
IF (Name == Null)
{Name = "";
}
BYTE N [] = Name.getbytes ("ISO-8859-1");
Name = new string (n);
String Department = Request.getParameter ("Department"); "DEPARTMENT");
IF (department == null)
{department = ""
}
Byte d [] = department.getbytes ("ISO-8859-1");
Department = new string (d);
Connection con = NULL;
STATEMENT SQL = NULL;
ResultSet RS = NULL;
Try {
Class.Forname ("Sun.jdbc.odbc.jdbcodbcdriver");
}
Catch (classnotfoundexception e) {}
Try
{
Con = DriverManager.getConnection ("JDBC: ODBC: Moon", "", "");
SQL = con.createstatement ();
String Condition = "SELECT * from STUDENT WHERE LIKE '%" Number "%' OR Name Like '%" Name "%' OR Professional Like '%" Department "%'"
RS = SQL.ExecuteQuery;
%>
learning number div> td>
| Homename div> td>
| Sex div> td>
| People div> td>
| Birth date div> td>
| Political appearance div> td>
| div> td>
| Home address div> td>
| Electro div> td>
| graduation unit address div> td>
| Admission time div> td>
| Language div> td> | Grade div> td>
| industry div> td>
| Guide teachers div> td>
| unit address div> td>
| learning div> td>
| social relationship div> td>
| Research results div> td>
| Personal resume div> td>
| Delete div> td>
TR> <% While (rs.next ()) { String id = rs.getstring (1); %> | & nbsp <% = id%> div> td>
| & nbsp <% = rs.getstring (2)%> div> td>
| & nbsp <% = rs.getstring (3)%> div> td> | & nbsp <% = rs.getstring (4)%> div> td>
| & nbsp <% = rs.getstring (5)%> div> td>
| & nbsp <% = rs.getstring (6)%> div> td>
| & nbsp <% = rs.getstring (7)%> div> td>
| & nbsp <% = rs.getstring (8)%> div> td>
| & nbsp <% = rs.getstring (9)%> div> td>
| & nbsp <% = rs.getstring (10)%> div> td>
| & nbsp <% = rs.getstring (11)%> div> td>
| & nbsp <% = rs.getstring (12)%> div> td>
| & nbsp <% = rs.getstring (13)%> div> td>
| & nbsp <% = rs.getstring (14)%> div> td>
| & nbsp <% = rs.getstring (15)%> div> td> | & nbsp <% = rs.getstring (16)%> div> td>
| & nbsp <% = rs.getstring (17)%> div> td>
| & nbsp <% = rs.getstring (18)%> div> td>
| & nbsp <% = rs.getstring (19)%> div> td>
| & nbsp <% = rs.getstring (20)%> div> td>
<% String s1 = " |