paymentpage_1.jsp

图书管理系统

<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
<%
        Connection conn=null;
        Statement stmt=null;
        ResultSet rs=null;
try
{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
        out.println(ce.getMessage());
}
request.setCharacterEncoding("GBK");
String c1=request.getParameter("payno");
String c2=request.getParameter("payword");
String c3=request.getParameter("payBno");
String c4=request.getParameter("paymail");
String c5=request.getParameter("payaddress");
String c6=request.getParameter("mailmethod");

try
{
     conn=DriverManager.getConnection("jdbc:odbc:xgx");
     stmt=conn.createStatement();

		stmt.executeUpdate("INSERT INTO payment VALUES ('"+c1+"','"+c2+"','"+c3+"','"+c4+"','"+c5+"','"+c6+"')");

     
     rs=stmt.executeQuery("SELECT* FROM payment WHERE pNo=(SELECT cNo FROM customer WHERE cNo='"+c1+"')");    

     out.println("<table border='1'>");
while(rs.next())
{
    out.println("<tr><td>"+rs.getString("pNo")+"</td>");
    out.println("<td>"+rs.getString("pBno")+"</td>");
    out.println("<td>"+rs.getString("pMail")+"</td>");
    out.println("<td>"+rs.getString("pAddress")+"</td>");
    out.println("<td>"+rs.getString("method")+"</td></tr>");
}
  out.print("</table>");
}
catch(SQLException e)
{out.println(e.getMessage());
}
finally
{
stmt.close();
conn.close();
}
%>