📄 update2.java
字号:
/************************ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -