📄 fakuan.jsp
字号:
<%@page contentType = "text/html;charset = gb2312" %>
<%@ page import="java.sql.*"%>
<%String id = request.getParameter("readerID");
if(id.equals("")){
response.sendRedirect("./jiaofakuan.jsp?jieguo=kong");
}
String fakuan = "";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/library?user=root&password=linux&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="select sum(fakuan) from fakuan where readerid = '"+id+"'";
ResultSet rs=stmt.executeQuery(query);
while(rs.next()){
fakuan=rs.getString("sum(fakuan)");
}
if(fakuan==null){
fakuan="0";
}
%>
<html>
<head><title></title></head>
<body>
<h1><blockquote>您要交的罚款一共<%=fakuan %>元</blockquote></h1>
<form action="servlet/jiaofakuanController" method="post">
<table width = 150 height = 150 Align = "left">
<tr><td> <input type = hidden name = "id" value = <%=id %> >
<input type = submit value=" 确认 " name = "de"> </td></tr>
<tr><td><a href = ./jiaofakuan.jsp>返回</a></td></tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -