📄 edit.java
字号:
/************************ Edit.java *********************/
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Edit extends HttpServlet
{
public void doGet(HttpServletRequest req,
HttpServletResponse res)
throws ServletException, IOException
{
String idStr=req.getParameter("id");
String sql="SELECT * FROM bookTbl WHERE bookId=" +
idStr + ";" ;
//
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);
ResultSetMetaData rsmd = rs.getMetaData();
int colCount = rsmd.getColumnCount();
//
pw.println("<HTML>");
pw.println("<HEAD><TITLE>bookdb</TITLE></HEAD>");
pw.println("<BODY>");
rs.next();
pw.println("<FORM ACTION=/servlets/Update METHOD=post>");
pw.println("⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -