基于java的新奥家电连锁网络系统设计与实现

package electric.dbs; /** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2005</p> * <p>Company: </p> * @author not attributable * @version 1.0 */ import java.sql.*; import javax.servlet.http.*; import electric.*; import java.text.SimpleDateFormat; import electric.electricUtils.*; public class Dbshop { private static final String LOAD_SHOP_BY_ID = "SELECT * FROM [USER] WHERE [ID]=?"; private static final String INSERT_SHOP = "INSERT INTO [USER] ([Id],[Username],[Password],[Shopname],[Area],[Peopleman],[Mantel],[Shoptel],[Usertype],[Createdate],[Status]) VALUES " + "(?,?,?,?,?,?,?,?,?,?,?)"; private static final String UPDATE_SHOP = "UPDATE [USER] SET [Username]=?,[Password]=?,[Shopname]=?," + "[Area]=?,[Peopleman]=?,[Mantel]=?,[Shoptel]=?,[Usertype]=?,[Status]=?" + " WHERE [Id]=?"; private static final String Del_SHOP = "UPDATE [USER] SET [Status]=? WHERE [Id]=?"; private static final String CLEAR_SHOP = "DELETE FROM [USER] WHERE STATUS=" + FinalConstants.STATUS_DELETE; private int Id; private String Username; private String Password; private String Shopname; private String Area; private String Peopleman; private String Mantel; private String Shoptel; private int Usertype; private String Createdate; private int Status; public Dbshop() {} public Dbshop(HttpServletRequest request) { this.Id = DbSequenceManager.nextID(FinalConstants.T_SHOP); this.Username = ParamUtils.getEscapeHTMLParameter(request, "username"); this.Password = ParamUtils.getEscapeHTMLParameter(request, "password"); this.Shopname = ParamUtils.getEscapeHTMLParameter(request, "shopname"); this.Area = ParamUtils.getEscapeHTMLParameter(request, "area"); this.Peopleman = ParamUtils.getEscapeHTMLParameter(request, "peopleman"); this.Mantel = ParamUtils.getEscapeHTMLParameter(request, "mantel"); this.Shoptel = ParamUtils.getEscapeHTMLParameter(request, "shoptel"); this.Usertype = ParamUtils.getIntParameter(request,"usertype"); SimpleDateFormat simpleDate = new SimpleDateFormat("yyyyMMdd"); String shiftDateToDate = simpleDate.format(new java.util.Date()); this.Createdate = shiftDateToDate; this.Status = FinalConstants.STATUS_NORMAL; insertIntoDb(); } public Dbshop(int Id) throws ShopNotFoundException { this.Id = Id; // System.out.print(Id); if (Id <= 0) { return; } loadFromDb(); } protected static Dbshop getInstance(int Id) throws ShopNotFoundException { return new Dbshop(Id); } protected void delete() { setStatus(FinalConstants.STATUS_DELETE); } protected static void clear() { Connection con = null; PreparedStatement pstmt = null; try { con = DbConnectionManager.getConnection(); pstmt = con.prepareStatement(CLEAR_SHOP); pstmt.executeUpdate(); } catch (SQLException sqle) { System.err.println( "SQLException in DbTChatRooms.java:clearTChatRooms(): " + sqle); sqle.printStackTrace(); } finally { try { pstmt.close(); } catch (Exception e) { e.printStackTrace(); } try { con.close(); } catch (Exception e) { e.printStackTrace(); } } } ///////////////////////////////////////////////////////////////// public int getId() { return this.Id; } public String getUsername(){ return this.Username; } public String getPassword(){ return this.Password; } public String getShopname(){ return this.Shopname; } public String getArea(){ return this.Area; } public String getPeopleman(){ return this.Peopleman; } public String getMantel(){ return this.Mantel; } public String getShoptel(){ return this.Shoptel; } public int getUsertype(){ return this.Usertype; } public String getCreatedate(){ return this.Createdate; } public int getStatus(){ return this.Status; } //////////////////////WRITE METHODS///////////////////////////// ///////////////////////////////////////////////////////////////// public void setId(int Id) { this.Id=Id; saveToDb(); } public void setUsername(String Username){ this.Username=Username; saveToDb(); } public void setPassword(String Password){ this.Password=Password; saveToDb(); } public void setShopname(String Shopname){ this.Shopname=Shopname; saveToDb(); } public void setArea(String Area){ this.Area=Area; saveToDb(); } public void setPeopleman(String Peopleman){ this.Peopleman=Peopleman; saveToDb(); } public void setMantel(String Mantel){ this.Mantel=Mantel; saveToDb(); } public void setShoptel(String Shoptel){ this.Shoptel=Shoptel; saveToDb(); } public void setUsertypee(int Usertype){ this.Usertype=Usertype; saveToDb(); } public void setCreatedate(String Createdate){ this.Createdate=Createdate; saveToDb(); } public void setStatus(int Status){ this.Status=Status; DELToDb(); } //////////////////////////////////////////////////////////////////////////////// public void modify(HttpServletRequest request) { this.Id = ParamUtils.getIntParameter(request, "id"); this.Username = ParamUtils.getEscapeHTMLParameter(request, "username"); this.Password = ParamUtils.getEscapeHTMLParameter(request, "password"); this.Shopname = ParamUtils.getEscapeHTMLParameter(request, "shopname"); this.Area = ParamUtils.getEscapeHTMLParameter(request, "area"); this.Peopleman = ParamUtils.getEscapeHTMLParameter(request, "peopleman"); this.Mantel = ParamUtils.getEscapeHTMLParameter(request, "mantel"); this.Shoptel = ParamUtils.getEscapeHTMLParameter(request, "shoptel"); this.Usertype = ParamUtils.getIntParameter(request, "usertype"); this.Status = FinalConstants.STATUS_NORMAL; saveToDb(); } private void loadFromDb() throws ShopNotFoundException { Connection con = null; PreparedStatement pstmt = null; try { con = DbConnectionManager.getConnection(); pstmt = con.prepareStatement(LOAD_SHOP_BY_ID); pstmt.setInt(1,Id); ResultSet rs = pstmt.executeQuery(); if (!rs.next()) { throw new ShopNotFoundException("从数据表[SHOP]中读取用户数据失败,欲读取的用户ID:[ " + Id + "]!"); } this.Id = rs.getInt("ID"); this.Username = rs.getString("Username"); this.Password = rs.getString("Password"); this.Shopname = rs.getString("Shopname"); this.Area = rs.getString("Area"); this.Peopleman = rs.getString("Peopleman"); this.Mantel = rs.getString("Mantel"); this.Shoptel = rs.getString("Shoptel"); this.Usertype = rs.getInt("Usertype"); this.Createdate = rs.getString("Createdate"); this.Status = rs.getInt("Status"); } catch (SQLException sqle) { throw new ShopNotFoundException("从数据表[SHOP]中读取用户数据失败,欲读取的用户ID:[ " + Id + "]!"); } finally { try { pstmt.close(); } catch (Exception e) { e.printStackTrace(); } try { con.close(); } catch (Exception e) { e.printStackTrace(); } } } private void insertIntoDb() { Connection con = null; PreparedStatement pstmt = null; try { con = DbConnectionManager.getConnection(); pstmt = con.prepareStatement(INSERT_SHOP); pstmt.setInt(1, this.Id); pstmt.setString(2,StringUtils.toChinese(this.Username)); pstmt.setString(3,StringUtils.toChinese(this.Password)); pstmt.setString(4,StringUtils.toChinese(this.Shopname)); pstmt.setString(5,StringUtils.toChinese(this.Area)); pstmt.setString(6,StringUtils.toChinese(this.Peopleman)); pstmt.setString(7,StringUtils.toChinese(this.Mantel)); pstmt.setString(8,StringUtils.toChinese(this.Shoptel)); pstmt.setInt(9,this.Usertype); pstmt.setString(10,StringUtils.toChinese(this.Createdate)); pstmt.setInt(11,this.Status); p