JSP使用者登入(JavaBean操作sql server資料庫) (tomcat伺服器)

最後更新：2018-12-06 來源：互聯網

上載者：User

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

我的bean
package db;
import java.sql.*;
import java.io.*;
import java.util.*;
public class dbConn{
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=disc";
String user="sa";
String password="20263588";
Statement stmt=null;
Connection conn=null;
ResultSet rs=null;
public dbConn(){
try{
Class.forName(sDBDriver).newInstance();
System.out.println("載入資料庫驅動成功");
}
catch(Exception e)
{
e.printStackTrace() ;
}

}
public ResultSet executeQuery(String sql){
try{
conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
System.out.print("串連資料庫成功");
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println(ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql){
stmt=null;
rs=null;
try{
conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex){
System.err.println(ex.getMessage());
}

}
public void closeStmt()
{
try{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public void closeConn()
{
try{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
login_confirm.jsp代碼
<%@ page contentType="text/html; charset=gb2312" %>
<html>
<head>
<title>登入驗證</title>
</head>
<body>
<%@ page language="java" import="java.sql.*,java.util.*,java.lang.*" %>
<jsp:useBean id="connDbBean" scope="page" class="db.dbConn"/>
<%
String name1= new String(request.getParameter("user_id").getBytes("ISO-8859-1"));
String pwd1= new String(request.getParameter("password").getBytes("ISO-8859-1"));
String sql="select * from adm where name=' "+name1+" ' and password=' "
+pwd1+"'";
ResultSet rs=connDbBean.executeQuery(sql);
if(rs.next()){
rs.close();
connDbBean.closeStmt();
connDbBean.closeConn();
session.putValue("username",name1);
session.putValue("password",pwd1);
%>
<script language=javascript>
window.location="index_OK.jsp?mark=dfsd"
</script>
<% }
else{
rs.close();
connDbBean.closeStmt();
connDbBean.closeConn();
session.putValue("login_message",msg);
%>
<jsp:foward page="relogin.jsp"/>
<% } %>
</body>
</html>

問題補充：sos提交表單部分
<form action="login_confirm.jsp" method="post" name="form1">
<TD width="62" align="left"><div align="center">使用者名稱</div></td>
<td width="181"><input name="user_id" type="text" ></TD>
<TD width="48" align="left"><div align="center">密碼</div></td>
<td width="168"><input type="password" name="password" ></TD>
<td colspan=2 align="center">
<input type="button" value="登入" OnClick="submit()" size="4" ; ></td>
<td width="129" colspan="2 " align="right" ><a href="register.jsp">
<input type="reset" value="取消" size="4" />
<span class="STYLE29">新會員註冊 </span></a></td>
</tr>
<%
String getLoginmessage=(String)session.getValue("loginSign");
if(getLoginmessage!="OK")
{
%>
<tr>
<td colspan=2>
<div align="center"></div>
</td>
</tr>
<%
}
else{
%>
<tr>
<td colspan=2 align="center">
<a href="change_infor.jsp">修改
</a>
</td>
</tr>
<%
}
%>

</table>
</form>
</div>
</body>
</html>

本文章原先以中文撰寫並發佈於 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