insert.jsp

经典的“企业内部管理信息系统”JSP源代码

<%@ page errorPage="error.jsp" %>
<%@ page language="java"%>
<%@ page import="java.util.Date" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%><%
if (session.getAttribute("admin")==null || session.getAttribute("admin")==""){
	response.sendRedirect("login.jsp");
} %> 
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<%
String d,tempclass2,sql,tempclass1,file1,file2,file3,oldfile1,oldfile2,oldfile3;
//声明变量
Date dd = new Date();//定义一个date型的变量
d = dd.toLocaleString();//日期格式转换为当前系统设定值
oldfile1 = request.getParameter("file1").trim();
oldfile2 = request.getParameter("file2").trim();
oldfile3 = request.getParameter("file3").trim();
file3=new String(oldfile3.getBytes("ISO8859_1"),"GBK");
file2=new String(oldfile2.getBytes("ISO8859_1"),"GBK");
file1=new String(oldfile1.getBytes("ISO8859_1"),"GBK");

String author=new String(request.getParameter("author").getBytes("ISO8859_1"),"GBK");
String news=new String(request.getParameter("news").trim().getBytes("ISO8859_1"),"GBK");
String title=new String(request.getParameter("title").trim().getBytes("ISO8859_1"),"GBK");
//得到post提交过来的参数值，并予以编码转换
if(news.equals("")||title.equals("")) response.sendRedirect("add.jsp");//如果记录标题为空或是正文为空，则不予处理，返回到记录添加页面
else
{
String parentclass=new String(request.getParameter("selMain").getBytes("ISO8859_1"),"GBK");

String class2=new String(request.getParameter("selSlave").getBytes("ISO8859_1"),"GBK");
//得到记录的类目信息，并予以编码转换
ResultSet rs = sqlbean.executeQuery("select * from class where parentclass='"+parentclass+"' and class='"+class2+"'");
//调用sqlbean的executeQuery方法找到类别标识，并将结果赋予rs这个记录集
rs.first();	//如果返回的记录集不为空
String classid2=rs.getString("id");
rs.close();
int classid = Integer.parseInt(classid2);//将要添加的类ID转换为int类型
//sql="INSERT INTO news (news, d,parentclass,class,title) Values ('"+news+"', '"+d+"','"+parentclass+"', '"+class2+"', '"+title+"')";
sql="INSERT INTO news (news,classid, d,parentclass,class,title,file1,file2,file3,author,hit) Values ('"+news+"', "+classid+",'"+d+"','"+parentclass+"', '"+class2+"', '"+title+"', '"+file1+"', '"+file2+"', '"+file3+"', '"+author+"',0)";
//实现记录插入操作的SQL语句
sqlbean.executeInsert(sql);//调用sqlbean的executeInsert方法将记录插入数据库中
}
%>
<jsp:forward page="add_cfrm.jsp"/>