addtype.jsp

基于JSP＋MYSQL的教学资源库系统

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<jsp:useBean class="database.managerDB" id="myManagerDB" scope="page"/>	
<%
request.setCharacterEncoding("gb2312");
String getMultiMediaType=request.getParameter("multiMediaType");
String getSubjectType=request.getParameter("subjectType");
String sql="";
sql+="insert into classification(MultiMediaType,SubjectType)";
sql+=" values('"+getMultiMediaType+"','"+getSubjectType+"') ";
if(myManagerDB.connectDB())
{
	myManagerDB.executeSQL(sql);
	myManagerDB.closeDB();
	out.print("<script>alert('素材类别添加成功!');location.href='addTypePage.jsp';</script>");	
}
else
{
	out.println("数据库接连失败,请稍候再试!");
}
%>