update2.java

来自「《Java程序设计入门教程》中国青年出版社 一书配套光盘」· Java 代码 · 共 45 行

JAVA
45
字号
/************************ Update.java *********************/import java.io.*;import java.sql.*;import javax.servlet.*;import javax.servlet.http.*;public class Update extends HttpServlet  {  public void doGet(HttpServletRequest req,                    HttpServletResponse res)  throws ServletException, IOException    {    String idStr, title, author, priceStr;    idStr=req.getParameter("id");    title=req.getParameter("title");    author=req.getParameter("author");    priceStr=req.getParameter("price");    int id=Integer.parseInt(idStr);    float price=new Float(priceStr).floatValue();    String sql="UPDATE bookTbl SET " +               "bookId=" + idStr +               ", bookTitle=" + title +               ", bookAuthor=" + author +               ", bookPrice=" + priceStr +               " WHERE bookId=" + id + ";" ;  //    Connection con = null;    Statement statement = null;    ResultSet rs = null;    res.setContentType("text/html");    ServletOutputStream sos=res.getOutputStream();    PrintWriter pw=new PrintWriter(sos,true);    try      {      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");      con = DriverManager.getConnection("jdbc:odbc:bookdb");      statement = con.createStatement();      rs = statement.executeQuery(sql);    //      pw.println("<HTML>");      pw.println("<HEAD>");      pw.println("<TITLE>insert</TITLE>");      pw.println("<BASE HREF=/ TARGET=showFrame>");      pw.println("</HEAD>");      pw.println("<BODY>");      pw.println("<H2>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?