11-18.txt
来自「jsp常用实例讲解」· 文本 代码 · 共 48 行
TXT
48 行
<html>
<head>
<%@ page contentType="text/html;charset=gb2312" %>
<title>新贴录入数据库</title>
</head>
<%@ page language="java" import="java.sql.*" %>
<%-- 连接数据库使用的语句 --%>
<%
String url=new String();
String sql=new String();
url="jdbc:odbc:luntan";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(url);
Statement stat1=conn.createStatement();
Statement stat2=conn.createStatement();
String strSql1=new String();
String strSql2=new String();
%>
<%
String speaker=(String)session.getValue("username");
String title=request.getParameter("title");
if(title.equals(""))
title="无主题";
String content=request.getParameter("replycontent");
if(content.equals(""))
content="无内容";
int serial=Integer.parseInt(request.getParameter("serial"));
strSql1="insert into db2admin.board(title,speaker,parent_no,content) values('"+title+"','"+speaker+"',"+serial+",'"+content+"')";
stat1.executeUpdate(strSql1);
//将这条贴子的回复数加1
strSql2="update db2admin.board set reply_num=reply_num+1 where serial_no="+serial;
stat2.executeUpdate(strSql2);
%>
<body onload="load2()">
<script language=JavaScript>
function load2(){
opener.setTimeout("submit11()",1500)
self.setTimeout("exit()",1500)
}
function exit(){
window.close()
}
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?