addcollegefile.jsp

一个挺好的招生管理系统

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="DataBaseConnection.OracleConnection" %>
<form name="form1" method="post" action="">
<P><font color=blue size=+3>添加院校</font></p>
  <p>院校编号: 
    <input name="textfield" type="text" size="10">
  </p>
  <p>院校名称: 
    <input name="textfield2" type="text" size="10">
  </p>
  <p>密码: 
    <input name="textfield3" type="text" size="10">
  </p>
  <p>录取分数线: 
    <input name="textfield4" type="text" size="8">
  </p>
  <p>招生人数: 
    <input type="text" name="textfield5">
  </p>
  <input type="submit" value="提交">
  </form>
<%  String message="";int m=0;
   String BH=request.getParameter("textfield");
   String mc=(request.getParameter("textfield2"));
   String mm=request.getParameter("textfield3");
   String LQFSX=request.getParameter("textfield4");
   String ZSRS=request.getParameter("textfield5");
   if(BH==null||mc==null||mm==null||LQFSX==null||ZSRS==null){message="请输入信息！并且所有信息必须填好！";}
   else{                
	    byte bmc[]=(mc.trim()).getBytes("ISO-8859-1");
        String MC=new String(bmc);
        byte bmm[]=(mm.trim()).getBytes("ISO-8859-1");
        String MM=new String(bmm);
	   Connection conn = null;
						Statement stmt = null;
						String user = "sox";
						String password = "123";
						OracleConnection oc = new OracleConnection( user, password );
						try{
							conn = oc.getConnection();
							stmt = conn.createStatement();
						}
						catch( SQLException e ){ System.out.println( e.getMessage()+"374" ); }
						
						//判断存不存在该编号的考生
						try{String sql = "insert into college (院校编号,院校名称,密码,录取分数线,招生人数)values('"+BH+"','"+MC+"','"+MM+"','"+LQFSX+"','"+ZSRS+"')";
                         m = stmt.executeUpdate( sql );}
						 catch(SQLException e ){message="操作失败！原因:"+e.getMessage();}
						 if(m>0) {message="操作成功！插入一条院校信息！";}
		 }
%><BR><%=message%><%
%>