<%
String serial_no=request.getParameter("serial_no");
//String count=request.getParameter("count");
//int countno=Integer.parseInt(count);Connection conn=null;
Statement sql=null;
ResultSet rs1=null;
ResultSet rs2=null;
ResultSet rs3=null;
ResultSet rs4=null;try
{//加載數據庫驅動
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
out.print("数据库驱动加载失败");
}
//try
//{//數據庫鏈接
conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.132.25:1521:acsgit01","sitedbt","git9280#");
sql=conn.createStatement();
//定義查詢條件
//查询表rm_item_detail
String condition1="select serial_no,apply_no,line_no,rma_no,rma_center from rm_item_detail where serial_no="+serial_no;
rs1=sql.executeQuery(condition1);
//查询表rm_header
String condition2="select RMA_TYPE from rm_header where RMA_NO="+rs1.getString("rma_no");
rs2=sql.executeQuery(condition2);
//查询表rm_site_master
String condition3="select name from rm_site_master where rma_center="+rs1.getString("rma_center");
rs3=sql.executeQuery(condition3);
//查询表rm_item_extrainfo
String condition4="select KEYIN_DATE,CLOSED_DATE,(CLOSED_DATE-KEYIN_DATE) TAT from rm_item_extrainfo where line_no="+rs1.getString("line_no")+" and apply_no="+rs1.getString("apply_no");
rs4=sql.executeQuery(condition4);
out.print("<table border>");
out.print("<tr>");
out.print("<th width=50>"+"serial_no");
out.print("<th width=50>"+"RMA_no");
out.print("<th width=50>"+"RMA_TYPE");
out.print("<th width=50>"+"RMA_CENTER");
out.print("<th width=50>"+"KEYIN_DATE");
out.print("<th width=50>"+"CLOSED_DATE");
out.print("<th width=50>"+"TAT");
out.print("</tr>");
while(rs1.next())
{
out.print("<tr>");
out.print("<td width=50>"+rs1.getString(1)+"</td>");
out.print("<td width=50>"+rs1.getString(2)+"</td>");
out.print("<td width=50>"+rs2.getString(1)+"</td>");
out.print("<td width=50>"+rs3.getString(1)+"</td>");
out.print("<td width=50>"+rs4.getString(1)+"</td>");
out.print("<td width=50>"+rs4.getString(2)+"</td>");
out.print("<td width=50>"+rs4.getString(3)+"</td>");
out.print("</tr>");
}
out.print("</table>");
//int lowrow=rs.getRow();
//out.print(""+lowrow+"");
//out.print("Database Connection!");
//out.print(table);
//}
//catch(SQLException e)
//{
out.print("Database Disconnection");
//}
%>
String serial_no=request.getParameter("serial_no");
//String count=request.getParameter("count");
//int countno=Integer.parseInt(count);Connection conn=null;
Statement sql=null;
ResultSet rs1=null;
ResultSet rs2=null;
ResultSet rs3=null;
ResultSet rs4=null;try
{//加載數據庫驅動
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
out.print("数据库驱动加载失败");
}
//try
//{//數據庫鏈接
conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.132.25:1521:acsgit01","sitedbt","git9280#");
sql=conn.createStatement();
//定義查詢條件
//查询表rm_item_detail
String condition1="select serial_no,apply_no,line_no,rma_no,rma_center from rm_item_detail where serial_no="+serial_no;
rs1=sql.executeQuery(condition1);
//查询表rm_header
String condition2="select RMA_TYPE from rm_header where RMA_NO="+rs1.getString("rma_no");
rs2=sql.executeQuery(condition2);
//查询表rm_site_master
String condition3="select name from rm_site_master where rma_center="+rs1.getString("rma_center");
rs3=sql.executeQuery(condition3);
//查询表rm_item_extrainfo
String condition4="select KEYIN_DATE,CLOSED_DATE,(CLOSED_DATE-KEYIN_DATE) TAT from rm_item_extrainfo where line_no="+rs1.getString("line_no")+" and apply_no="+rs1.getString("apply_no");
rs4=sql.executeQuery(condition4);
out.print("<table border>");
out.print("<tr>");
out.print("<th width=50>"+"serial_no");
out.print("<th width=50>"+"RMA_no");
out.print("<th width=50>"+"RMA_TYPE");
out.print("<th width=50>"+"RMA_CENTER");
out.print("<th width=50>"+"KEYIN_DATE");
out.print("<th width=50>"+"CLOSED_DATE");
out.print("<th width=50>"+"TAT");
out.print("</tr>");
while(rs1.next())
{
out.print("<tr>");
out.print("<td width=50>"+rs1.getString(1)+"</td>");
out.print("<td width=50>"+rs1.getString(2)+"</td>");
out.print("<td width=50>"+rs2.getString(1)+"</td>");
out.print("<td width=50>"+rs3.getString(1)+"</td>");
out.print("<td width=50>"+rs4.getString(1)+"</td>");
out.print("<td width=50>"+rs4.getString(2)+"</td>");
out.print("<td width=50>"+rs4.getString(3)+"</td>");
out.print("</tr>");
}
out.print("</table>");
//int lowrow=rs.getRow();
//out.print(""+lowrow+"");
//out.print("Database Connection!");
//out.print(table);
//}
//catch(SQLException e)
//{
out.print("Database Disconnection");
//}
%>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货