📄 ecmlanque.java
字号:
recordFilter.start();
*/
isCnt="disconnect";
}///end if
}
//////////////diplay the html
System.out.println("i enter display queryed result");
out.println("<HTML>");
out.println("<HEAD><TITLE>Web-DB Demo</TITLE></HEAD>");
out.println("<BODY>");
out.println("<FORM METHOD=POST ACTION=\"/servlet/ecmLanQue\" target=_self>");
out.println("<HR><TABLE BORDER=\"1\" ALIGN=\"CENTER\" >");
/////display the result
/////////////
try{
rs=t.recordSql("select * from gtmp "+qtmp);
System.out.println("select * from gtmp "+qtmp);
recordsQuery=t.getRecords(rs);
qleng=recordsQuery[1].length;
System.out.println("qleng is:"+qleng);
rs.close();
}
catch (Exception ex){
ex.printStackTrace();
}
////////////
/*
int l=recordsLoc.length;
int ll=recordsLoc[1].length;
System.out.println("array lenth is :"+l);
System.out.println("record lenth is :"+ll);
*/
String inf="商品信息";
String[] lables=new String[qleng];
lables[0]="厂家";//{"商品名称"};{"商品型号"};{"价格"};{"数量"};{"入库时间"};{"来源地"} };
lables[1]="商品名称";
lables[2]="型号 ";
lables[3]="价格";
lables[4]="数量";
lables[5]="入库时间";
lables[6]="来源地";
out.println(new String(inf.getBytes("GBK"),"ISO8859_1") );
out.println("<BR>");
int k=0;
for (int j=0;j<qleng;j++){
//if (recordsQuery[k][1]!=null){
//out.println(new String(name.getBytes("GBK"),"ISO8859_1") );
//out.print("<TD>"+new String(rsmd.getColumnLabel(i).getBytes("GBK"),"ISO8859_1") );
out.print("<TD width=\"300\" > <b>"+new String (lables[j].getBytes("GBK"),"ISO8859_1")+"</b>" );
//out.print("<TD>"+recordsLoc[k][j]);
//out.print("<TD>"+new String (recordsLoc[k][j].getBytes("ISO8859_1"),"GBK") );
//}
//else break outLoop; ///if no record to display then go outLoop:
}
out.println("<TR>");///换行显示
outLoop:
for (k=disRecords;k<disRecords+8;k++){
out.println(" ");
//System.out.println("********2");
for (int j=0;j<qleng;j++){
if (recordsQuery[k+1][1]!=null){
//out.println(new String(name.getBytes("GBK"),"ISO8859_1") );
//out.print("<TD>"+new String(rsmd.getColumnLabel(i).getBytes("GBK"),"ISO8859_1") );
out.print("<TD width=\"300\" >"+new String (recordsQuery[k+1][j].getBytes("GBK"),"ISO8859_1") );
//out.print("<TD>"+recordsLoc[k][j]);
//out.print("<TD>"+new String (recordsLoc[k][j].getBytes("ISO8859_1"),"GBK") );
}
else break outLoop; ///if no record to display then go outLoop:
}
out.println("<TR>");///换行显示
}//end for
/*outLoop:
for (k=disRecords;k<disRecords+8;k++){
out.println(" ");
//System.out.println("********2");
for (int j=1;j<ll-1;j++){
if (recordsLoc[k][1]!=null){
//out.println(new String(name.getBytes("GBK"),"ISO8859_1") );
//out.print("<TD>"+new String(rsmd.getColumnLabel(i).getBytes("GBK"),"ISO8859_1") );
out.print("<TD>"+new String (recordsLoc[k][j].getBytes("GBK"),"ISO8859_1") );
//out.print("<TD>"+recordsLoc[k][j]);
//out.print("<TD>"+new String (recordsLoc[k][j].getBytes("ISO8859_1"),"GBK") );
}
else break outLoop; ///if no record to display then go outLoop:
}
out.println("<TR>");///换行显示
}//end for
System.out.println("@@@k is:"+k);
outLoop2:
for (int trow=1;trow-1<disRecords+8-k;trow++){
for (int j2=0;j2<qleng;j2++){
if (recordsQuery[trow][1]!=null){
out.print("<TD>"+new String (recordsQuery[trow][j2].getBytes("GBK"),"ISO8859_1") );
}
else break outLoop2; ///if no record to display then go outLoop:
}
out.println("<TR>");///换行显示
}//end for*/
//out.println("insert records are:"+InsertRecords(req,out,"comment") );
out.println("</TABLE><BR><HR>");
out.println("<INPUT TYPE=SUBMIT name=\"OpType\" value="+new String(pre.getBytes("GBK"),"ISO8859_1") + ">");
out.println("<INPUT TYPE=SUBMIT name=\"OpType\" value="+new String(next.getBytes("GBK"),"ISO8859_1") +">" );
out.println("</FORM>");
out.println("</BODY></HTML>");
t.closeResult();
}
////////
public void Destroy(){
t.closeConnect();
}
////
public int InsertRecords(HttpServletRequest req,ServletOutputStream out,String tableName)
throws ServletException,IOException{
int i=0,count=0; ///count used for insert amount
Enumeration keys;
String kkey,val,values="";
String[] ray=new String[20];
tableSql tt=new tableSql("mdbjdbc");
//out.println(Lab);
keys=req.getParameterNames();
System.out.println("enter get field values");
while (keys.hasMoreElements()) {
kkey=(String)keys.nextElement();
val=req.getParameter(kkey);
///获取插入域的值，并连接
if (kkey.startsWith("record")){
int ll=records[1].length;
int no=Integer.parseInt( kkey.substring(6) );
System.out.println("no is:"+no);
for (int k=1;k<ll-1;k++)
values=values+"\'"+records[no][k]+"\'"+",";
values=values.substring(0, (values.length()-1) );
out.println("values is:"+values);
}
}
/*
values="\'"+val+"\'"+",";
//out.println("ray["+(i)+"]"+values);
ray[i++]=values;
}
}
/////将数组ray反置连接后结果存入values中
values="";
for(int j=i-1;j>=0;j--){
values=values+ray[j];
}
values=values.substring(0, (values.length()-1) );*/
///执行插入操作
//count=t.recordInsert("insert into "+tableName+" ("+Lab+") values("+values+")");
System.out.println("insert into "+tableName+" (url,comment) values ("+values+")");
count=tt.recordInsert("insert into "+tableName+" (url,comment) values ("+values+")");
//out.println("insert into "+tableName+" ("+Lab+") values("+values+")");
return count;
}
////////
public void DispTable(String query,ServletOutputStream out) throws ServletException,IOException{
out.println("<TABLE BORDER=\"1\" ALIGN=\"CENTER\" >");
try{
synchronized(this) {
int i=0,j=0;
String tmpstr,checkbo;
rs=t.recordSql(query);
//rs=t.recordSql("select * from ServeTable where ServeTable.id='n'");
ResultSetMetaData rsmd=rs.getMetaData();
int numCols=rsmd.getColumnCount();
//display each column title
out.print("<TD>"+ "column name");
for(i=1;i<=numCols;i++){
out.print("<TD>"+rsmd.getColumnLabel(i));
}
out.println("<TR>");
//display each column data
while (rs.next()){
j++;
checkbo=rs.getString(1);
//为每行记录增加一复选框
out.print("<TD><INPUT TYPE=\"checkbox\" NAME=\"record"+j+"\""+" value=\""+checkbo+"\">");
out.print("<TD>"+checkbo);
for(i=1;i<=numCols;i++){
//out.println(new String(name.getBytes("GBK"),"ISO8859_1") );
out.print("<TD>"+new String(rsmd.getColumnLabel(i).getBytes("GBK"),"ISO8859_1") );
System.out.println("display the title");
System.out.println(new String(rsmd.getColumnLabel(i).getBytes("GBK"),"ISO8859_1") );
}
out.println("<TR>");
System.out.println("enter display the table records");
}///end while
}
}///end try
catch(SQLException ex){
System.out.println("\n***SQLException caught ***\n");
while (ex != null){
System.out.println("SQLState:"+ex.getSQLState());
System.out.println("Message:"+ex.getMessage());
System.out.println("Vendor:"+ex.getErrorCode());
ex=ex.getNextException();
System.out.println("");
}
}
}
////////////
public void WatchParameters(HttpServletRequest req,ServletOutputStream out)
throws ServletException,IOException{
int i=1;
Enumeration keys;
String kkey,values;
keys=req.getParameterNames();
while (keys.hasMoreElements()) {
kkey=(String)keys.nextElement();
values=req.getParameter(kkey);
out.println("<P>"+"key: "+kkey+" equals value:"+values);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -