📄 delcustomer.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Insert title here</title>
</head>
<body>
<%
//设定获取的参数的字符编码
request.setCharacterEncoding("gb2312");
//获取参数的值
String id = request.getParameter("PID");
//注意该文件delcustomer.jsp根本没用
//写入数据
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection cn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:name","Scott","Tiger");
String sqlStr = "Delete From Customer Where CustID = "+id;
//CustomerID传进去
Statement stmt = cn.createStatement();
stmt.execute(sqlStr);
stmt.close();
cn.close();
response.sendRedirect("Customer.jsp");
}
catch(Exception e)
{
out.println("系统出错了，呵呵~~~~，原因："+e.getMessage());
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -