?? ecminfmanage.java
字號:
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class ecmInfManage extends HttpServlet{
String SaleType;
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();
SaleType=(String)req.getParameter("sale");
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");
t = new tableSql("Ecmdb");
dbName="Ecmdb";
tableName="goods";
if(SaleType.equals("select")) {
Que(out,tableName,dbName);
}else if(SaleType.equals("add")){
Add(out,tableName,dbName);
}else if(SaleType.equals("delete")){
Del(out,tableName,dbName);
}else if(SaleType.equals("update")){
Upd(out,tableName,dbName);
}
}
public void Que(ServletOutputStream out,String tableName,String dbName) throws ServletException,IOException
{
System.out.println("I will display the Que html!");
Sresp.setContentType("text/html");
out.println("<HTML>");
out.println("<HEAD><TITLE>Select goods</TITLE></HEAD>");
out.println("<BODY bgcolor=\"f5f5f5\">");
out.println("<br><br><br>");
out.println("<FORM method=\"post\"action=\"/servlet/ecmInfSelect\">");
out.println("<INPUT TYPE=\"hidden\" name=\"DbName\" value=\""+dbName+"\" >");
out.println("<INPUT TYPE=\"hidden\" name=\"TableName\" value=\""+tableName+"\" >");
String tempstr="請輸入你的查詢條件：";
out.println("<p align=\"left\">"+new String(tempstr.getBytes("GBK"),"ISO8859_1")+"</p>");
tempstr="商品名稱:";
out.println("<p align=\"left\">"+new String(tempstr.getBytes("GBK"),"ISO8859_1")+"<select name=\"GoodsType\">");
out.println("<option>"+new String(cGoodsType[0].getBytes("GBK"),"ISO8859_1")+"</option>");
out.println("<option>"+new String(cGoodsType[1].getBytes("GBK"),"ISO8859_1")+"</option>");
out.println("<option>"+new String(cGoodsType[2].getBytes("GBK"),"ISO8859_1")+"</option>");
out.println("</select><br><br>");
tempstr="商品型號:";
out.println(new String(tempstr.getBytes("GBK"),"ISO8859_1")+"<input type=\"text\" size=10 name=\"GoodsModel\"><br><br>");
tempstr="商品價格:";
out.println(new String(tempstr.getBytes("GBK"),"ISO8859_1")+"<input type=\"text\" size=10 name=\"GoodsPrice\"><br><br>");
tempstr="商品產量:";
out.println(new String(tempstr.getBytes("GBK"),"ISO8859_1")+"<input type=\"text\" size=10 name=\"GoodsAmount\"><br><br>");
tempstr="開始查找";
out.println("<input type=\"submit\" value=\""+new String(tempstr.getBytes("GBK"),"ISO8859_1")+"\"></p>");
out.println("</form>");
out.println("</body></html>");
System.out.println("I display complete!");
}
public void Add(ServletOutputStream out,String tableName,String dbName) throws ServletException,IOException{
String Lab="";
System.out.println("i will display Add html!");
Sresp.setContentType("text/html");
String temp,temp1;
temp=new String("請輸入以下信息");
temp1=new String(temp.getBytes("GBK"),"ISO8859_1");
out.println("<HTML>");
out.println("<HEAD><TITLE>Add Goods</TITLE></HEAD>");
out.println("<BODY bgcolor=\"#f5f5f5\">");
out.println("<HR><B>"+temp1+"</B><BR>");
out.println("<FORM METHOD=POST ACTION=\"/servlet/ecmInfAdd\">");
out.println("<INPUT TYPE=\"hidden\" name=\"DbName\" value=\""+dbName+"\" >");
out.println("<INPUT TYPE=\"hidden\" name=\"TableName\" value=\""+tableName+"\" >");
try{
int i;
rs=t.recordSql("select * from "+tableName);
ResultSetMetaData rsmd=rs.getMetaData();
int numCols=rsmd.getColumnCount();
for(i=2;i<=numCols-2;i++){
out.println(rsmd.getColumnLabel(i)+": "+"<INPUT TYPE=TEXT NAME="+"\""+"field"+i+"\"><BR>");
Lab=Lab+rsmd.getColumnLabel(i)+",";
}
}
catch(SQLException e){System.out.println("Error SQL");}
//Lab=Lab.substring(int beginIndex, int endIndex)
Lab=Lab.substring(0, (Lab.length()-1) );
System.out.println(Lab);
out.println("<INPUT TYPE=\"hidden\" name=\"ColumnsLab\" value=\""+Lab+"\" >");
out.println("<INPUT TYPE=SUBMIT VALUE="+insert0+">");
out.println("<INPUT TYPE=RESET VALUE="+cancel0+">");
out.println("</FORM>");
out.println("<BR><HR><BR>");
DispTable("select * from "+tableName,out);
out.println("</BODY></HTML>");
}
public void Del(ServletOutputStream out,String tableName,String dbName) throws ServletException,IOException{
Sresp.setContentType("text/html");
out.println("<HTML>");
out.println("<HEAD><TITLE>Delete Goods</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/ecmInfDel\">");
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("<B>"+temp001+":<INPUT TYPE=TEXT SIZE=20 NAME=\"Conditions\"></B><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 Goods</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/ecmInfUpd\">");
try{
int i;
rs=t.recordSql("select * from "+tableName);
ResultSetMetaData rsmd=rs.getMetaData();
int numCols=rsmd.getColumnCount();
////Lab 用于構造update語句
for(i=2;i<=numCols-1;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 + -