📄 bbsdealaddnew.jsp

📁 j2ee实现简单的bbs功能

💻 JSP

字号:

<%@ page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id = "dBean" scope="session" class="BeanLink.DBBean"/>
<html>
<head>
<title>发表帖子</title>
</head>
<body>
<center>
<%
	String sdriver="sun.jdbc.odbc.JdbcOdbcDriver";
	String sconn="jdbc:odbc:mydb";
	String suser="";
	String spass="";
	String tablename="board";

	String loginSign = (String)session.getValue("loginSign");
	String username = (String)session.getValue("username");//作者名
	if(loginSign!=null&&loginSign.equals("OK"))
	{//显示文章列表
		out.println("发表帖子");
	}
	else
	{//无此权限,定向到用户登录页面
		response.sendRedirect("../index.jsp");
	}

	String title = request.getParameter("title");
	String content = request.getParameter("content");
	title = new String(title.getBytes("8859_1"));
	content = new String(content.getBytes("8859_1"));
	String emote = request.getParameter("emote");
	
	if(title==null||title.equals("")){title="无标题";}
	if(content==null||content.equals("")){content="无内容";}
	title = turn(title);
	content = turn(content);

	dBean.openConn(sdriver,sconn,suser,spass);
	String sql = "insert into "+tablename +" (title, speaker, emote, content) values('"+title+"','"+username+"','"+emote+"','"+content+"')"; 
	dBean.executeUpdate(sql);
	dBean.closeConn();
	response.sendRedirect("bbslist.jsp");
%>
<%!
public String turn(String str){
//下面的代码将字符串以正确方式显示（包括回车，换行，空格）
while(str.indexOf("\n")!=-1){ 
str = str.substring(0,str.indexOf("\n"))+"<br>"+str.substring(str.indexOf("\n")+1);
} 
while(str.indexOf(" ")!=-1){ 
str = str.substring(0,str.indexOf(" "))+"&nbsp;"+str.substring(str.indexOf(" ")+1); 
} 
return str;
}
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -