📄 xwxiugai.jsp~16~
字号:
<%@page contentType="text/html; charset=GBK"%><%@page import="java.sql.*"%><%request.setCharacterEncoding("gb2312");%><html><title>新闻区</title><body><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><%!int i=0;String getid;%><%if(i==0){getid=request.getParameter("id");i=i+1;}%><FORM Action="xwxiugai.jsp" method="POST" name="form2"><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">含*为必须填写</font></td></tr><tr><td align="right" >新闻名称</td><td width="20">*</td><td width="500"><input name="xinwenname" value="" size="64"></td></tr><tr><td align="right" >新闻类别</td><td width="20">*</td><td width="100"><select name="xinwentype"><option value="比赛新闻">比赛新闻</option><option value="比赛信息">比赛信息</option><option value="运动员新闻">运动员新闻</option><option value="实时新闻">实时新闻</option></select></td></tr><tr><td align="right" >新闻图片</td><td width="20">*</td><td width="200"><input type="file" name="xinwentupian" ></td></tr><tr><td align="right" valign="top">新闻说明</td><td width="20" valign="top"> </td><td><textarea name="xinwenshuoming"cols="64" rows="5"></textarea></td></tr><tr><td align="right" > </td><td width="20"> </td><td align="center"><input type="submit" name="post" value="确 定" ></td></tr></table></form> </td></tr></table><%!String xinwenname,xinwentype,xinwenshuoming;%><%Statement stmt=null; xinwenname=request.getParameter("xinwenname"); xinwentype=request.getParameter("xinwentype"); xinwenshuoming=request.getParameter("xinwenshuoming");//用于获取图皮//String filename=request.getParameter("xinwentupian");//FileInputStream in=new FileInputStream(filename);String sql = "update xinwen set xinwenname='"+xinwenname +"',xinwentype='"+xinwentype +"',xinwenshuoming='"+xinwenshuoming +"' where id like'"+getid+"';";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); System.out.print("I:" + i); ResultSet p = stmt.executeQuery(sql); } catch (Exception e) {}%><a href="xw.jsp">返回新闻中心主页</a></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -