📄 usingautocommit.jsp

📁 jsp动态网站开发与实例（第3版）源码

💻 JSP

字号:

<%@page contentType="text/html"%><%@page pageEncoding="GB2312"%><%@page import = "java.sql.*"%><html>    <head><title>演示交易</title></head>    <body>    <%            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");        Connection con = DriverManager.getConnection("jdbc:odbc:webData");        con.setAutoCommit(false) ;         Statement smt =  con.createStatement();                String sql1 = "INSERT INTO Author"+                      "(ID,Name,eMail,Phone,Address) "+                      "VALUES "  +                      "(2015,'徐帆','bear@fj.com','025-84210020',"+                      "'江苏南京')";                String sql2 = "INSERT INTO Books"+                      "(ID,Title,AuthorID,MemoText,ISBN,Amount) "+                      "VALUES "  +                      "(1007,'Photoshop CS2实用培训教程',2015,"+                      "'探讨Photoshop CS2相关知识和基本操作','888-888-888-Z',15)";        try{            int resultCount1 =smt.executeUpdate(sql1) ;             if(resultCount1>0 ){                int resultCount2=smt.executeUpdate(sql2) ;                con.commit() ;                 out.println("作者徐帆相关数据输入完成!!") ;                         } else {                out.println("作者徐帆相关数据输入失败!!") ;                  con.rollback() ;             }        }catch(Exception ex){            out.println(ex.getMessage()+"<br>") ;             out.println("数据输入失败，所有操作回复!!") ;              con.rollback() ;         }      %>    </body></html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -