ora login

sammyfun

浏览: 1164445 次
性别:
来自: 西安

最近访客更多访客>>

sdwangyang

this124

单v纯微笑

yeaijun

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

basic

分类：系统运维
1 数据库：
create database student;
use student;
create table user(
id int primary key auto_increment,
user varchar(50) not null,
pwd varchar(50) not null,
name varchar(50) not null,
*** varchar(50) not null,
age int(50) not null
);

2 index.jsp

<%@ 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>
    <base href="<%=basePath%>">

    <title>欢迎来到学生管理系统</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">

</head>

<body>
    <div align="center"> <font size=" 2" color="#FF6633">用户登录</font>
</div>
<form id="form1" name="form1" method="post" action="loginServlet">
<table width="357" border="0" align="center">
    <tr>
      <td width="128">用户名：</td>
      <td width="219"><label>
        <input name="user" type="text" id="user" />
      </label></td>
    </tr>
    <tr>
      <td>密　码：</td>
      <td><label>
        <input name="pwd" type="password" id="pwd" />
      </label></td>
    </tr>
    <tr>
      <td><label>
        <input type="submit" name="Submit" value="登录" />
      </label></td>
      <td><label><a href="addUser.jsp">用户注册</a></label></td>
    </tr>
</table>
<p> </p>
</form>
</body>
</html>
3 addUser.jsp

<%@ 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>
    <base href="<%=basePath%>">

    <title>用户注册</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">


</head>

<body>
    <p align="center"><font size=" 3" color="#FF3300">用户注册</font></p>
<form id="form1" name="form1" method="post" action="addUserServlet">
<table width="340" border="0" align="center">
    <tr>
      <td width="141">用户名：</td>
      <td width="189"><label>
        <input name="user" type="text" id="user" />
      </label></td>
    </tr>
    <tr>
      <td>密码：</td>
      <td><label>
        <input name="pwd" type="password" id="pwd" />
      </label></td>
    </tr>
    <tr>
      <td>重输密码：</td>
      <td><label>
        <input name="pwd1" type="password" id="pwd1" />
      </label></td>
    </tr>
    <tr>
      <td>姓名：</td>
      <td><label>
        <input name="name" type="text" id="name" />
      </label></td>
    </tr>
    <tr>
      <td>性别：</td>
      <td><label>
        <input name="***" type="radio" value="男" checked="checked" />
      男
      <input type="radio" name="***" value="女" />
      女</label></td>
    </tr>
    <tr>
      <td>年龄：</td>
      <td><label>
        <input name="age" type="text" id="age" />
      </label></td>
    </tr>
    <tr>
      <td><label>
        <input type="submit" name="Submit" value="提交" />
      </label></td>
      <td><label>
        <input type="reset" name="Submit2" value="重置" />
      </label></td>
    </tr>
</table>
</form>
</body>
</html>

4 DAO.java 实现与数据库的连接用户名验证与用户名新建添加

package dao;

import getConnection.GetConnection;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.mysql.jdbc.ResultSet;

import bean.User;

public class Dao {
private Connection conn;
private PreparedStatement pstat;
String sql="";
/**
*
* 用户登录
*/
public boolean logoin(User user) throws SQLException{
   conn = GetConnection.getConnection();
   boolean i = false;
   sql = "select * from user where user=? and pwd=?";

   pstat = conn.prepareStatement(sql);

   pstat.setString(1, user.getUser());
   pstat.setString(2, user.getPwd());

   ResultSet rs1 = (ResultSet) pstat.executeQuery();
   if (rs1.next())
   {
    i = true;
    rs1.close();
    pstat.close();
   }
   else
   {
    i = false ;
    rs1.close();
    pstat.close();
   }
   conn.close();
   return i;
}
/**
* 用户注册
*/
public void addUser(User user){
   conn = GetConnection.getConnection();
   sql = "insert into user values(?,?,?,?,?)";
   try{
    pstat = conn.prepareStatement(sql);
    pstat.setString(1,user.getUser());
    pstat.setString(2,user.getPwd());
    pstat.setString(3,user.getName());
    pstat.setString(4,user.get***());
    pstat.setInt(5,user.getAge());
    pstat.executeUpdate();
    pstat.close();
    conn.close();

   }catch(SQLException e){
    e.printStackTrace();
   }

}
}
5 User.java

