JSP应用JDBC实现数据库事务操作

最新推荐文章于 2024-09-06 23:41:09 发布

KiwiInChina

最新推荐文章于 2024-09-06 23:41:09 发布

阅读量169

点赞数

分类专栏： JSP 文章标签： html jdbc jsp mysql

本文链接：https://blog.csdn.net/clshangsha/article/details/84218478

版权

JSP 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

//MySQL数据库中创建database account,表system1，system2.
create system1(name varchar(20),money double);
create system2(name varchar(20),money double);
insert into system1 values('dick',100000);
insert into system2 values('cll',5000);
//首先创建db6.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>db6.html</title>

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="this is my page">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">



</head>

<body>
<center>
<p><b>银行转账系统</b></p>
<form action="db6.jsp" method="post">
请输入金额：
<input type="text" name="money" />
<input type="submit" value="提交" />
</form>
</center>
</body>
</html>

//创建db6.jsp

<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%@page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>数据库事务操作</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">


</head>

<body>
<center>
<%
Connection con=null;
Statement stmt=null;
double money=Double.parseDouble(request.getParameter("money"));
String sql1="update system1 set money=money-"+money+"where name='dick'";
String sql2="update system2 set money=money+"+money+"where name='cll'";
String url="jdbc:mysql://localhost:3306/account?user=root&password=root&characterEncoding=gb2312";
try{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(url);//连接数据库
con.setAutoCommit(false); //禁止自动提交事务
stmt=con.createStatement();
stmt.executeUpdate(sql1); //没有自动提交sql语句
stmt.executeUpdate(sql2); //也没有自动提交sql语句
con.commit(); //统一提交事务
out.println("<center><b>转账成功</b></center>");
out.println("<center>本次转账金额为："+money+"人民币</center>");
}catch(SQLException e){
//如果其中一项SQL操作失败，就不会执行commit()方法，而是产生相应的sqlexception，
//此时就可以捕获异常代码块中调用rollback()方法撤销事务
con.rollback();
out.print("转账失败，原因："+e.toString());
}finally{
if(stmt!=null){
stmt.close();
}
if(con!=null){
con.close();
}
}
%>
</center>
</body>
</html>