📄 newsedit2.jsp
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%!
String id = "";
String title = "";
String title1 = "";
String content = "";
String keyw = "";
String author = "";
int currid = 0;
String sql = "";
ResultSet rs = null;
Statement stmt= null;
Connection conn=null;
%>
<link rel="stylesheet" type="text/css" href="news.css">
<%
request.setCharacterEncoding("GBK");
try{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Program Files/Apache Group/Tomcat 4.1/webapps/examples/jsp/db1.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(strurl);
stmt=conn.createStatement();
}
catch(Exception e)
{
out.println("语句输入错误!");
}
// 下面主要是为了进行显示
if(request.getParameter("id") != null) {
id = request.getParameter("id");
sql="select * from news where id=" + request.getParameter("id");
rs = stmt.executeQuery( sql );
if(rs.next()) {
title1 = rs.getString("title");
content = rs.getString("content");
keyw = rs.getString("keyw");
author = rs.getString("author");
rs.close();
%>
<form name=form1 method="post" action="savenews.jsp">
<input value="<%=id%>" type=hidden name=id>
<P align="center">标 题：<INPUT size=95 name=title value=<%=title1%>></P>
<P align="center">内 容：<TEXTAREA cols=73 name=body rows=15><%=content%></TEXTAREA></P>
<P align="center">关键字：<INPUT size=25 name=keyw value=<%=keyw%>>
作者：
<INPUT size=25 name=author value=<%=author%>>
<p align="center">
<INPUT class=buttonface type=submit value=" 确 定 ">
<INPUT class=buttonface type=reset value=" 清 除 "></p>
</form>
<%
} else {
out.println("<hr>");
out.println("<center>非法的id号！</center>");
out.println("<hr>");
}
}
%>
<html>
<body bgcolor=lightyellow>
<P align="center"><a href="newsedit.jsp">编辑新闻</a> <a href="default.jsp">查看新闻</a>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -