package com.netshop;
import java.sql.*;
import java.text.*;
public class user extends executeWay
{
public long ID;
public String userName;
public String userPassword;
public String email;
public int sex;
public String identityID;
public String shopName;
public String shopIntro;
public String shopper;
public String realName;
public long mainFields;
public String telephone;
public String createDate;
public int sysRole;
public int tag;
private String strSql;
private SimpleDateFormat dateFormatter;
public user()
{
dateFormatter = new SimpleDateFormat("yyyy-MM-dd");
ID=0;
userName="";
userPassword="";
realName="";
sex=0;
shopName="";
shopper="";
mainFields=0;
shopIntro="";
telephone="";
identityID="";
sysRole=0;
email="";
createDate=dateFormatter.format(new java.util.Date());
tag=0;
strSql="";
}
public boolean add()
{
strSql="insert into users ";
strSql=strSql + "(";
strSql=strSql + "userName,";
strSql=strSql + "userPassword,";
strSql=strSql + "email,";
strSql=strSql + "sex,";
strSql=strSql + "identityID,";
strSql=strSql + "shopName,";
strSql=strSql + "shopIntro,";
strSql=strSql + "shopper,";
strSql=strSql + "realName,";
strSql=strSql + "mainFields,";
strSql=strSql + "telephone,";
strSql=strSql + "createDate,";
strSql=strSql + "sysRole,";
strSql=strSql + "tag";
strSql=strSql + ") ";
strSql=strSql + "values(";
strSql=strSql + "'" + userName + "',";
strSql=strSql + "'" + userPassword + "',";
strSql=strSql + "'" + email + "',";
strSql=strSql + "'" + sex + "',";
strSql=strSql + "'" + identityID + "',";
strSql=strSql + "'" + shopName + "',";
strSql=strSql + "'" + shopIntro + "',";
strSql=strSql + "'" + shopper + "',";
strSql=strSql + "'" + realName + "',";
strSql=strSql + "'" + mainFields + "',";
strSql=strSql + "'" + telephone + "',";
strSql=strSql + "'" + createDate + "',";
strSql=strSql + "'" + sysRole + "',";
strSql=strSql + "'" + tag + "'";
strSql=strSql + ")";
System.out.println(strSql);
boolean isAdd = super.exeSqlUpdate(strSql);
return isAdd;
}
public boolean modifyUserInfo(String webID)
{
strSql="update users set";
strSql=strSql + " userName=" + "'" + userName + "',";
strSql=strSql + " email=" + "'" + email + "',";
strSql=strSql + " sex=" + "'" + sex + "',";
strSql=strSql + " identityID=" + "'" + identityID + "',";
strSql=strSql + " shopName=" + "'" + shopName + "',";
strSql=strSql + " shopIntro=" + "'" + shopIntro + "',";
strSql=strSql + " shopper=" + "'" + shopper + "',";
strSql=strSql + " realName=" + "'" + realName + "',";
strSql=strSql + " mainFields=" + "'" + mainFields + "',";
strSql=strSql + " telephone=" + "'" + telephone + "',";
strSql=strSql + " createDate=" + "'" + createDate + "',";
strSql=strSql + " sysRole=" + "'" + sysRole + "',";
strSql=strSql + " tag=" + "'" + tag + "'";
strSql=strSql + " where ID='" + webID + "'";
System.out.println(strSql);
boolean isUpdate = super.exeSqlUpdate(strSql);
return isUpdate;
}
public boolean updatekey(String webID,String webUserPassword)
{
strSql="update users set ";
strSql=strSql + "userPassword=" + "'" + webUserPassword + "'";
strSql=strSql + " where ID='" + webID + "'";
boolean isUpdatekey = super.exeSqlUpdate(strSql);
return isUpdatekey;
}
public boolean delete(String webID)
{
strSql="delete from `users` where ID='";
strSql=strSql + webID + "'";
boolean isDelete1 = super.exeSqlUpdate(strSql);
strSql="delete from `goods` where issuer='";
strSql=strSql + webID + "'";
boolean isDelete2 = super.exeSqlUpdate(strSql);
strSql="delete from `discussion` where authorID='";
strSql=strSql + webID + "'";
boolean isDelete3 = super.exeSqlUpdate(strSql);
strSql="delete from `attention` where userID='";
strSql=strSql + webID + "'";
boolean isDelete4 = super.exeSqlUpdate(strSql);
boolean isDelete = isDelete1&&isDelete2&&isDelete3&&isDelete4;
return isDelete;
}
public boolean init(String webID)
{
strSql="select * from `users` where ID=";
strSql=strSql + "'" + webID + "'";
try
{
ResultSet rs = super.exeSqlQuery(strSql);
if (rs.next())
{
ID=rs.getLong("ID");
userName=rs.getString("userName");
userPassword=rs.getString("userPassword");
realName=rs.getString("realName");
sex=rs.getInt("sex");
identityID=rs.getString("identityID");
shopName=rs.getString("shopName");
shopIntro=rs.getString("shopIntro");
email=rs.getString("email");
shopper=rs.getString("shopper");
mainFields=rs.getLong("mainFields");
telephone=rs.getString("telephone");
createDate=rs.getString("createDate");
sysRole=rs.getInt("sysRole");
tag=rs.getInt("tag");
return true;
}
else
{
return false;
}
}
catch(Exception ex)
{
System.out.println(ex.toString());
return false;
}
}
public boolean isValidUser(String webUserName,String webUserPassword,String webRole)
{
strSql="select * from `users` ";
strSql=strSql + " where userName='" + webUserName + "'";
strSql=strSql + " and userPassword='"+ webUserPassword + "'";
strSql=strSql + " and sysRole='"+ webRole + "'";
try
{
ResultSet rs = super.exeSqlQuery(strSql);
if (rs.next())
{
ID=rs.getLong("ID");
userName=rs.getString("userName");
userPassword=rs.getString("userPassword");
realName=rs.getString("realName");
sex=rs.getInt("sex");
identityID=rs.getString("identityID");
shopName=rs.getString("shopName");
shopIntro=rs.getString("shopIntro");
email=rs.getString("email");
shopper=rs.getString("shopper");
mainFields=rs.getLong("mainFields");
telephone=rs.getString("telephone");
createDate=rs.getString("createDate");
sysRole=rs.getInt("sysRole");
tag=rs.getInt("tag");
return true;
}
else
{
return false;
}
}
catch(Exception ex)
{
return false;
}
finally
{
}
}
public boolean isExist(String webUserName)
{
strSql="select * from `users` ";
strSql=strSql + " where userName='" + webUserName + "'";
try
{
ResultSet rs = super.exeSqlQuery(strSql);
if (rs.next())
{
return true;
}
else
eshop_sql.rar_IT网站 mysql （109个子文件） 
user.class 7KB goods.class 5KB sendMail.class 5KB Email.class 4KB FileUpload.class 4KB disscussion.class 3KB discussion.class 3KB goodsField.class 2KB attention.class 2KB executeWay.class 1KB OpenDB.class 1KB Thumbs.db 18KB
mysql-connector-java-5.1.20-bin.jar 784KB user.java 9KB goods.java 6KB sendMail.java 6KB FileUpload.java 5KB Email.java 4KB discussion.java 4KB goodsField.java 2KB attention.java 2KB executeWay.java 1KB OpenDB.java 735B
pic01.jpg 22KB pic05.jpg 20KB pic02.jpg 20KB pic04.jpg 20KB pic03.jpg 17KB showGoods.jsp 7KB merchantAddForm.jsp 5KB regMerchant.jsp 5KB showMerchant.jsp 5KB modifyShopForm.jsp 5KB merchantModifyForm.jsp 5KB allGoodsList.jsp 4KB allMerchantList.jsp 4KB goodsShow.jsp 4KB goodsModifyForm.jsp 4KB allUserList.jsp 3KB allGoodsFieldList.jsp 3KB modifyGoodsForm.jsp 3KB goodsAddForm.jsp 3KB first.jsp 3KB searchForm.jsp 3KB shopShow.jsp 3KB userLogin.jsp 3KB userAddForm.jsp 3KB goodsModifySave.jsp 2KB regUser.jsp 2KB getMypassword.jsp 2KB modifyGoodsSave.jsp 2KB myAttentionList.jsp 2KB goodsAddSave.jsp 2KB merchantAddSave.jsp 2KB myDiscussionList.jsp 2KB myReceiveBox.jsp 2KB sendMailBox.jsp 2KB modifyPasswordForm.jsp 2KB newMerchantList.jsp 2KB sendMailSave.jsp 2KB regMerchantSave.jsp 2KB myGoodsList.jsp 2KB merchantModifySave.jsp 1KB userAddSave.jsp 1KB reg.jsp 1KB modifyShopSave.jsp 1KB emailShow.jsp 1KB sendMail.jsp 1KB goodsFieldModifySave.jsp 1KB goodsFieldModifyForm.jsp 1KB discussionSave.jsp 1KB attentionSave.jsp 1KB goodsFieldAddSave.jsp 1KB modifyPasswordSave.jsp 1KB deleteEmail.jsp 1KB merchant_top.jsp 1KB admin_top.jsp 1KB goodsFieldDelete.jsp 1KB userDelete.jsp 1KB regUserSave.jsp 1KB goodsDelete.jsp 1KB normal_top.jsp 1KB goodsFieldAddForm.jsp 1KB merchantAdmit.jsp 1KB loginCheck.jsp 1KB deleteDiscussion.jsp 1KB deleteAttention.jsp 1KB deleteGoods.jsp 1KB anonymity_top.jsp 890B regCheck.jsp 887B goodsManagement.jsp 736B info_left.jsp 661B goodsFieldManagement.jsp 587B getPassword.jsp 582B shopManagement.jsp 567B emailManagement.jsp 567B infoManagement.jsp 567B admin_index.jsp 566B userManagement.jsp 563B merchant_index.jsp 563B共 109 条
- 1
- 2
评论0