利用jsp＋javalet＋jdbc技术相结合，实现基于数据库的登录验证。假设一个用户的信息有用户名和密码，用户的信息存放在数据库中。请给出分析设计过程，javabean和servlet的关键代码
如果对你有帮助记得采纳一下，谢谢~
提示：如果你是小白，别忘了替换数据库的jdbc驱动以及链接url，账号，密码哦
（1）创建ConnectDbase JavaBean，在该JavaBean 中有方法 Connection getConnect() 获得一个链接对象，其代码以下：sql
<span class="hljs-keyword">import</span> java.<span class="hljs-property">sql</span>.*;
<span class="hljs-keyword">public</span> <span class="hljs-keyword">class</span> <span class="hljs-title class_">ConnectDbase</span> {
<span class="hljs-keyword">private</span> <span class="hljs-title class_">String</span> diverName = <span class="hljs-string">"com.microsoft.sqlserver.jdbc.SQLServerDriver"</span>; <span class="hljs-comment">//驱动程序名</span>
<span class="hljs-keyword">private</span> <span class="hljs-title class_">String</span> userName = <span class="hljs-string">"sa"</span>; <span class="hljs-comment">//用户名</span>
<span class="hljs-keyword">private</span> <span class="hljs-title class_">String</span> userPwd = <span class="hljs-string">"125113jie@"</span>; <span class="hljs-comment">//密码</span>
<span class="hljs-keyword">public</span> <span class="hljs-title class_">String</span> <span class="hljs-title function_">getDiverName</span>(<span class="hljs-params"></span>){<span class="hljs-keyword">return</span> diverName;}
<span class="hljs-keyword">public</span> <span class="hljs-built_in">void</span> <span class="hljs-title function_">setDiverName</span>(<span class="hljs-params"><span class="hljs-built_in">String</span> diverName</span>){<span class="hljs-variable language_">this</span>.<span class="hljs-property">diverName</span> = diverName;}
<span class="hljs-keyword">public</span> <span class="hljs-title class_">String</span> <span class="hljs-title function_">getUserName</span>(<span class="hljs-params"></span>){<span class="hljs-keyword">return</span> userName;}
<span class="hljs-keyword">public</span> <span class="hljs-built_in">void</span> <span class="hljs-title function_">setUserName</span>(<span class="hljs-params"><span class="hljs-built_in">String</span> userName</span>){<span class="hljs-variable language_">this</span>.<span class="hljs-property">userName</span> = userName;}
<span class="hljs-keyword">public</span> <span class="hljs-title class_">String</span> <span class="hljs-title function_">getUserPwd</span>(<span class="hljs-params"></span>){<span class="hljs-keyword">return</span> userPwd;}
<span class="hljs-keyword">public</span> <span class="hljs-built_in">void</span> <span class="hljs-title function_">setUserPwd</span>(<span class="hljs-params"><span class="hljs-built_in">String</span> userPwd</span>){<span class="hljs-variable language_">this</span>.<span class="hljs-property">userPwd</span> = userPwd;}
<span class="hljs-comment">//实现数据库链接的方法</span>
<span class="hljs-keyword">public</span> <span class="hljs-title class_">Connection</span> <span class="hljs-title function_">getConnect</span>() throws SQLException,<span class="hljs-title class_">ClassNotFoundException</span>{
<span class="hljs-title class_">String</span> url1 = <span class="hljs-string">"jdbc:sqlserver://localhost:1433;DatabaseName=MOYE"</span>;
<span class="hljs-title class_">Class</span>.<span class="hljs-title function_">forName</span>(diverName);
<span class="hljs-title class_">Connection</span> conn = <span class="hljs-title class_">DriverManager</span>.<span class="hljs-title function_">getConnection</span>(url1,userName,userPwd);
<span class="hljs-keyword">return</span> conn;
}
}
（2）创建 User JavaBean。在该 JavaBean 中有两个属性，即 xm、mm，且有一个实现验证的方法 boolean yanzheng_user(String xm2,String mm2),其代码以下：
<span class="hljs-keyword">import</span> java.<span class="hljs-property">sql</span>.*;
<span class="hljs-keyword">public</span> <span class="hljs-keyword">class</span> <span class="hljs-title class_">User</span> {
<span class="hljs-keyword">private</span> <span class="hljs-title class_">String</span> xm=<span class="hljs-literal">null</span>;
<span class="hljs-keyword">private</span> <span class="hljs-title class_">String</span> mm=<span class="hljs-literal">null</span>;
<span class="hljs-keyword">public</span> <span class="hljs-title class_">String</span> <span class="hljs-title function_">getXm</span>(<span class="hljs-params"></span>){<span class="hljs-keyword">return</span> xm;}
<span class="hljs-keyword">public</span> <span class="hljs-built_in">void</span> <span class="hljs-title function_">setXm</span>(<span class="hljs-params"><span class="hljs-built_in">String</span> xm</span>){<span class="hljs-variable language_">this</span>.<span class="hljs-property">xm</span>=xm;}
<span class="hljs-keyword">public</span> <span class="hljs-title class_">String</span> <span class="hljs-title function_">getMm</span>(<span class="hljs-params"></span>){<span class="hljs-keyword">return</span> mm;}
<span class="hljs-keyword">public</span> <span class="hljs-built_in">void</span> <span class="hljs-title function_">setMm</span>(<span class="hljs-params"><span class="hljs-built_in">String</span> mm</span>){<span class="hljs-variable language_">this</span>.<span class="hljs-property">mm</span>=mm;}
<span class="hljs-keyword">public</span> <span class="hljs-title class_">User</span>(){} <span class="hljs-comment">//缺省的构造方法</span>
<span class="hljs-keyword">public</span> <span class="hljs-title class_">User</span>(<span class="hljs-title class_">String</span> a,<span class="hljs-title class_">String</span> b){ <span class="hljs-comment">//带参数的构造方法</span>
xm=a;
mm=b;
}
<span class="hljs-keyword">public</span> <span class="hljs-built_in">boolean</span> <span class="hljs-title function_">yanzheng_user</span>(<span class="hljs-title class_">String</span> xm2,<span class="hljs-title class_">String</span> mm2) <span class="hljs-comment">//断定当输入信息正确，返回true</span>
throws SQLException,<span class="hljs-title class_">ClassNotFoundException</span>{
<span class="hljs-built_in">boolean</span> f=<span class="hljs-literal">false</span>;
<span class="hljs-title class_">ConnectDbase</span> cdb = <span class="hljs-keyword">new</span> <span class="hljs-title class_">ConnectDbase</span>();
<span class="hljs-title class_">Connection</span> conn = cdb.<span class="hljs-title function_">getConnect</span>();
<span class="hljs-title class_">String</span> sql=<span class="hljs-string">"select* from moye_user where(uno=? and upwd=?)"</span>; <span class="hljs-comment">//sql语句</span>
<span class="hljs-title class_">PreparedStatement</span> pstmt = conn.<span class="hljs-title function_">prepareStatement</span>(sql);
pstmt.<span class="hljs-title function_">setString</span>(<span class="hljs-number">1</span>, xm2);
pstmt.<span class="hljs-title function_">setString</span>(<span class="hljs-number">2</span>, mm2);
<span class="hljs-title class_">ResultSet</span> rs = pstmt.<span class="hljs-title function_">executeQuery</span>(); <span class="hljs-comment">//输出结果集</span>
<span class="hljs-keyword">if</span>(rs.<span class="hljs-title function_">next</span>()) f=<span class="hljs-literal">true</span>;
<span class="hljs-keyword">else</span> f=<span class="hljs-literal">false</span>;
<span class="hljs-keyword">if</span>(rs!=<span class="hljs-literal">null</span>)rs.<span class="hljs-title function_">close</span>();
<span class="hljs-keyword">if</span>(pstmt!=<span class="hljs-literal">null</span>)pstmt.<span class="hljs-title function_">close</span>();
<span class="hljs-keyword">if</span>(conn!=<span class="hljs-literal">null</span>)conn.<span class="hljs-title function_">close</span>();
<span class="hljs-keyword">return</span> f;
}
}
（3）设计提交页面（ch07_5_tijiao.jsp）提交登陆信息，其代码以下：j
<%@<span class="hljs-built_in"> page </span><span class="hljs-attribute">language</span>=<span class="hljs-string">"java"</span> <span class="hljs-attribute">pageEncoding</span>=<span class="hljs-string">"GB2312"</span> %>
<html>
<head>
<title>用户登陆提交页面< /title>
< /head>
<body>
<form <span class="hljs-attribute">action</span>=<span class="hljs-string">"ch07_5_show.jsp"</span> <span class="hljs-attribute">method</span>=<span class="hljs-string">"post"</span>>
用 户 名：<input <span class="hljs-attribute">type</span>=<span class="hljs-string">"text"</span> <span class="hljs-attribute">name</span>=<span class="hljs-string">"xm"</span>><br><br>
用户密码：<input <span class="hljs-attribute">type</span>=<span class="hljs-string">"password"</span> <span class="hljs-attribute">name</span>=<span class="hljs-string">"mm"</span>><br><br>
<input <span class="hljs-attribute">type</span>=<span class="hljs-string">"submit"</span> <span class="hljs-attribute">value</span>=<span class="hljs-string">"登陆"</span>>
< /form>
< /body>
< /html>
（4）设计验证页面（ch07_5_show.jsp），其代码以下：
<span class="hljs-attribute"><%@ page language="java" pageEncoding="UTF-8" %></span>
<span class="hljs-attribute">< html></span>
<span class="hljs-attribute">< head></span>
<span class="hljs-attribute"><meta charset="UTF-8"></span>
<span class="hljs-attribute"><title></span>登入验证页面<span class="hljs-attribute"></ title></span>
<span class="hljs-attribute"></ head></span>
<span class="hljs-attribute"><body></span>
<span class="hljs-attribute"><% request.setCharacterEncoding("GB2312"); %></span>
<span class="hljs-attribute"><jsp:useBean id="uu" class="ch07_5.User"/></span>
<span class="hljs-attribute"><jsp:setProperty name="uu" property="*" /></span>
<span class="hljs-attribute"><% if(uu.yanzheng_user(uu.getXm(),uu.getMm())){%></span>
<span class="hljs-attribute"><%=uu.getXm() %></span>：登陆成功！<span class="hljs-attribute"><br></span>
<span class="hljs-attribute"><%}else{ %></span>
<span class="hljs-attribute"><%=uu.getXm() %></span>：登陆失败！<span class="hljs-attribute"><br></span>
<span class="hljs-attribute"><%} %></span>
<span class="hljs-attribute">< /body></span>
<span class="hljs-attribute">< /html></span>
Jsp调用登录接口，进行登录。servlet中根据用户名和密码查询是否存在该用户且密码一致，如果存在则返回1，否则返回0