<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> 订单查找 <% //连接数据库 String driverClass = "com.mysql.cj.jdbc.Driver"; String url="jdbc:mysql://localhost/sd?serverTimezone=GMT%2B8"; String url1="jdbc:mysql://localhost/gglass?serverTimezone=GMT%2B8"; /* String url="jdbc:mysql://172.17.2.7/sd?serverTimezone=GMT%2B8"; String url1="jdbc:mysql://172.17.2.7/gglass?serverTimezone=GMT%2B8"; */ String user = "root"; String password = "beibo.123/"; %> <% String anquanma=request.getParameter("anquanma"); String yuyan=request.getParameter("yuyan"); /* Class.forName(driverClass);{ Connection con=DriverManager.getConnection( url1,"root","beibo.123/"); //通过connection数据库链接对象 创建一个statement对象数据库操作对象 Statement stmts=con.createStatement(); //执行sql语句 String anquan="select * from anquanbiao where anquanma = '"+anquanma+"' "; ResultSet rss = stmts.executeQuery(anquan); int coun=0; while(rss.next()) { coun++; } if(coun==0){ out.print(""); } con.close(); } */ %> <% String[] group1=new String[200]; String ym=request.getRequestURI(); String []a=ym.split("/"); String yemian=a[a.length-1]; if(yuyan==null) { yuyan="cn"; } //查询语言 Class.forName(driverClass);{ Connection con1=DriverManager.getConnection( url1,"root",password); CallableStatement cs = con1.prepareCall("{call yuyan(?,?)}"); cs.setString(1, "dingdanchaxun.jsp"); cs.setString(2, yuyan); ResultSet rs = cs.executeQuery(); int i=0; while(rs.next()) { group1[i]=rs.getString(1); i++; } con1.close(); } %> <% String kaishi =request.getParameter("kaishi"); String jieshu =request.getParameter("jieshu"); String xsdh =request.getParameter("xsdh"); %>
销售单号: <% out.println(group1[0]); %> <% out.println(group1[1]); %>
<% //装载一个类并且对其进行实例化的操作 Class.forName(driverClass);{ Connection con=DriverManager.getConnection( url,"root",password); //调用存储过程 CallableStatement cs = con.prepareCall("{call dingdanzhu_chaxun(?,?,?)}"); //判断订单日期是否为null if(kaishi==null){ cs.setString(1, ""); cs.setString(2, ""); }else{ cs.setString(1, kaishi); cs.setString(2, jieshu); } if(xsdh==null) { cs.setString(3, ""); } else { cs.setString(3, xsdh); } ResultSet rs = cs.executeQuery(); //循环打印数据 int i=1; while(rs.next()) { if(i%2!=0){ out.println(""); } else { out.println(""); } out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); if(i%2!=0){ out.println(""); } else { out.println(""); } /* */ out.println(""); out.println(""); /* out.println(""); */ out.println(""); /* out.println(""); */ if(i%2!=0){ out.println(""); } else { out.println(""); } out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); i++; } con.close(); } %>
<% out.println(group1[3]); %> <% out.println(group1[4]); %> <% out.println(group1[5]); %> <% out.println(group1[6]); %> <% out.println(group1[7]); %> <% out.println(group1[8]); %> <% out.println(group1[9]); %> <% out.println(group1[10]); %> <% out.println(group1[11]); %> <% out.println(group1[12]); %> <% out.println(group1[13]); %> <% out.println(group1[14]); %> <% out.println(group1[17]); %> <% out.println(group1[18]); %> 项目名称 <% out.println(group1[21]); %> <% out.println(group1[22]); %> <% out.println(group1[23]); %> 数量 <% out.println(group1[24]); %> <% out.println(group1[25]); %> <% out.println(group1[26]); %> <% out.println(group1[27]); %> <% out.println(group1[28]); %> <% out.println(group1[29]); %> 周长
"+i+""+rs.getString(1)+""+rs.getString(5)+""+rs.getString(5)+""+rs.getString(24)+""+rs.getString(13)+"