?? gform.jsp
字號:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.util.Date" %>
<%!
Connection conn=null;
Statement stmt=null;
String sql="";
String str="";
String ip="";
%>
<%
request.setCharacterEncoding("GBK");
String id=request.getParameter("id");
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("語句輸入錯誤!");
}
String Name=request.getParameter("Name");
String Memo=request.getParameter("Memo");
if(request.getParameter("nm")==null)
ip=request.getRemoteAddr();
else
ip="匿名發表";
Date m_Date=new Date();
String m_DateString=m_Date.toLocaleString();
if(Name == null || Name.equals("") || Memo == null || Memo.equals(""))
{
out.println("<body bgcolor = '#FFFFFF' background='bg.jpg'>");
out.println("<center><font size='6'><B>請將表單填入完整!</B></font><br>");
return;
}
sql="Insert Into gbook(name,content,gtime,news_id,ip) Values(";
sql+="'" + Name + "',";
sql+="'" + Memo + "','"+m_DateString+"',";
sql+=id+",";
sql+="'" +ip+"')";
stmt.executeUpdate(sql);
response.sendRedirect("newswind.jsp?id="+id);
%>
<%
ResultSet rs = null;
ResultSet rsTmp = null;
rsTmp = stmt.executeQuery("select count(id) as countid from news");
rsTmp.next();
rsTmp.close();
sql="SELECT * from news order by ID desc";
rs = stmt.executeQuery( sql );
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -