dbregedit.java

JSP制作的一个在线书店 拥有简单的功能 请看看吧 初学者

package ConnBean;

import java.sql.*;
import ConnBean.*;
import java.util.*;
import common.MemberBean;

public class DBregedit {
    ConnBean objCon = new ConnBean();
    Statement stmt = null;
    ResultSet rs = null;
    //Calendar objCal;
    public DBregedit() {
        this.stmt = objCon.getStmt();
    }

public boolean InserDB(MemberBean objMB) {
    try {
        int sex = 1;
        if (objMB.isSex())
            sex = 0;
        String strSqlI = "insert into Member values ('" +
                         objMB.getMemberuid() + "','" +
                         objMB.getCertificateType() + ",'" +
                         objMB.getMemberName() + "','" +
                         objMB.getTelephoneNumber() + "','" +
                         objMB.getPassword() + "','" + objMB.getEmail() +
                         "','" + objMB.getAnswer() + "','" +
                         objMB.getQuestion() + "','" + objMB.getRname() +
                         "','" + sex + "," + objMB.getAge() + "','" +
                         objMB.getBirthday() +"','" +
                         objMB.getCertificateNumber() + "','" +
                         objMB.getRegeditDate() + "','" + objMB.getAddress() +
                         "','" + objMB.getMobliephoneNumber() + "','" +
                         objMB.getStandbyAddress() + "')";
        System.out.println(strSqlI);
        int value = this.stmt.executeUpdate(strSqlI);

        if (value == 1) {
            return true;
        } else {
            return false;
        }

    } catch (SQLException ex) {
        ex.printStackTrace();
        return false;
    }
}

public void Updata(String strSqlU) {
    try {
        objCon.stmt.executeUpdate(strSqlU);
    } catch (SQLException ex) {
        ex.printStackTrace();
    }
}

public ResultSet getResultSet(String strSqlS) {
    try {
        rs = objCon.stmt.executeQuery(strSqlS);
        return (rs);
    } catch (Exception e) {
        e.printStackTrace();
        return null;
    }
}

public boolean SelectUserInfo(MemberBean objMB) {
   try {
       String strSql = "select * from member where memberName='" +
                       objMB.getMemberName() + "' and password='" +
                       objMB.getPassword() + "'";
       ResultSet rs = null;
       rs = this.stmt.executeQuery(strSql);
       if (rs.next()) {
           return true;
       } else {
           return false;
       }
   } catch (Exception e) {
       e.printStackTrace();
       return false;
   }
}

public Vector SelectUserLogin(String strsql) {
    Vector v = new Vector() ;
    ResultSet rs = null;
    MemberBean objM = null;
    try {
        rs = this.stmt.executeQuery(strsql);
        while (rs.next()) {
            objM = new MemberBean();
            objM.setMemberuid(rs.getString(1) ) ;
            objM.setMemberName(rs.getString(2) ) ;
            objM.setPassword(rs.getString(3) ) ;
            objM.setAddress(rs.getString(4));
                 objM.setEmail(rs.getString(5));
                 //objM.setSex(Boolean.parseBoolean(rs.getString(6)));
                 objM.setBirthday(rs.getString(7));
                 //objM.setCertificateType(rs.getInt(8));
                 objM.setCertificateNumber(rs.getString(9));
                 //objM.setAge(rs.getInt(10));
                 objM.setAnswer(rs.getString(11));
                 objM.setQuestion(rs.getString(12));
                 objM.setRegeditDate(rs.getString(13));
                 objM.setRname(rs.getString(14));
                 objM.setTelephoneNumber(rs.getString(15));
                 objM.setMobliephoneNumber(rs.getString(16));
                 objM.setStandbyAddress(rs.getString(17));
                 v.add(objM);
             }
             return v;
         } catch (Exception e) {
             e.printStackTrace();
             return null;
         }
     }
 }