package bean;

public class User {
private String user;
private String pwd;
private String name;
private String ***;
private int age;
public String getUser() {
   return user;
}
public void setUser(String user) {
   this.user = user;
}
public String getPwd() {
   return pwd;
}
public void setPwd(String pwd) {
   this.pwd = pwd;
}
public String getName() {
   return name;
}
public void setName(String name) {
   this.name = name;
}
public String get***() {
   return ***;
}
public void set***(String ***) {
   this.*** = ***;
}
public int getAge() {
   return age;
}
public void setAge(int age) {
   this.age = age;
}
}

6 GetConnection.java 实现与数据库之间的连接

package getConnection;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
*
* 用JDBC的方法获得数据库的连接
*
*/
public class GetConnection {
//通过静态方法注册驱动，获得连接

public static Connection getConnection(){
   String driver = "com.mysql.jdbc.Driver";
   String url = "jdbc:mysql://localhost/student";
   Connection con = null;
   try {
    Class.forName(driver);
    try {
     con = DriverManager.getConnection(url,"root","");
    } catch (SQLException e) {
     e.printStackTrace();
    }
   } catch (ClassNotFoundException e) {
    e.printStackTrace();
   }
   System.out.println("已获得数据库的连接");
   return con;
}
/*public static void main(String args[]){
   getConnection();
}*/
}
7 addUserServlet.java

package 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 dao.Dao;

import bean.User;

public class addUserServlet extends HttpServlet {

/**
* Destruction of the servlet. <br>
*/
public void destroy() {
   super.destroy(); // Just puts "destroy" string in log

   // Put your code here

}

public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {

   response.setContentType("text/html");
doPost(request,response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {

   response.setContentType("text/html");
   response.setCharacterEncoding("utf-8");
   String user1 = request.getParameter("user");
   String pwd = request.getParameter("pwd");
   String name = new String(request.getParameter("name").getBytes("ISO8859_1"),"utf-8");
   String *** = new String(request.getParameter("***").getBytes("ISO8859_1"),"utf-8");
   String age1 = request.getParameter("age");
   User user = new User();
   user.setUser(user1);
   user.setPwd(pwd);
   user.setName(name);
   user.set***(***);
   int age;
   if(age1!=null)
   {
    age = Integer.parseInt(age1);
    user.setAge(age);
   }
   Dao dao = new Dao();
   dao.addUser(user);
/* request.setAttribute("info",new String("<br><br><center><h1><font color=red>添加成功！恭喜！！" +
   "</font></h1></center><br>"));
   request.setAttribute("id", new String("a"));
   request.setAttribute("denglu",new String("<br><br><center><a href = /jspDev/index.jsp target =_parent>登陆</href></center><br>"));*/

   request.getRequestDispatcher("info.jsp").forward(request,response);
}

public void init() throws ServletException {
   // Put your code here

}

}

8 loginServlet.java

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.User;
import dao.Dao;

public class loginServlet extends HttpServlet {
public void destroy() {
   super.destroy(); // Just puts "destroy" string in log

   // Put your code here

}
public void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
   request.setCharacterEncoding("utf-8");
   response.setContentType("text/html");
   PrintWriter out = response.getWriter();
   String name = new String (request.getParameter("user").getBytes("ISO8859_1"), "GBK");
   String pwd = new String (request.getParameter("pwd").getBytes("ISO8859_1"),"UTF-8");
   User user = new User();
   user.setUser(name);
   user.setPwd(pwd);
   Dao dao = new Dao();
   boolean isLogin;
   try
   {
    isLogin = dao.logoin(user);

    if(isLogin)
    {
     response.sendRedirect("MyJsp.jsp");
    }else{
     response.sendRedirect("index.jsp");
    }

   } catch (SQLException e)
   {
    e.printStackTrace();
   }
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void init() throws ServletException {
}

}

分享到：