📄 11-18.txt

📁 jsp常用实例讲解

💻 TXT

字号:

<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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -