注册

<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> 注册 <%@include file="../mysqlconnect.jsp"%> <% String yuyan1="cn"; String yuyan2=request.getParameter("yuyan"); if(yuyan2==""||yuyan2==null){ }else{ yuyan1=yuyan2; } String yemian="Login.jsp"; String[] group=new String[6]; //装载一个类并且对其进行实例化的操作 Class.forName(driverClass);{ Connection con1=DriverManager.getConnection( urlglass,user,password); CallableStatement cs = con1.prepareCall("{call yuyan(?,?)}"); cs.setString(1, yemian); cs.setString(2, yuyan1); ResultSet rs = cs.executeQuery(); int i=0; while(rs.next()) { group[i]=rs.getString(1); i++; } } %>

${error}

姓名

部门: 班组:

<%--

班组:

--%>

用户名:

密码:

<% String banzu=""; if(request.getParameter("submit")!=null){ String uname=request.getParameter("userName"); uname= new String(uname.getBytes("ISO-8859-1"), "utf-8"); String pwd=request.getParameter("pwd"); pwd= new String(pwd.getBytes("ISO-8859-1"), "utf-8"); String xingming=request.getParameter("xingming"); xingming= new String(xingming.getBytes("ISO-8859-1"), "utf-8"); String bumen=request.getParameter("bumen"); bumen= new String(bumen.getBytes("ISO-8859-1"), "utf-8"); String bumenbianhao=request.getParameter("bumenbianhao"); /* } */ banzu=request.getParameter("banzumingcheng"); banzu= new String(banzu.getBytes("ISO-8859-1"), "utf-8"); String banzugonghao=request.getParameter("banzugonghao"); banzugonghao= new String(banzugonghao.getBytes("ISO-8859-1"), "utf-8"); int fanhui=0; //装载一个类并且对其进行实例化的操作 Class.forName(driverClass);{ if(uname!=null&&pwd!=null){ Connection con=DriverManager.getConnection( urlglass,user,password); CallableStatement cs = con.prepareCall("{call zhuce(?,?,?,?,?,?,?,?,?)}"); cs.setString(1, uname); cs.setString(2, pwd); cs.setString(3, xingming); cs.setString(4, bumenbianhao); cs.setString(5, bumen); cs.setString(6, banzu); cs.setString(7, request.getRemoteAddr()); cs.setString(8, banzugonghao); cs.registerOutParameter( 9 , java.sql.Types.INTEGER); cs.execute(); fanhui=cs.getInt(9); if(fanhui==5000){ out.print(""); }else{ out.print(""); }con.close(); } } } %>