- Visual C++源码
- Visual Basic源码
- C++ Builder源码
- Java源码
- Delphi源码
- C/C++源码
- PHP源码
- Perl源码
- Python源码
- Asm源码
- Pascal源码
- Borland C++源码
- Others源码
- SQL源码
- VBScript源码
- JavaScript源码
- ASP/ASPX源码
- C#源码
- Flash/ActionScript源码
- matlab源码
- PowerBuilder源码
- LabView源码
- Flex源码
- MathCAD源码
- VBA源码
- IDL源码
- Lisp/Scheme源码
- VHDL源码
- Objective-C源码
- Fortran源码
- tcl/tk源码
- QT源码
admin_knowadd.jsp
资源名称:0102010.rar [点击查看]
上传用户:nbluoke
上传日期:2013-08-09
资源大小:4851k
文件大小:2k
源码类别:
教育系统应用
开发平台:
WORD
- <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
- <%@ page import="jinghua.*"%>
- <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
- </jsp:useBean>
- <%!boolean debug=false;
- %>
- <%
- String name=""+request.getParameter("name");
- String gradenote=""+request.getParameter("selgrade");
- String subject=""+request.getParameter("selsubject");
- name=Tools.codestring(name);
- name=name.trim();
- gradenote=Tools.codestring(gradenote);
- gradenote=gradenote.trim();
- if(debug){
- out.print("<br>subname="+name);
- out.print("<br>gradenode="+gradenote);
- }
- if(name.equals("") ){
- Tools.showalert("请您输入知识点名称",out);
- Tools.goback(out);
- }else{
- try{
- Connection con=DBCon.getConnection();
- String sql="select * from knowpoint where name='"+name+"' and gradenote='"+gradenote+
- "' and subid="+subject;
- PreparedStatement pstmt=con.prepareStatement(sql);
- ResultSet rs=pstmt.executeQuery();
- if (rs.next()){
- rs.close();
- pstmt.close();
- Tools.showalert("该知识点信息在数据库中已经存在!",out);
- Tools.goback(out);
- }else{
- rs.close();
- pstmt.close();
- sql="insert into knowpoint(name,gradenote,subid) values('"+name+"','"+gradenote+"'"+","+subject+")";
- //Tools.showalert(sql,out);
- pstmt=con.prepareStatement(sql);
- pstmt.executeUpdate();
- if(debug){
- out.print("<BR>insert="+sql);
- }
- Tools.showalert("成功添加知识点信息!",out);
- response.sendRedirect("admin_knowpoint.jsp");
- //Tools.showJS("window.open('admin_subject.jsp','_self')",out);
- }
- }catch(SQLException se){
- out.println(se.toString());
- }catch(Exception e){
- out.print(e.toString());
- }finally{
- DBCon.dropConnection();
- }
- }
- %>