<%@include file="mysqlconnect.jsp"%> <% String xingming=request.getParameter("xingming"); String bumen=request.getParameter("bumen"); String dengji=request.getParameter("dengji"); String anquanma=request.getParameter("anquanma"); String cn=request.getParameter("yuyan"); //装载一个类并且对其进行实例化的操作 Class.forName(driverClass);{ Connection con=DriverManager.getConnection( urlglass,user,password); //通过connection数据库链接对象 创建一个statement对象数据库操作对象 Statement stmts=con.createStatement(); //执行sql语句 String anquan="select * from anquanbiao where anquanma = '"+anquanma+"' and cip='"+request.getLocalAddr()+"' and now()<=xiugaitime and now()>=jianlitime; "; ResultSet rss = stmts.executeQuery(anquan); int coun=0; while(rss.next()) { coun++; } if(coun!=0){ if("cn".equals(cn)){ out.println(""); out.println("     欢迎   "+xingming+"  使用北玻MES系统！距离自动离开本系统还有"+dengji+"分钟"); } else if("en".equals(cn)){ out.println("    welcome   "+xingming+"  Use the MES system of North China Glass！Distance from automatic leave the system and"+dengji+"minute"); } } else{ if("cn".equals(cn)){ out.print(""); }else if("en".equals(cn)){ out.print(""); } } } %> <% String yuyan1=request.getParameter("yuyan"); String yemian="shuoming.jsp"; String[] group=new String[6]; /* //连接数据库 String driverClass1 = "com.mysql.cj.jdbc.Driver"; String url1="jdbc:mysql://localhost/gglass?serverTimezone=GMT%2B8"; String user1 = "root"; String password1 = "root"; */ //装载一个类并且对其进行实例化的操作 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++; } } %>