OA系统

开发平台：

Java

newinfo_do.jsp~1~：源码内容

							<%@ page contentType="text/html; charset=GBK" import="java.sql.*,java.lang.*" buffer="64kb" %>
<%request.setCharacterEncoding("gbk"); %>
<html>
<head>
<title>
newarticle_do
</title>
</head>
<jsp:useBean id="sql" scope="page" class="control.sqlcontrol" />
<body bgcolor="#ffffff">
<%
sql.getSQL2005conn("dbconfig.xml");
String title = request.getParameter("title");
String usersid = request.getParameter("usersid");
String context = request.getParameter("context");
String isread = "no";
String depar = request.getParameter("depar");
String year = request.getParameter("year");
String month = request.getParameter("month");
String day = request.getParameter("day");
String date = year+"-"+month+"-"+day;
StringBuffer getselect = new StringBuffer();
getselect.append("insert into perinfo(");
getselect.append("usersid,");
getselect.append("depar,");
getselect.append("title,");
getselect.append("date,");
getselect.append("context,");
getselect.append("isread) values (");
getselect.append("'"+usersid+"','"+depar+"','"+title+"','"+date+"','"+context+"','"+isread+"');");
String select = getselect.toString();
sql.MouChoose(select);
sql.closeDB();
%>
<div align="center">
<h3>被忘录添加完毕,请进行其他操作!</h3><hr>
<a href="newinfo.jsp">继续添加</a>
</div>
</body>
</html>

						