<%@ page language="java" contentType="text/html; charset=GBK"
pageEncoding="GBK"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>Insert title here</title>
<style type="text/css">
</style>
</head>
<body ><table border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#D5EDB3">
<td colspan="3" rowspan="2"><img src="mm_health_photo.jpg" alt="Header image" width="382" height="101" border="0" /></td>
<td height="50" colspan="3" align="center" valign="bottom" nowrap="nowrap" class="STYLE24" id="logo">LG(乐金)</td>
<td width="273"> </td>
</tr> <tr bgcolor="#D5EDB3">
<td height="51" colspan="3" id="tagline" valign="middle" align="center"><span class="STYLE6">电子秦皇岛有限公司</span></td>
<td width="273"> </td>
</tr> <tr>
<td colspan="7" bgcolor="#5C743D"><img src="mm_spacer.gif" alt="" width="1" height="2" border="0" /></td>
</tr> <tr>
<td colspan="7" bgcolor="#99CC66" background="mm_dashed_line.gif"><img src="mm_dashed_line.gif" alt="line decor" width="4" height="3" border="0" /></td>
</tr> <tr bgcolor="#99CC66">
<td colspan="7" id="dateformat" height="20"><!-- #BeginDate format:fCh2m -->2009年12月18日 星期五 13:43<!-- #EndDate --></td>
</tr>
<tr>
<td class="navText" align="center" nowrap="nowrap"><a href="javascript:;">帮助信息</a></td>
<td class="navText" align="center" nowrap="nowrap"><a href="javascript:;">当日数据</a></td>
<td class="navText" align="center" nowrap="nowrap"><a href="javascript:;">历史数据</a></td>
<td class="navText" align="center" nowrap="nowrap"><a href="Untitled-1.html">退出</a></td>
<td colspan="7" bgcolor="#99CC66" background="mm_dashed_line.gif"><img src="mm_dashed_line.gif" alt="line decor" width="4" height="3" border="0" /></td>
</tr> <tr>
<td colspan="7" bgcolor="#5C743D"><img src="mm_spacer.gif" alt="" width="1" height="2" border="0" /></td>
</tr> <tr>
<td width="164" valign="top" bgcolor="#5C743D">
<table width="164" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFF00" id="navigation">
<tr>
<td width="160" bordercolor="#000000"> <br />
<br /></td>
</tr>
<tr>
<td width="160"><div align="center"><a href="javascript:;" class="navText">炉水温度</a></div></td>
</tr>
<tr>
<td width="160"><div align="center"><a href="javascript:;" class="navText">温枪温度</a></div></td>
</tr>
<tr>
<td width="160"><div align="center"><a href="javascript:;" class="navText">生产线</a></div></td>
</tr>
<tr>
<td width="160"><div align="center"><a href="javascript:;" class="navText">计件监控</a></div></td>
</tr>
<tr>
<td width="160"><div align="center"><a href="javascript:;" class="navText">生产计划</a></div></td>
</tr>
</table>
<br />
<br />
<br />
<br /> </td>
<td colspan="6"><table width="846" border="2" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<th width="101" rowspan="2" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE22" scope="col">日期时间</th>
<th height="25" colspan="10" align="center" valign="middle" bordercolor="#000000" class="STYLE23 STYLE26" scope="col">铁炉</th>
</tr>
<tr>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">1号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">2号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">3号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">4号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">5号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">6号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">7号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">8号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">9号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">10号</td>
</tr>
<p>
<%
Connection con = null;
Statement sm = null;
ResultSet rs = null;
try
{
InitialContext ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/mysql");
con=ds.getConnection();
sm=con.createStatement();
}
catch(Exception e)
{
e.printStackTrace();
}
String s_time = request.getParameter("time");
String s_one = request.getParameter("one");
String s_two = request.getParameter("two");
String s_three = request.getParameter("three");
String s_four = request.getParameter("four");
String s_five = request.getParameter("five");
String s_six = request.getParameter("six");
String s_seven = request.getParameter("seven");
String s_eight = request.getParameter("eight");
String s_nine = request.getParameter("nine");
String s_ten = request.getParameter("ten");
%>
</p>
<tr>
<td><%=s_time%></td>
<td><%=s_one%></td>
<td><%=s_two%></td>
<td><%=s_three%></td>
<td><%=s_four%></td>
<td><%=s_five%></td>
<td><%=s_six%></td>
<td><%=s_seven%></td>
<td><%=s_eight%></td>
<td><%=s_nine%></td>
<td><%=s_ten%></td>
</tr>
<tr>
<th width="101" height="25" align="center" valign="middle" bordercolor="#000000" class="STYLE20" scope="row"> </th>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
</tr>
<tr>
<th width="101" height="25" align="center" valign="middle" bordercolor="#000000" class="STYLE20" scope="row"> </th>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="164"> </td>
<td width="116"> </td>
<td width="102"> </td>
<td width="103"> </td>
<td width="253"> </td>
<td width="7"> </td>
<td width="273"> </td>
</tr>
</table>
<% rs.close();
sm.close();
con.close();
%></body>
</html>
pageEncoding="GBK"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>Insert title here</title>
<style type="text/css">
</style>
</head>
<body ><table border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#D5EDB3">
<td colspan="3" rowspan="2"><img src="mm_health_photo.jpg" alt="Header image" width="382" height="101" border="0" /></td>
<td height="50" colspan="3" align="center" valign="bottom" nowrap="nowrap" class="STYLE24" id="logo">LG(乐金)</td>
<td width="273"> </td>
</tr> <tr bgcolor="#D5EDB3">
<td height="51" colspan="3" id="tagline" valign="middle" align="center"><span class="STYLE6">电子秦皇岛有限公司</span></td>
<td width="273"> </td>
</tr> <tr>
<td colspan="7" bgcolor="#5C743D"><img src="mm_spacer.gif" alt="" width="1" height="2" border="0" /></td>
</tr> <tr>
<td colspan="7" bgcolor="#99CC66" background="mm_dashed_line.gif"><img src="mm_dashed_line.gif" alt="line decor" width="4" height="3" border="0" /></td>
</tr> <tr bgcolor="#99CC66">
<td colspan="7" id="dateformat" height="20"><!-- #BeginDate format:fCh2m -->2009年12月18日 星期五 13:43<!-- #EndDate --></td>
</tr>
<tr>
<td class="navText" align="center" nowrap="nowrap"><a href="javascript:;">帮助信息</a></td>
<td class="navText" align="center" nowrap="nowrap"><a href="javascript:;">当日数据</a></td>
<td class="navText" align="center" nowrap="nowrap"><a href="javascript:;">历史数据</a></td>
<td class="navText" align="center" nowrap="nowrap"><a href="Untitled-1.html">退出</a></td>
<td colspan="7" bgcolor="#99CC66" background="mm_dashed_line.gif"><img src="mm_dashed_line.gif" alt="line decor" width="4" height="3" border="0" /></td>
</tr> <tr>
<td colspan="7" bgcolor="#5C743D"><img src="mm_spacer.gif" alt="" width="1" height="2" border="0" /></td>
</tr> <tr>
<td width="164" valign="top" bgcolor="#5C743D">
<table width="164" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFF00" id="navigation">
<tr>
<td width="160" bordercolor="#000000"> <br />
<br /></td>
</tr>
<tr>
<td width="160"><div align="center"><a href="javascript:;" class="navText">炉水温度</a></div></td>
</tr>
<tr>
<td width="160"><div align="center"><a href="javascript:;" class="navText">温枪温度</a></div></td>
</tr>
<tr>
<td width="160"><div align="center"><a href="javascript:;" class="navText">生产线</a></div></td>
</tr>
<tr>
<td width="160"><div align="center"><a href="javascript:;" class="navText">计件监控</a></div></td>
</tr>
<tr>
<td width="160"><div align="center"><a href="javascript:;" class="navText">生产计划</a></div></td>
</tr>
</table>
<br />
<br />
<br />
<br /> </td>
<td colspan="6"><table width="846" border="2" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<th width="101" rowspan="2" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE22" scope="col">日期时间</th>
<th height="25" colspan="10" align="center" valign="middle" bordercolor="#000000" class="STYLE23 STYLE26" scope="col">铁炉</th>
</tr>
<tr>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">1号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">2号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">3号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">4号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">5号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">6号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">7号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">8号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">9号</td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25">10号</td>
</tr>
<p>
<%
Connection con = null;
Statement sm = null;
ResultSet rs = null;
try
{
InitialContext ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/mysql");
con=ds.getConnection();
sm=con.createStatement();
}
catch(Exception e)
{
e.printStackTrace();
}
String s_time = request.getParameter("time");
String s_one = request.getParameter("one");
String s_two = request.getParameter("two");
String s_three = request.getParameter("three");
String s_four = request.getParameter("four");
String s_five = request.getParameter("five");
String s_six = request.getParameter("six");
String s_seven = request.getParameter("seven");
String s_eight = request.getParameter("eight");
String s_nine = request.getParameter("nine");
String s_ten = request.getParameter("ten");
%>
</p>
<tr>
<td><%=s_time%></td>
<td><%=s_one%></td>
<td><%=s_two%></td>
<td><%=s_three%></td>
<td><%=s_four%></td>
<td><%=s_five%></td>
<td><%=s_six%></td>
<td><%=s_seven%></td>
<td><%=s_eight%></td>
<td><%=s_nine%></td>
<td><%=s_ten%></td>
</tr>
<tr>
<th width="101" height="25" align="center" valign="middle" bordercolor="#000000" class="STYLE20" scope="row"> </th>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
</tr>
<tr>
<th width="101" height="25" align="center" valign="middle" bordercolor="#000000" class="STYLE20" scope="row"> </th>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
<td width="82" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE20 STYLE21"> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="164"> </td>
<td width="116"> </td>
<td width="102"> </td>
<td width="103"> </td>
<td width="253"> </td>
<td width="7"> </td>
<td width="273"> </td>
</tr>
</table>
<% rs.close();
sm.close();
con.close();
%></body>
</html>
这是,忘了写了
Statement sm = null;
ResultSet rs = null;
try
{
InitialContext ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/mysql");
con=ds.getConnection();
sm=con.createStatement();
} 这里应该有SQL语句吧。ResultSet也没用上。
String s_time = request.getParameter("time");
String s_one = request.getParameter("one");
String s_two = request.getParameter("two");
String s_three = request.getParameter("three");
String s_four = request.getParameter("four");
String s_five = request.getParameter("five");
String s_six = request.getParameter("six");
String s_seven = request.getParameter("seven");
String s_eight = request.getParameter("eight");
String s_nine = request.getParameter("nine");
String s_ten = request.getParameter("ten");
strSql = "select * from wendu where (time,one,two,three,four,five,six,seven,eight,nine,ten) likes ('"+ s_time +"','"+s_one+"','"+s_two+"','"+s_three+"','"+s_four+"','"+s_five+"','"+s_six+"','"+s_seven+"','"+s_eight+"','"+s_nine+"','"+s_ten+"')";
rs = sm.executeQuery(strSql);
%>
String s_one = request.getParameter("one");
String s_two = request.getParameter("two");
String s_three = request.getParameter("three");
String s_four = request.getParameter("four");
String s_five = request.getParameter("five");
String s_six = request.getParameter("six");
String s_seven = request.getParameter("seven");
String s_eight = request.getParameter("eight");
String s_nine = request.getParameter("nine");
String s_ten = request.getParameter("ten");
strSql = "select * from wendu where (time,one,two,three,four,five,six,seven,eight,nine,ten) likes ('"+ s_time +"','"+s_one+"','"+s_two+"','"+s_three+"','"+s_four+"','"+s_five+"','"+s_six+"','"+s_seven+"','"+s_eight+"','"+s_nine+"','"+s_ten+"')";
rs = sm.executeQuery(strSql);
%>
where语句完全就错了,likes???。
select * from wendu where time like ** and one like **............
加在===========位置上sm=con.createStatement();
==============}用rs.getString("");来取值
看是否有结果
学习LZ的高级SQL语句...我第一次看见这样写SELECT语句的...长见识了..
另外: like 都不用"%"的么??
然后执行查询语句的时候this.getEntityManager().queryForListByHql(hql);
不知道仁兄是不是要这种
String s_time = request.getParameter("time");
Sql = "select * from wendu where time like '%"+s_time+"%' and one like'%"+s_one+"%' and two like '%+s_two+%'...."