dbregedit.java~3~

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() + "'";
   }
}catch
}