jsp servler mysql mvc 库存管理信息系统_MVC(JSP+JavaBean+Servlet)+MYSQL入门实例:实现用户登陆...

五、 在src文件夹中新建一个java包，名为myServlet

点击Finish完成创建。

六、 在myServlet包中新建两个Java文件：LoginValidate.java和LoginDBO.java

LoginValidate.java是一个Servlet，所以必须继承HttpServlet:

重写父类的doGet()和doPost()方法。

选择doGet()和doPost()方法，点击ok。

LoginValidate.java代码如下：

package myServlet;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.*;

public class LoginValidate extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

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

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

LoginDBO loginDBO=new LoginDBO();

String message =loginDBO.login(name, password);

String url="returnMessage.jsp?message="+message;

url=new String(url.getBytes("GBK"),"ISO8859_1");

response.sendRedirect(url);

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

this.doGet(request, response);

}

}

同样在myServlet包中新建一个LoginDBO.java。用来进行对数据库的操作，代码如下：

package myServlet;

import java.sql.*;

public class LoginDBO {

Connection conn;

Statement stmt;

public LoginDBO(){

try{

Class.forName("com.mysql.jdbc.Driver");

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/mvc_user","root","123");

stmt=conn.createStatement();

}catch(Exception e)

{

e.printStackTrace();

}

}

public String login(String name, String password){

String message="123";

try{

String sql1="select count(0) from user_info where user_name='"+name+"'";

ResultSet rs1=stmt.executeQuery(sql1);

if(rs1.next()){

int userCount=rs1.getInt(1);

if(0==userCount){

message="不存在该用户";

return message;

}

String sql2="select count(0) from user_info where user_name='"+name+"'and password='"+password+"'";

ResultSet rs2=stmt.executeQuery(sql2);

if(rs2.next()){

int trueUserCount=rs2.getInt(1);

if(0==trueUserCount){

message="密码错误";

return message;

}

message="成功!";

}

}

}catch(Exception e)

{

e.printStackTrace();

}

return message;

}

}

七、 最后配置web.xml文件，并发布项目，启动Tomcat，即可访问页面

Login

myServlet.LoginValidate

login

/login.do

125jz网原创文章。发布者：江山如画，转载请注明出处：http://www.125jz.com/2870.html