<%@page import="ng.db.DBHelper"%> <%@page import="javax.swing.text.html.HTML"%> <%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <% request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html; charset=utf-8"); %> 北玻登录 <%@include file="mysqlconnect.jsp"%> <% String yuyan1="cn"; String yuyan2=request.getParameter("yuyan"); if(yuyan2==""||yuyan2==null){ }else{ yuyan1=yuyan2; } String yemian="index.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++; } } %>

<%-- <% out.println(group[2]); %> --%>

<%-- <% out.println(group[3]); %> --%>

北玻自动化MES管理系统 <%-- <% out.println(group[4]); %> --%>

<%-- <% out.println(group[0]); %> --%>

<%-- <% out.println(group[1]); %> --%>

<% String uname=request.getParameter("userName"); String pwd=request.getParameter("pwd"); String yuyan=request.getParameter("yuyan"); String ym="Login.jsp"; String tip=request.getLocalAddr() ; int fanhui=0; int fanhui1=0; String xingming=""; String aid=""; String anquanma=""; String dengji=""; String bumen=""; //装载一个类并且对其进行实例化的操作 Class.forName(driverClass);{ if(uname!=null&&pwd!=null){ if(uname!=""&&pwd!=""){ Connection con=DriverManager.getConnection( urlglass,user,password); CallableStatement cs = con.prepareCall("{call denglu(?,?,?,?,?,?,?,?)}"); cs.setString(1, uname); cs.setString(2, pwd); cs.setString(3, ym); cs.setString(4, tip); cs.registerOutParameter( 5 , java.sql.Types.INTEGER); cs.registerOutParameter( 6 , java.sql.Types.INTEGER); cs.registerOutParameter( 7 , java.sql.Types.INTEGER); cs.registerOutParameter( 8 , java.sql.Types.INTEGER); cs.execute(); fanhui=cs.getInt(5); xingming=cs.getString(6); aid=cs.getString(7); bumen=cs.getString(8); if(fanhui==5000){ CallableStatement css = con.prepareCall("{call anquan(?,?,?,?,?,?)}"); css.setString(1, aid); css.setString(2, tip); css.setString(3, ym); css.registerOutParameter( 4 , java.sql.Types.INTEGER); css.registerOutParameter( 5 , java.sql.Types.INTEGER); css.registerOutParameter( 6 , java.sql.Types.INTEGER); css.execute(); fanhui1=css.getInt(4); anquanma=css.getString(5); dengji=css.getString(6); if(fanhui1==5000){ out.print(""); } else{ out.print(""); } } else{ out.print(""); } //关闭连接 con.close(); } else{ out.print(""); } } } %>