📄 ecmsysmanage.java
字号:
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class ecmSysManage extends HttpServlet{
String SysType;
String dbName,tableName;
ResultSet rs;
HttpServletRequest Sreq;
HttpServletResponse Sresp;
tableSql t;
//String eGoodsType[];//use for save english type
String cGoodsType[]={"彩电","冰箱","电脑"};//
String insert0,insert1,delete1,cancel1,update1,delete0,cancel0,update0;
public void init(ServletConfig conf) throws ServletException {
super.init(conf);
}
public void service(HttpServletRequest req,HttpServletResponse resp)
throws ServletException,IOException{
Sreq=req;
Sresp=resp;
ServletOutputStream out=Sresp.getOutputStream();
SysType=(String)req.getParameter("sys");
cancel1="取消";
delete1="删除";
insert1="插入";
update1="更改";
insert0=new String(insert1.getBytes("GBK"),"ISO8859_1");
delete0=new String(delete1.getBytes("GBK"),"ISO8859_1");
cancel0=new String(cancel1.getBytes("GBK"),"ISO8859_1");
update0=new String(update1.getBytes("GBK"),"ISO8859_1");
if(SysType.equals("center"))
{
t = new tableSql("Sysdb");
dbName="Sysdb";
tableName="fndConfig";
Updcenter(out,tableName,dbName); //对商务中心提供修改
}else if(SysType.equals("service"))
{
t = new tableSql("Ecmdb");
dbName="Ecmdb";
tableName="service";
Del(out,tableName,dbName);//对服务列表提供删除
}else if(SysType.equals("cycle"))
{
t = new tableSql("Ecmdb");
dbName="Ecmdb";
tableName="ecmSys";
Upd(out,tableName,dbName);//对服务方式提供更该
}
}
public void Del(ServletOutputStream out,String tableName,String dbName) throws ServletException,IOException{
Sresp.setContentType("text/html");
out.println("<HTML>");
out.println("<HEAD><TITLE>Delete Service</TITLE></HEAD>");
out.println("<BODY bgcolor=\"#f5f5f5\">");
String temp000,temp001;
temp000="请选择要删除的服务项目:";
temp001=new String(temp000.getBytes("GBK"),"ISO8859_1");
out.println("<HR><B>"+temp001+"</B><BR>");
out.println("<FORM METHOD=POST ACTION=\"/servlet/ecmSysDel\">");
out.println("<INPUT TYPE=\"hidden\" name=\"DbName\" value=\""+dbName+"\" >");
out.println("<INPUT TYPE=\"hidden\" name=\"TableName\" value=\""+tableName+"\" >");
DispTable("select * from "+tableName,out);
out.println("<HR>");
temp000="按选择的记录删除";
temp001=new String(temp000.getBytes("GBK"),"ISO8859_1");
out.println("<INPUT TYPE=\"radio\" NAME=\"IsSelect\" VALUE=\"select\"CHECKED>"+temp001+"<BR>");
temp000="按输入条件删除";
temp001=new String(temp000.getBytes("GBK"),"ISO8859_1");
out.println("<INPUT TYPE=\"radio\" NAME=\"IsSelect\" VALUE=\"noselect\">"+temp001+"<BR>");
temp000="请输入你的删除条件";
temp001=new String(temp000.getBytes("GBK"),"ISO8859_1");
out.println(temp001+":<INPUT TYPE=TEXT SIZE=20 NAME=\"Conditions\"><BR>");
out.println("<INPUT TYPE=SUBMIT value="+delete0+">");
out.println("<INPUT TYPE=RESET value="+cancel0+">");
out.println("</FORM>");
out.println("<BR><BR><HR>");
out.println("</BODY></HTML>");
}
public void Upd(ServletOutputStream out,String tableName,String dbName) throws ServletException,IOException{
String Lab="";
Sresp.setContentType("text/html");
System.out.println("i can do UpdOption");
out.println("<HTML>");
out.println("<HEAD><TITLE>Update</TITLE></HEAD>");
out.println("<BODY bgcolor=\"#f5f5f5\">");
out.println("<HR>");
String temp000,temp001;
temp000="请选择要更改的记录";
temp001=new String(temp000.getBytes("GBK"),"ISO8859_1");
out.println("<B>"+temp001+"</B><BR><hr>");
out.println("<FORM METHOD=POST ACTION=\"/servlet/ecmSysUpd\">");
try{
int i;
rs=t.recordSql("select * from "+tableName);
ResultSetMetaData rsmd=rs.getMetaData();
int numCols=rsmd.getColumnCount();
////Lab 用于构造update语句
for(i=2;i<=numCols;i++){
Lab=Lab+rsmd.getColumnLabel(i)+"=?,";
}
Lab=Lab.substring(0, (Lab.length()-1) );
}
catch(SQLException e){System.out.println("Error SQL");}
out.println("<INPUT TYPE=\"hidden\" name=\"DbName\" value=\""+dbName+"\" >");
out.println("<INPUT TYPE=\"hidden\" name=\"TableName\" value=\""+tableName+"\" >");
out.println("<INPUT TYPE=\"hidden\" name=\"UpdLab\" value=\""+Lab+"\" >");
DispTable("select * from "+tableName,out);
out.println("<HR>");
out.println("<INPUT TYPE=SUBMIT VALUE="+update0+">");
out.println("<INPUT TYPE=RESET VALUE="+cancel0+">");
out.println("</FORM>");
out.println("</BODY></HTML>");
}
public void Updcenter(ServletOutputStream out,String tableName,String dbName) throws ServletException,IOException{
String Lab="";
Sresp.setContentType("text/html");
System.out.println("i can do UpdOption");
out.println("<HTML>");
out.println("<HEAD><TITLE>Update</TITLE></HEAD>");
out.println("<BODY bgcolor=\"#f5f5f5\">");
out.println("<HR>");
String temp000,temp001;
temp000="请选择要更改的记录";
temp001=new String(temp000.getBytes("GBK"),"ISO8859_1");
out.println("<B>"+temp001+"</B><BR><hr>");
out.println("<FORM METHOD=POST ACTION=\"/servlet/ecmSysUpdcenter\">");
try{
int i;
rs=t.recordSql("select * from "+tableName);
ResultSetMetaData rsmd=rs.getMetaData();
int numCols=rsmd.getColumnCount();
////Lab 用于构造update语句
for(i=2;i<=numCols-2;i++){
Lab=Lab+rsmd.getColumnLabel(i)+"=?,";
}
Lab=Lab.substring(0, (Lab.length()-1) );
}
catch(SQLException e){System.out.println("Error SQL");}
out.println("<INPUT TYPE=\"hidden\" name=\"DbName\" value=\""+dbName+"\" >");
out.println("<INPUT TYPE=\"hidden\" name=\"TableName\" value=\""+tableName+"\" >");
out.println("<INPUT TYPE=\"hidden\" name=\"UpdLab\" value=\""+Lab+"\" >");
DispTable("select * from "+tableName,out);
out.println("<HR>");
out.println("<INPUT TYPE=SUBMIT VALUE="+update0+">");
out.println("<INPUT TYPE=RESET VALUE="+cancel0+">");
out.println("</FORM>");
out.println("</BODY></HTML>");
}
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("<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();
out.print("<TD>column name");
for(i=1;i<=numCols;i++){
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>");
}
}
public void Destroy(){
t.closeConnect();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -