刘雨杭jsp
package org.mbw.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.mbw.entity.Login;<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>package com.dx.DAO;
import com.dx.entity.dlBean;
import java.sql.*;
public class dlDAO {
public int insert(dlBean dlBean) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", "root", "root");
PreparedStatement preparedStatement = connection.prepareStatement("insert into dl(uname,upwd)value (?,?)");
preparedStatement.setString(1, dlBean.getUname());
preparedStatement.setString(2, dlBean.getUpwd());
Integer res = preparedStatement.executeUpdate();
return res;
}
}
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
--> public class LoginDao { public static int login(Login Login) { //boolean flag = false; int flag = -1 ; int result = -1;try { Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection(URL, USERNAME, PWD); String sql = "select count(*) from user where uname = ? and pwsd = ?"; ps = connection.prepareStatement(sql); ps.setString(1, Login.getUname()); ps.setString(2, Login.getPwsd()); rs = ps.executeQuery(); if(rs.next()) { result = rs.getInt(1); } if(result>0) { return 1; }else { return 0; } } catch (ClassNotFoundException e) { e.printStackTrace(); return -1; }catch(SQLException e) { e.printStackTrace(); return -1; }catch(Exception e) { e.printStackTrace(); return -1; }finally { try { if(rs!=null) rs.close(); if(ps!=null) rs.close(); if(connection!=null) rs.close(); }catch(SQLException e) { e.printStackTrace(); }catch(Exception e) { e.printStackTrace(); } } } } package org.mbw.entity; public class Login { private int id; private String uname; private String pwsd; public Login() { } public Login(String uname, String pwsd) { this.uname = uname; this.pwsd = pwsd; } public Login(int id, String uname, String pwsd) { this.id = id; this.uname = uname; this.pwsd = pwsd; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUname() { return uname; } public void setUname(String uname) { this.uname = uname; } public String getPwsd() { return pwsd; } public void setPwsd(String pwsd) { this.pwsd = pwsd; } } package org.mbw.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.mbw.dao.LoginDao; import org.mbw.entity.Login; public class LoginServlet extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String name = request.getParameter("uname"); String pwd = request.getParameter("upwsd"); Login login = new Login(name,pwd);//用户名,密码 int result = LoginDao.login(login); if(result>0) { response.sendRedirect("Welcome.jsp"); }else { response.sendRedirect("login.jsp"); } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }