| 发表于：2007-06-15 18:33:29 楼主 |
请问这代码问题在哪????
我要更新第一个表的信息,然后第一个表的id字段跟第2个表的id字段进行关联,
然后读出第2个表的信息,
<%
resultset rs;
string id=request.getparameter（ "id ");
string accout=request.getparameter（ "accout ");
string phone=request.getparameter（ "phone ");
string esn=request.getparameter（ "esn ");
string imsi=request.getparameter（ "imsi ");
string sid=request.getparameter（ "sid ");
string nid=request.getparameter（ "nid ");
%>
<%@ include file= "conn.jsp " %> //数据库连接文件
<%
string sql= "update base_info set accout= ' "+accout+ " ',phone= ' "+phone+ " ',esn= ' "+esn+ " ',imsi= ' "+imsi+ " ',sid= ' "+sid+ " ',nid= ' "+nid+ " ' where id= ' "+id+ " ' ";
statement.ＥＸＥＣuteupdate（sql);
sql= "select * from service_info,base_info where service_info.id=base_info.id ";
rs=statement.ＥＸＥＣutequery（sql);
string lst_fa=rs.getstring（ "lst_fa ");
string lst_dj=rs.getstring（ "lst_dj ");
string lst_data=rs.getstring（ "lst_data ");
string lst_gj=rs.getstring（ "lst_gj ");
string lst_hj=rs.getstring（ "lst_hj ");
string lst_yy=rs.getstring（ "lst_yy ");
rs.close（);
statement.close（) ;
connection.close（) ;
%> |
|
|
|
|
