有一个成品单 (table1)
一个零件单 (table2)都要放在index.jsp页
从成品单里面去查单号(indexinsert.jsp)查出来,再用动态连接把id传过来的在用id去查这条记录填到第一个表
<td valign="middle"> <a href="index.jsp?id= <%=rs.getInt("gldid")%>">确定 </a> </td>
从零件单里去查零件(多个零件组成一个成品 querylist.jsp) 假如说4个零件组成一个成品.我要从数据一个个的查上来传到index.jsp
还有我查第二个零件怎么防止第一个零件不被刷新呢?同理查第三个呢?
当我把零件记录传过去的时候成品表的记录也不要被刷新
之后做一笔记录存到数据库..不知看明白了没
应该怎么做.真没思路了应该怎么用ajax还是iframe来实现可这2个我从没用过最好给写下小弟先谢过了..急用第一个是从用动态连接把id传过来的在用id去查这条记录填到第一个表
<td valign="middle"><a href="index.jsp?id=<%=rs.getInt("gldid")%>">确定 </a></td>
<html>
<head>
<script>
function cleak(){
document.getElementById("pm").innerHTML="";
document.getElementById("gg").innerHTML="";
document.getElementById("number2").innerHTML="";
document.getElementById("number3").innerHTML="";
document.getElementById("number4").innerHTML="";
document.getElementById("number5").innerHTML="";
document.getElementById("number6").innerHTML="";
document.getElementById("cl").innerHTML="";
}
</script> <script language="javascript" type="text/javascript"src="MyDatePicker/WdatePicker.js"></script>
<base href="<%=basePath%>">
<title>index</title>
<style type="text/css">
<!--
.style4 {font-size: 14pt}-->
</style>
</head>
<body>
<br><hr color="rede">
成品单:<a href="indexinsert.jsp">查询:</a>
<form action=""name="form" method="post">
<table width="978" border="1" align="center">
<tr>
<td width="10%" height="17" valign="middle">工令單號</td>
<td width="20%" valign="middle">代號</td>
<td width="20%" valign="middle">料号</td>
<td width="30%" valign="middle">品名</td>
<td width="10%" valign="middle">數量</td>
<td width="10%" valign="middle">日期</td>
</tr>
<%
//jdbc连接数据库
Connection con =null;
Statement str = null;
ResultSet rs=null;
String id = request.getParameter("id");
try{
String url="jdbc:odbc:project";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,"","");
String sql = "select * from gld where gldid = '"+ id + "'";
str=con.createStatement();
rs=str.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td width="10%" height="17" valign="middle"><input name="number" type="text"size="15"></td>
<td width="20%" valign="middle"><%=rs.getString("ggdh")%></td>
<td width="20%" valign="middle"><%=rs.getString("lh")%></td>
<td width="30%" valign="middle"><%=rs.getString("pm")%></td>
<td width="10%" valign="middle"><input name="number1" type="text"size="15"></td>
<td width="10%" valign="middle"><input name="date" type="text"size="15" onClick="WdatePicker()"/>
</tr>
<%
}
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e1){
e1.printStackTrace();
}finally{
try{
if(rs!=null){
rs.close();
rs=null;
}
if(str!=null){
str.close();
str=null;
}
if(con!=null){
con.close();
con=null;
}
}catch(Exception e){
e.printStackTrace();
}
}
%> </table>
<p>零件单号:<a href="insert.jsp"> 新增记录:</a></p>
<br>
<table width="978" border="1" align="center">
<tr>
<td width = "20%">品名</td>
<td width = "12%">規格</td>
<td width = "8%">數量</td>
<td width = "16%">材損</td>
<td width = "20%" colspan="2"align = "center" valign = "middle">制損</td>
<td width = "12%">原因判定</td>
<td width = "8%">刪除</td>
</tr>
<%
String id2 = request.getParameter("id2");
//System.out.println(id2);
try{
String url="jdbc:odbc:project2";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,"","");
String sql = "select * from projecttb2 where lshh = '"+ id2 + "'";
str=con.createStatement();
rs=str.executeQuery(sql);
while(rs.next()){
%>
<tr id='mytr'>
<td width="16%" id = "pm"><%=rs.getString("pm")%></td>
<td width="15%" id = "gg"><%=rs.getString("gg")%></td>
<td width="5%" id = "number2"><input name = "number2" type = "text"size = "8"></td>
<td width="10%" id = "number3"><input name = "number3" type = "text"size = "15"></td>
<td width="10%" id = "number4"><input name = "number4" type = "text"size = "10"></td>
<td width="10%" id = "number5"><input name = "number5" type = "text"size = "10"></td>
<td width="10%" id = "number6"><input name = "number6" type = "text"size = "20"></td>
<td width="8%" id = "cl" ondblclick="cleak()">刪除</td>
</tr>
<%
}
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e1){
e1.printStackTrace();
}finally{
try{
if(rs!=null){
rs.close();
rs=null;
}
if(str!=null){
str.close();
str=null;
}
if(con!=null){
con.close();
con=null;
}
}catch(Exception e){
e.printStackTrace();
}
}
%>
</table>
<br>
<table width="978" border="0">
<tr>
<td align="right" valign="middle"><input name="submit" type="submit" class="style4" value="Save"></td>
</tr>
</table>
</form>
<p>
<hr color="rede">
</body>
</html>
一个零件单 (table2)都要放在index.jsp页
从成品单里面去查单号(indexinsert.jsp)查出来,再用动态连接把id传过来的在用id去查这条记录填到第一个表
<td valign="middle"> <a href="index.jsp?id= <%=rs.getInt("gldid")%>">确定 </a> </td>
从零件单里去查零件(多个零件组成一个成品 querylist.jsp) 假如说4个零件组成一个成品.我要从数据一个个的查上来传到index.jsp
还有我查第二个零件怎么防止第一个零件不被刷新呢?同理查第三个呢?
当我把零件记录传过去的时候成品表的记录也不要被刷新
之后做一笔记录存到数据库..不知看明白了没
应该怎么做.真没思路了应该怎么用ajax还是iframe来实现可这2个我从没用过最好给写下小弟先谢过了..急用第一个是从用动态连接把id传过来的在用id去查这条记录填到第一个表
<td valign="middle"><a href="index.jsp?id=<%=rs.getInt("gldid")%>">确定 </a></td>
<html>
<head>
<script>
function cleak(){
document.getElementById("pm").innerHTML="";
document.getElementById("gg").innerHTML="";
document.getElementById("number2").innerHTML="";
document.getElementById("number3").innerHTML="";
document.getElementById("number4").innerHTML="";
document.getElementById("number5").innerHTML="";
document.getElementById("number6").innerHTML="";
document.getElementById("cl").innerHTML="";
}
</script> <script language="javascript" type="text/javascript"src="MyDatePicker/WdatePicker.js"></script>
<base href="<%=basePath%>">
<title>index</title>
<style type="text/css">
<!--
.style4 {font-size: 14pt}-->
</style>
</head>
<body>
<br><hr color="rede">
成品单:<a href="indexinsert.jsp">查询:</a>
<form action=""name="form" method="post">
<table width="978" border="1" align="center">
<tr>
<td width="10%" height="17" valign="middle">工令單號</td>
<td width="20%" valign="middle">代號</td>
<td width="20%" valign="middle">料号</td>
<td width="30%" valign="middle">品名</td>
<td width="10%" valign="middle">數量</td>
<td width="10%" valign="middle">日期</td>
</tr>
<%
//jdbc连接数据库
Connection con =null;
Statement str = null;
ResultSet rs=null;
String id = request.getParameter("id");
try{
String url="jdbc:odbc:project";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,"","");
String sql = "select * from gld where gldid = '"+ id + "'";
str=con.createStatement();
rs=str.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td width="10%" height="17" valign="middle"><input name="number" type="text"size="15"></td>
<td width="20%" valign="middle"><%=rs.getString("ggdh")%></td>
<td width="20%" valign="middle"><%=rs.getString("lh")%></td>
<td width="30%" valign="middle"><%=rs.getString("pm")%></td>
<td width="10%" valign="middle"><input name="number1" type="text"size="15"></td>
<td width="10%" valign="middle"><input name="date" type="text"size="15" onClick="WdatePicker()"/>
</tr>
<%
}
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e1){
e1.printStackTrace();
}finally{
try{
if(rs!=null){
rs.close();
rs=null;
}
if(str!=null){
str.close();
str=null;
}
if(con!=null){
con.close();
con=null;
}
}catch(Exception e){
e.printStackTrace();
}
}
%> </table>
<p>零件单号:<a href="insert.jsp"> 新增记录:</a></p>
<br>
<table width="978" border="1" align="center">
<tr>
<td width = "20%">品名</td>
<td width = "12%">規格</td>
<td width = "8%">數量</td>
<td width = "16%">材損</td>
<td width = "20%" colspan="2"align = "center" valign = "middle">制損</td>
<td width = "12%">原因判定</td>
<td width = "8%">刪除</td>
</tr>
<%
String id2 = request.getParameter("id2");
//System.out.println(id2);
try{
String url="jdbc:odbc:project2";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,"","");
String sql = "select * from projecttb2 where lshh = '"+ id2 + "'";
str=con.createStatement();
rs=str.executeQuery(sql);
while(rs.next()){
%>
<tr id='mytr'>
<td width="16%" id = "pm"><%=rs.getString("pm")%></td>
<td width="15%" id = "gg"><%=rs.getString("gg")%></td>
<td width="5%" id = "number2"><input name = "number2" type = "text"size = "8"></td>
<td width="10%" id = "number3"><input name = "number3" type = "text"size = "15"></td>
<td width="10%" id = "number4"><input name = "number4" type = "text"size = "10"></td>
<td width="10%" id = "number5"><input name = "number5" type = "text"size = "10"></td>
<td width="10%" id = "number6"><input name = "number6" type = "text"size = "20"></td>
<td width="8%" id = "cl" ondblclick="cleak()">刪除</td>
</tr>
<%
}
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e1){
e1.printStackTrace();
}finally{
try{
if(rs!=null){
rs.close();
rs=null;
}
if(str!=null){
str.close();
str=null;
}
if(con!=null){
con.close();
con=null;
}
}catch(Exception e){
e.printStackTrace();
}
}
%>
</table>
<br>
<table width="978" border="0">
<tr>
<td align="right" valign="middle"><input name="submit" type="submit" class="style4" value="Save"></td>
</tr>
</table>
</form>
<p>
<hr color="rede">
</body>
</html>
aJax一点不通
也可以看这里