📄 6xiugai.jsp~19~

📁 JAVA实验图形 =各种的 JAVA简单代码出初学者必备！！！！！！！！！
💻 JSP~19~
字号:
<%@page contentType="text/html; charset=GBK"%><%@page import="java.sql.*"%><%request.setCharacterEncoding("gb2312");%><html><title>后台管理</title><link href="2.css" rel="stylesheet" type="text/css" /><html><center><body><%String getnum="";getnum=request.getParameter("num");out.print(""+getnum);%>　<div id="Header"></div><table  border="0" cellpadding="0" cellspacing="0"  align="center"><tr><td height=20 width="100%" bgcolor=#6681D9>&nbsp;<font color="#ffffff">后台管理</font></td></tr><tr><td><FORM Action="6xiugai.jsp" method="POST" name="form1"><table width="%100" border="0"><tr><td  colspan="3" height=20></td></tr><tr><td align="right" width="120" valign="top">说明：</td><td width="20">&nbsp;</td><td width="450"><font color="red">含*为必须填写（图片格式限制在200*150）</font></td></tr><tr><td align="right" >书号</td><td width="20">*</td><td width="500"><input name="bnum"  value="" size="64"></td></tr><tr><td align="right"> 教材名</td><td width="20">*</td><td width="100"><input name="bname"  value="" size="64"></td></tr><tr><td align="right" >数量</td><td width="20">*</td><td width="200"><input name="booknum"  value="" size="64"></td></tr><tr><td align="right" >教材出版社</td><td width="20">*</td><td width="200"><input name="cbs"  value="" size="64"></td></tr><tr><td align="right" >教材价格</td><td width="20">*</td><td width="200"><input name="bjiage"  value="" size="64"></td></tr><tr><td align="right" >教材图片</td><td width="20">*</td><td width="200"><input type="file" name="filename"  value="" size="64"></td></tr><tr><td align="right" valign="top">教材简要说明</td><td width="20" valign="top">&nbsp;</td><td><textarea  name="shuoming"cols="64" rows="5"></textarea></td></tr><tr><td align="right" >显示主页发布</td><td width="20">*</td><td width="100"><select name="xianshi"><option value="1">在主页显示</option><option value="2">不在主页显示</option></select></td></tr><tr><td align="right" >&nbsp;</td><td width="20">&nbsp;</td><td  align="center"><input type="submit" name="post" value="确 定" onclick="mycheck()"><input type="button"  name   =   "a"   value   = "返回" onclick   =  "javacscript:history.back()"></td></tr></table></form> </td></tr></table><%  String getbjiage = request.getParameter("bjiage");  String getbnum = request.getParameter("bnum");  String getbooknum= request.getParameter("booknum");  String getbname = request.getParameter("bname");  String getcbs = request.getParameter("cbs");   String getfile = request.getParameter("filename");    String getshuoming = request.getParameter("shuoming"); String getxianshi = request.getParameter("xianshi");%><%Statement stmt=null;out.print("getnum:"+getnum);String sql = "update s set bnum='"+getbnum +"',bname='"+getbname +"',bjiage='"+getbjiage +"',booknum='"+getbooknum +"',cbs='"+getcbs +"',filename='"+getfile +"',shuoming='"+getshuoming +"',xianshi='"+getxianshi +"' where id like '"+getnum+"';";try {            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");            //定义JDBC URL        }catch (Exception e) {        out.println(e.getMessage());        }          try{        String url = "jdbc:odbc:s";            //得到与数据库的连接            Connection con = DriverManager.getConnection(url);            //显示UPL和连接信息            System.out.print("URL:" + url);            System.out.print("Connection:" + con);            //得到一个Statement对象            stmt = con.createStatement();            //执行SQL语句            System.out.print("SQL:" + sql);            ResultSet p = stmt.executeQuery(sql);            } catch (Exception e) {}%></body></html>
⌨️ 快捷键说明

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