📄 1.jsp~26~
字号:
<%@page contentType="text/html; charset=GBK"%><%@page import="java.sql.*"%><%request.setCharacterEncoding("gb2312");%><link href="2.css" rel="stylesheet" type="text/css" /><script type="text/javascript">function mycheck(){alert("更新 成功！");}</script><HTML><BODY><center><div id="container"><center><font SIZE="30" color="red">管理员更新教材网页</font> <div id="Header"><div id="menu"><ul> <li><a href="jsp3.jsp">查看可申请教材目录</a></li> <li class="menuDiv"></li> <li><a href="jsp2.jsp">返回主页</a><br></li> <li class="menuDiv"></li></ul></div></div> <% 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");%><%Statement stmt=null; PreparedStatement pstmt=null; String sql = "insert into s(bnum,bname,bjiage,booknum,cbs,filename,shuoming) VALUES(" +getbnum + ",'"+getbname + "'," +getbjiage +"," +getbooknum + ",'" +getcbs + "','" +getfile+ "','" +getshuoming+ "')"; //加载JDBC-ODBC桥驱动 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) {}%><table border="0" cellpadding="0" cellspacing="0" align="center"><tr><td height=20 width="100%" bgcolor=#6681D9> <font color="#ffffff">添加教材</font></td></tr><tr><td><FORM Action="1.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"> </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"> </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" > </td><td width="20"> </td><td align="center"><input type="submit" name="post" value="确 定" onclick="mycheck()"></td></tr></table></form> </td></tr></table><input type="button" name = "a" value = "返回" onclick = "javacscript:history.back()"><html><body>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -