?? newsadd.jsp
字號:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.lang.Math.*" %>
<%!
String id = "";
String title1 = "";
String content = "";
String keyw = "";
String author = "";
int currid = 1;
String sql = "";
ResultSet rsTmp = 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("語句輸入錯誤!");
}
rsTmp = stmt.executeQuery( "select max(id) as maxid from news" );
if(rsTmp.next()) currid = rsTmp.getInt("maxid") + 1;
rsTmp.close();
request.setCharacterEncoding("GBK");
if(request.getParameter("title")!=null) title = request.getParameter("title");
if(request.getParameter("body")!=null) content = request.getParameter("body");
if(request.getParameter("keyw")!=null) keyw = request.getParameter("keyw");
if(request.getParameter("author")!=null) author = request.getParameter("author");
// 如果title不為空，則添加記錄
if(request.getParameter("title")!=null) {
// 執行插入操作
sql = "insert into news values (" + currid ;
sql += ",'" + title + "','" + content + "',";
sql += "date(),'" + keyw + "','" + author + "')";
stmt.executeUpdate( sql );
out.println("<hr>");
out.println("<h2>新聞添加成功！</h2>");
out.println("<hr>");
}else {
out.println("<hr>");
out.println("<h2><center>編輯一些最新消息！</center></h2>");
out.println("<hr>");
}
%>
<html>
<body bgcolor=lightblue>
<form name=form1 method="post" action="newsadd.jsp">
<P align="center">標 題：<INPUT size=95 name=title value=""></P>
<P align="center">內 容：<TEXTAREA cols=73 name=body rows=15></TEXTAREA></P>
<P align="center">關鍵字：<INPUT size=25 name=keyw value="">
作者：
<INPUT size=25 name=author value="">
<p align="center">
<INPUT class=buttonface type=submit value=" 確 定 ">
<INPUT class=buttonface type=reset value=" 清 除 "></p>
</form>
<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 + -