JSP MVC 学习
1.dbconnection.jsp
<%!
ResultSet rs1,rs2,rs3;
Connection con;
Statement stmt;
int acno, balance;
String userid;
String Accno;
public void MakeConnection()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("Jdbc:Oracle:thin:@localhost:1521:ORCL1","scott","tiger");
stmt = con.createStatement();
}
catch(Exception e)
{
System.out.println(e);
}
}
%>
2.customerlogin.html
<script language="javascript">
function IsEmpty()
{
var acno=document.searchcust.customerno.value;
if(acno==0)
{
alert("Please Enter Customer Account Number\n");
return false;
}
if(isNaN(acno))
{
alert("Customer Number Should Be numeric\n");
document.searchcust.customernor.value="";
return false;
}
return true;
}
</script>
<form name="searchcust" action="customerrecord" method="post">
<body bgcolor="LightSeaGreen">
<table align="center" >
<Tr><td > EnterCustomer Number</td> <td><input type="text" name="customerno" value=""></td>
<td><input type="submit" name="searchId" value="Confirm" onClick="return IsEmpty();"></td></tr>
</table>
</form>
3.Customer-Account-Wise-Details.jsp
<%@ page import ="java.sql.*"%>
<%@ include file="dbconnection.jsp"%>
<%
MakeConnection();
try
{
String Accno=request.getParameter("acno");
acno=Integer.parseInt(Accno);
rs1=stmt.executeQuery("select * from cust_account_info where user_id="+acno);
rs1.next();
userid=rs1.getString("user_id");
balance=rs1.getInt("current_balance");
rs1.close();
stmt.close();
}
catch(Exception e)
{
out.println(e);
}
try
{
stmt = con.createStatement();
rs2=stmt.executeQuery("select * from cust_personal_info where user_id="+userid);
rs2.next();
String FirstName=rs2.getString("firstname");
String LastName=rs2.getString("lastname");
rs2.close();
stmt.close();
%>
<CENTER><b>Customer name: <%=FirstName%> <%=LastName%><br>
Customer ID:<%=userid%><br>
Balance : <%=balance%><br></b>
</CENTER>
<body bgcolor ="DarkSalmon"></body>
<form name="transaction" action="" method="post">
<table BORDER="" WIDTH="50%" CELLSPACING="2" CELLPADDING="2" align="center">
<th><tr><td bgcolor="blue"> Account Number </td>
<td bgcolor="blue"> Description </td>
<td bgcolor="blue">Amount </td><td bgcolor="blue">Transaction Type</td> <td bgcolor="blue">Transaction Date</td> <td bgcolor="blue">Closing balanace</td> </tr></th>
<br>
<%
stmt = con.createStatement();
rs3=stmt.executeQuery("select * from transaction where user_id="+acno);
while(rs3.next())
{
%>
<tr><td bgcolor="white"><%=acno%> </td> <td bgcolor="white"><%=rs3.getString("description")%> </td> <td bgcolor="white"><%=rs3.getInt("amount")%><td bgcolor="white"><%=rs3.getString("transaction_type")%> </td><td bgcolor="white"><%=rs3.getString("transaction_date")%> </td> </td><td bgcolor="white"> <%=rs3.getInt("closing_balance")%> </td></tr>
<%
}
rs3.close();
}//try close
catch(Exception e)
{
out.println(e);
}
%>
</table>
<input type="button" name="close" value="Close" onClick="window.close();">
</form>
4.customer-account-view.jsp
<%@ page import ="java.sql.*"%>
<%!
ResultSet rs1,rs2;
String UserName,FirstName,LastName;
String Accno;
%>
<%
try
{
rs1=(ResultSet)request.getAttribute("record");
%>
<body bgcolor ="DarkSalmon"></body>
<form name="transaction" action="" method="post">
<table BORDER="" WIDTH="50%" CELLSPACING="2" CELLPADDING="2" align="center">
<th><tr><td bgcolor="blue"> Account Number </td>
<td bgcolor="blue"> Account Type </td>
<td bgcolor="blue">Amount Balance </td><td bgcolor="blue">Mini Statement</td></tr></th>
<br>
<%
while(rs1.next())
{
Accno=rs1.getString("user_id");
%>
<tr><td bgcolor="white"><%=Accno%> </td> <td bgcolor="white"><%=rs1.getInt("current_balance")%> </td>
<td bgcolor="white"> <a target="_blank" href="Customer-Account-Wise-Details.jsp?acno=<%=Accno%>"> <b>View</b></a></td></tr>
<br>
<%
}
rs1.close();
}//try close
catch(Exception e)
{
out.println(e);
}
%>
</table>
</form>
5.ModelDB.java
//package model;
import java.sql.*;
public class ModelDB
{
Connection con;
Statement stmt;
ResultSet rs;
public ModelDB()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("Jdbc:Oracle:thin:@localhost:1521:ORCL1","scott","tiger");
stmt = con.createStatement();
}
catch(Exception e)
{
System.out.println(e);
}
}
public ResultSet getRecordSet(String custno)
{
try
{
rs=stmt.executeQuery("Select * from cust_account_info where user_id="+custno);
}
catch(Exception e)
{
System.out.println(e);
}
return rs;
}
}
6.SearchCustomerNo.java
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import java.util.*;
//import model.*;
public class SearchCustomerNo extends HttpServlet
{
String custno;
PrintWriter writer;
public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
{
try
{
res.setContentType("text/html");
writer = res.getWriter();
custno = req.getParameter("customerno");
ModelDB m=new ModelDB();
ResultSet rs= m.getRecordSet(custno);
req.setAttribute("record", rs);
RequestDispatcher view = req.getRequestDispatcher("customer-account-view.jsp");
view.forward(req, res);
writer.close();
}
catch(Exception e)
{
writer.println(e);
}
}
}
7.web.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app>
<display-name>Welcome to login screen</display-name>
<description>
Welcome to login example
</description>
<servlet>
<servlet-name>cust</servlet-name>
<servlet-class>SearchCustomerNo</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>cust</servlet-name>
<url-pattern>/customerrecord</url-pattern>
</servlet-mapping>
</web-app>
