account_odbc.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.ResultSet;
import java.util.*;
import java.util.Date;

public class Account_odbc {
    String Account;   //用于取得用户在文本框中输入的用户名
    String Pwd;     //用于取得用户在文本框中输入的密码
    ResultSet rs;
    transform tf=new transform();   //实例化字符转换函数
    SQL_execute manage= new  SQL_execute();
    int x=0;
    public Account_odbc() {
    }

    public ResultSet login(HttpServletRequest request, HttpServletResponse response)
    {
        Account = request.getParameter("Account");
        Account = tf.GBK(Account.trim()); //清除用户在输入文本框中两侧输入的空格，并进行字符转换
        Pwd = request.getParameter("Pwd");
        Pwd = Pwd.trim();
        String sql = "Select * from Shop_Member_info where Account='" + Account +"'and Pwd='" + Pwd + "'";
        try
        {
            rs=manage.query(sql);
        }
        catch (Exception e)
       {
           System.out.print("查询用户表时出现错误："+e.getMessage());
       }
       return rs;
   }



   public int updateAccount_message(HttpServletRequest request, HttpServletResponse response)
   {
       Account = request.getParameter("Account");
       Account=tf.GBK(Account.trim());

       String Name=request.getParameter("Name");
       Name=tf.GBK(Name.trim());

       String Age=request.getParameter("Age");
       Age=Age.trim();

       String Sex=request.getParameter("Sex");
       Sex=tf.GBK(Sex.trim());

       String Address=request.getParameter("Address");
       Address=tf.GBK(Address.trim());

       String Tel=request.getParameter("Tel");
       Tel=Tel.trim();

       String Email=request.getParameter("Email");
       Email=Email.trim();

       String PostCode=request.getParameter("PostCode");

        String string= "Name='"+Name+"',Age='"+Age+"',Sex='"+Sex+"',Address='"+Address+"',Tel='"+Tel+"',Email='"+Email+"',PostCode='"+PostCode+"'";
        System.out.println(string);


        String updatesql="update Shop_Member_Info set "+string+"  where Account='"+Account+"'";
        System.out.println(updatesql);

        try
       {
           x=manage.update(updatesql);
           manage.close();
       }
       catch (Exception e)
       {
           System.out.print("插入数据时出现错误："+e);
           manage.close();
       }
       return x;
   }

   public int Enrollment(HttpServletRequest request, HttpServletResponse response)
   {
       int ee=0;
       String Account = (String)tf.GBK(request.getParameter("Account"));
       Account=Account.trim();
       String sql="Select count(*) as count from Shop_Member_info where Account='"+Account+"'";  //查询数据库中的记录行数
       try{
           ResultSet a=manage.query(sql);
           if(a.next())
           {
               ee = a.getInt("count");  //提取记录中返回的行数
               System.out.println("它的行数是："+x);
           }
       }
       catch(Exception e)
       {
           System.out.println("你在查询用户名是否存在时出现错误(Account_odbc/queryuser)："+e.getMessage());
       }
       if (ee>0)
       {
           x=6;
           manage.close();
       }
       else {
           Pwd = tf.GBK(request.getParameter("Pwd"));
           Pwd = Pwd.trim();
           String Name =tf.GBK(request.getParameter("Name"));
           Name = Name.trim();
           String Age = request.getParameter("Age");
           Age = Age.trim();
           String Sex = request.getParameter("Sex");
           Sex = tf.GBK(Sex.trim());
           System.out.println("你是" + Sex);
           String Address = tf.GBK(request.getParameter("Address"));
           Address = Address.trim();
           String Tel = request.getParameter("Tel");
           Tel = Tel.trim();
           String Email = request.getParameter("Email");
           Email = Email.trim();
           String PostCode = request.getParameter("PostCode");
           PostCode = PostCode.trim();


           GregorianCalendar cc = new GregorianCalendar();
           String date = cc.getTime().toString();




           String string = Account + "','" + Pwd + "','" + Name + "','" + Age +
                           "','" + Sex + "','" + Address + "','" + Tel + "','" +
                           Email + "','" + 0 + "','" + date + "','" + PostCode;
           String insertsql = "insert Shop_Member_info values('" + string +
                              "')"; //(Name,Pwd,Name,age,Sex,Address,Tel,Email)
           System.out.println(insertsql);
           try {
               x=manage.update(insertsql);
           } catch (Exception e) {
               System.out.print("插入数据时出现错误：" + e);
           }
       }
       return x;
   }

   public int update_pwd(HttpServletRequest request, HttpServletResponse response)
   {
       Account = request.getParameter("Account").trim();
       Pwd=request.getParameter("Pwd").trim();//提取表单中用户要更改的新用户密码
       String updatesql = "update Shop_Member_Info set Pwd='" + Pwd +"'  where Account='" + Account + "'";
       System.out.println(updatesql);
       try
       {
           x = manage.update(updatesql);
           manage.close();
       }
       catch(Exception e)
       {
           System.out.println("会员修改密码失败："+e.getMessage());
           manage.close();
       }
       return x;
   }

   public ResultSet controPwd(HttpServletRequest request, HttpServletResponse response)
   {
       Account =tf.GBK(request.getParameter("Account").trim());
       String Email=tf.GBK(request.getParameter("Email").trim());
       String sql="Select * from Shop_Member_info where Account='"+Account+"'and Email='"+Email+"'";
       try{
           System.out.println("你输入的查询是：" + sql);
           rs = manage.query(sql);
       }
       catch(Exception e)
       {System.out.println("用户在找回密码时出现异常"+e.getMessage());}
       return rs;
   }
   public void close()
   {
       manage.close() ;
   }

}