Jsp練習——串連資料庫類比登入

最後更新：2016-10-28 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

標籤：eth ring doc padding order ansi idt equals 帳號

 1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2     pageEncoding="UTF-8"%> 3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 4 <html> 5 <head> 6 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 7 <title>Insert title here</title> 8 <style type="text/css"> 9 *{10     margin:0px;11     padding:0px;12 }13 .yi{14 width:100%;15 height:500px;16 background:url(background.jpg);17 top:50px;18 position:relative;19 }20 .er{21     width:300px;22     height:400px;23     background:#CCCCCC;24     border:3px solid #FFFFFF;25     left:800px;26     top:50px;27     position:relative;28     font-size:24px;29     font-weight:bold;30     color:#FF3300;31     32     }33 </style>34 </head>35 36 <body>37 <div class="yi" >38 <div class="er">39 <form action="index1.jsp" method="post">40 <input type="text" name="name" value="請輸入帳號" style="width:200px; height:30px;41 margin-top:80px; margin-left:50px;" ><br>42 <input type="password" name="password" style="width:200px; height:30px;43 margin-top:30px; margin-left:50px;" ><br>44 <input type="submit" value="登入" style="width:200px; height:30px;45 margin-top:30px; margin-left:50px;"  >46 </form>47 </div>48 </div>49 50 </body>51 </html>

 1 <%@page import="com.mchange.v2.c3p0.ComboPooledDataSource"%> 2 <%@page import="java.sql.ResultSet"%> 3 <%@page import="java.sql.PreparedStatement"%> 4 <%@page import="java.sql.Statement"%> 5 <%@page import="java.sql.DriverManager"%> 6 <%@page import="java.sql.Connection"%> 7 <%@ page language="java" contentType="text/html; charset=UTF-8" 8     pageEncoding="UTF-8"%> 9 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">10 <html>11 <head>12 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">13 <title>Insert title here</title>14 </head>15 <body>16 <%17 String name = request.getParameter("name");18 String password = request.getParameter("password");19 try{20 //ComboPooledDataSource cp = new ComboPooledDataSource("helloc3p0");21 //Connection conn=cp.getConnection();22 Class.forName("oracle.jdbc.driver.OracleDriver");23 Connection conn = DriverManager.getConnection(24         "jdbc:oracle:thin:@localhost:1521:orcl ",25         "test01", "131281huazioo");26 String sql = "select * from bankcard where card=?";27 PreparedStatement ps = conn.prepareStatement(sql);28 ps.setString(1, name);29 ResultSet rs = ps.executeQuery();30 String nameRe=null;31 String passwordRe=null;32 if(rs.next()){33     nameRe=rs.getString("card");34     passwordRe=rs.getString("password");35 }36 if(name.equals(nameRe)){37     if(password.equals(passwordRe)){38         out.write("登入成功！");39     }else{40         out.write("密碼輸入錯誤！"+"<br>");41         out.write("<a href=‘Login.jsp‘>"+"返回上一頁"+"</a>");42     }43 }else{44     out.write("卡號輸入錯誤！"+"<br>");45     out.write("<a href=‘Login.jsp‘>"+"返回上一頁"+"</a>");46 }47 rs.close();48 ps.close();49 conn.close();50 }catch(Exception e){51     e.printStackTrace();52 }53 %>54 </body>55 </html>

Jsp練習——串連資料庫類比登入

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More