標籤：value w3c equal div .com dao htm 自動 資訊
登入端
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body><form action="Check2.jsp" method="post">卡號：<input type="text" name="cardid1"><br>密碼：<input type="password" name="password1"><br><input type="submit" value="登入"></form>></body></html>
串連請求端
<%@page import="com.web.cardDAO"%><%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body><%String cardid=request.getParameter("cardid1");String password=request.getParameter("password1");if(cardid==null||password==null||cardid.equals("") || password.equals("")){ out.write("請正確登入系統");}else{ //檢查登入資訊 cardDAO cd=new cardDAO(); if(cd.checklogin(cardid, password)) { out.write("登入成功"); } else { out.write("登入失敗"); }}%></body></html>
Java代碼類
package com.web;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import com.mchange.v2.c3p0.ComboPooledDataSource;public class cardDAO {ComboPooledDataSource cpd=new ComboPooledDataSource("helloc3p0");public boolean checklogin(String cardid,String password){boolean boo=false;try {Connection conn=cpd.getConnection();PreparedStatement ps=conn.prepareStatement("select * from bank where ba_card=? and ba_password=?");ps.setString(1, cardid);ps.setString(2, password);ResultSet rs=ps.executeQuery();boo=rs.next();rs.close();ps.close();conn.close();cpd.close();} catch (SQLException e) {// TODO 自動產生的 catch 塊e.printStackTrace();}return boo;}}
JavaEE串連資料庫練習
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
