📄 ecminfselect.java
字号:
import java.io.*;
import java.lang.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class ecmInfSelect extends HttpServlet{
String dbName,tableName;
ResultSet rs;
tableSql t;
//String temp,insert0,delete0,cancel0,update0;
public void init(ServletConfig conf) throws ServletException {
super.init(conf);
}
public void service(HttpServletRequest req,HttpServletResponse resp)
throws ServletException,IOException{
ServletOutputStream out=resp.getOutputStream();
String GoodsType,GoodsModel,GoodsPrice,GoodsAmount;
String sqlstr="";
//get the parameter
dbName=req.getParameter("DbName");
tableName=req.getParameter("TableName");
if (req.getParameter("DbName").equals("Ecmdb"))
t = new tableSql("Ecmdb");
GoodsType=req.getParameter("GoodsType");
if ((new String(GoodsType.getBytes("ISO8859_1"),"GBK")).equals("彩电"))
{
GoodsType="caidian";
}
else if ((new String(GoodsType.getBytes("ISO8859_1"),"GBK")).equals("冰箱"))
{
GoodsType="bingxiang";
}
else if ((new String(GoodsType.getBytes("ISO8859_1"),"GBK")).equals("电脑"))
{
GoodsType="computer";
}
else GoodsType="other error"; //error condition
GoodsModel=req.getParameter("GoodsModel");
GoodsPrice=req.getParameter("GoodsPrice");
GoodsAmount=req.getParameter("GoodsAmount");
System.out.println("Goods information is: "+GoodsType+GoodsModel+GoodsPrice+GoodsAmount);
sqlstr="select * from "+tableName+" where ";
if (GoodsType!="")
sqlstr=sqlstr+"goodsname='"+GoodsType+"'";
if (GoodsModel!="")
sqlstr=sqlstr+"and model='"+GoodsModel+"'";
if (GoodsPrice.length()!=0)
{
if ((GoodsPrice.charAt(0)=='<')||(GoodsPrice.charAt(0)=='>'))
{
sqlstr=sqlstr+"and price "+GoodsPrice.substring(0);
}
else
{//do nothing if error format you can add any character here
}//else skip the condition
}
if (GoodsAmount.length()!=0)
{
if ((GoodsAmount.charAt(0)=='<')||(GoodsAmount.charAt(0)=='>'))
{
sqlstr=sqlstr+" and amount "+GoodsAmount.substring(0);
}
else
{//do nothing if error format
}
}
System.out.println("Select string: "+sqlstr);
out.println("<HTML>");
out.println("<HEAD><TITLE>Select goods</TITLE></HEAD>");
out.println("<BODY bgcolor=\"f5f5f5\">");
out.println("<br><hr><br>");
DispTable(sqlstr,out);
out.println("</body></html>");
}
public void Destroy(){
t.closeConnect();
}
////display the Parameter and values
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);
}
}
public void DispTable(String query,ServletOutputStream out) throws ServletException,IOException{
//out.println("<H1>TABLE RESULTS:</H1>");
out.println("<TABLE BORDER=\"1\" ALIGN=\"CENTER\">");
try{
synchronized(this) {
int i=0,j=0;
String tmpstr,checkbo;
rs=t.recordSql(query);
ResultSetMetaData rsmd=rs.getMetaData();
int numCols=rsmd.getColumnCount();
//display each column title
out.print("<TD>column name");
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");
//display each column data
while (rs.next()){
//tmpstr=rs.getString(2);
//out.print("<TD><INPUT TYPE=checkbox NAME=\"record"+i+"\">");
j++;
checkbo=rs.getString(1);
out.print("<TD><INPUT TYPE=\"checkbox\" NAME=\"record"+j+"\""+" value=\""+checkbo+"\">");
out.print("<TD>"+checkbo);
for(i=2;i<=numCols;i++){
tmpstr=rs.getString(i);
if(rs.wasNull())
out.print("<TD>NULL");
else
out.print("<TD>"+new String(tmpstr.getBytes("GBK"),"ISO8859_1") );
}
out.println("<TR>");
}
}
out.println("</TABLE>");
}
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("");
}
out.println("</TABLE>");
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -