dbregedit.java~2~

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

    }
}
}