📄 checkdelete.jsp

📁 基于JSP的公交查询系统,很好用的,适于学习,操作语句全在jsp页面里

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>删除确认</title>
<style type="text/css">
<!--
body {
	background-image: url(../Picture/index-top_2.gif);
	margin-left: 50px;
}
a:link {
	color: #000000;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
	color: #000000;
}
a:hover {
	text-decoration: none;
	color: #FF0000;
}
a:active {
	text-decoration: none;
	color: #FF0000;
}
.STYLE1 {
	font-size: 18px;
	font-weight: bold;
}
-->
</style></head>
 
<body>
 
  <% Connection con;
    String statement="";
	// out.println("dfsdsf");
	String BusId = new String(request.getParameter("busid").getBytes("ISO8859_1"),"GBK");
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	     }
		catch(ClassNotFoundException e){}
		 
	try{  
	      con=DriverManager.getConnection("jdbc:odbc:nbos","","");
	      Statement sql=con.createStatement(); 
		  
		  statement="delete * from bus where BusID='"+BusId+"'";
		  sql.executeUpdate(statement);
		
		 %>

 <table width="332" height="98" border="1">
   <tr>
     <td width="322" height="22" background="../Picture/topbg.gif"><div align="center"><strong class="STYLE1"> 车次删除成功 </strong></div></td>
   </tr>
   <tr>
     <td height="49" background="../Picture/l33.gif"><p>你已成功把车次号为<font color="#FF0000"><%=BusId%></font>的车从数据库中删除!</p>
     <p>继续删除<strong><a href="delete.jsp">点击这里</a></strong></p></td>
   </tr>
   <tr>
     <td background="../Picture/bottombg.gif">&nbsp;</td>
   </tr>
 </table>
 <p><strong> </strong></p>
 <p><strong>
   <%    }  
		  catch(Exception e)
                 {  }		  
  %>
  </strong>
</p>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -