银行存款业务
首先,定义一个工具常量类. Constants.java
package cn.itcast.util;
//常量池
public class Constants {
/*
* 与数据库db相关的常量
*/
public static final String DB_ERROR_GETCONNECTIONERROR="获取连接异常";
public static final String DB_ERROR_CLOSTRESULTSETERROR="获取结果集异常";
public static final String DB_ERROR_CLOSESTATEMENTERROR="关闭statement对象异常";
public static final String DB_ERROR_CLOSECONNECTIONERROR="关闭连接异常";
public static final String DB_ERROR_STARTERROR="开始事务异常";
public static final String DB_ERROR_COMMITERROR="提交事务异常";
public static final String DB_ERROR_ROLLBACKERROR="获取结果集异常";
public static final String DB_ERROR_SETERROR="设置连接的自动提交方式异常";
/*与数据操作有关的异常*/
public static final String DAO_ERROR_QUERYBYID="通过账号查询余额失败";
public static final String DAO_ERROR_UPDATEBYID="通过账号更新余额失败";
public static final String DAO_ERROR_INSERTBYID="添加账号失败";
……
}
第0步、index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<body>
存款页面:<br/>
<form action="${pageContext.request.contextPath}/servlet/InAccountServlet" method="post">
<table>
<tr>
<td>账户:</td>
<td><input type="text" name="accountid"/></td>
</tr>
<tr>
<td>存入金额:</td>
<td><input type="text" name="inbalance"/></td>
</tr>
<tr>
<td><input type="submit" value="存入"/></td>
<td></td>
</tr>
</table>
</form>
</body>
</html>
第一步、DBManager.java
package cn.itcast.db;
public class DBManager {
private static DBManager dbManager=new DBManager();
private BasicDataSource bds=null;
private DBManager(){
bds=new BasicDataSource();
bds.setUsername("root");
bds.setPassword("root");
bds.setUrl("jdbc:mysql://localhost:3306/test");
bds.setDriverClassName("com.mysql.jdbc.Driver");
bds.setInitialSize(4);
bds.setMaxActive(10);
bds.setMaxIdle(5);
bds.setMinIdle(3);
bds.setMaxWait(5000);
}
public static DBManager getDBManager(){
return dbMana