簡單的JavaWeb注冊登錄案例

1.注冊頁面register.html

register

姓名：

電話：

郵箱：

qq：

2.注冊案例實現程序register.java

/**

* 注冊案例實現程序

* @author lucky

*

*/

public class register extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response) {

//獲取表單提交過來的信息

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

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

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

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

//調用database中的insert方法，將新用戶添加到數據庫中

database db = new database();

try {

db.insert(username, telephone, email, qq);

} catch (Exception e) {

e.printStackTrace();

}

}

}

3.登錄頁面enter.html

Insert title here

用戶：

密碼：

4.登錄案例實現程序enter.java

/**

* 登錄案例實現代碼

* @author lucky

*

*/

public class enter extends HttpServlet{

public void doGet(HttpServletRequest request,HttpServletResponse response) {

//獲取表單提交的信息

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

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

//標記，i=2:出現錯誤 i=1:登錄成功 i=0:登錄失敗

int i = 2;

//調用database方法read查詢數據庫

//用戶名密碼(qq)匹配則i=1 不匹配則i=0

database db = new database();

try {

i = db.read(username, qq);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

System.out.println(i);

}

}

5.數據庫操作相關程序database.java

/*

* 數據庫操作相關程序

*/

public class database {

/*

* 用戶注冊，像數據庫中添加信息

*/

public void insert(String username,String telephone,String email,String qq) throws Exception {

//連接池

ComboPooledDataSource cp = new ComboPooledDataSource();

Connection conn = cp.getConnection();

String sql = "insert into user(username,telephone,email,qq) values(?,?,?,?);";

//語句預編譯執行者

PreparedStatement pt = conn.prepareStatement(sql);

//插入參數

pt.setString(1, username);

pt.setString(2, telephone);

pt.setString(3, email);

pt.setString(4, qq);

//執行sql語句，輸出結果

int i = pt.executeUpdate();

System.out.println(i);

}

/*

* 用戶登錄 向數據庫查詢用戶輸入信息是否正確

*/

public int read(String username,String qq) throws Exception {

ComboPooledDataSource cp = new ComboPooledDataSource();

Connection conn = cp.getConnection();

//通過提交的用戶名對比查詢相應的qq 結果一致則輸入正確 不一致則輸入錯誤

String sql = "select qq from user where username = ?;";

//用pwd接受數據庫中查詢出來的qq信息

String pwd = null;

PreparedStatement pt = conn.prepareStatement(sql);

pt.setString(1, username);

//re接收結果集

ResultSet rs = pt.executeQuery();

//對比qq信息是否一致

while(rs.next()){

pwd = rs.getString("qq");

System.out.println("qq"+pwd);

}

//輸出結果

if(pwd.equals(qq)) return 1;

elsereturn 0;

}

}

6.web.xml

registerenter

register

web.register

register

/register

enter

web.enter

enter

/enter

新人學習記錄，有問題可以一起探討。