JSP+ORACLE实现登录功能
连接ORACLE数据库
1.创建数据库登录表 字段账号和密码即可先添加一条数据方便测试功能
2.导入oracle jar包到项目lib文件夹里面
package com.zking.util;
/**
* 数据库连接
*
*/
import java.net.ConnectException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import oracle.jdbc.driver.OracleDriver;
public class DBHelper {
private static final String URL="jdbc:oracle:thin:@localhost:1521:orcl";
private static final String CLASS_NAME="oracle.jdbc.driver.OracleDriver";
//代码块
static {
try {
Class.forName(CLASS_NAME);
} catch (Exception e) {
e.printStackTrace();
}
}
//创建连接
public static Connection getCon() {
Connection con=null;
try {
con=DriverManager.getConnection(URL, "scott", "tiger");//第二个参数是数据库登录账号第三个参数是数据库登录密码
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
//释放连接
public static void myClose(Connection con,PreparedStatement ps,ResultSet rs) {
try {
if(con!=null&&!con.isClosed()) {
con.close();
}
if(ps!=null) {
ps.close();
}
if(rs!=null) {
rs.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
System.out.println(DBHelper.getCon());
}
}
编写实体类
我的实体类变量应该和你的需求不一样 数据库有多少个字段实体类就写多少个变量这个得看你们自己的数据库创建表的字段
package com.zking.entity;
import java.io.Serializable;
/**
* 用户
*
*/
public class Users implements Serializable{
private int uuid;//编号
private String uname;//账号
private String upwd;//密码
private String usex;//性别
private int uage;//年龄
private String uhonney;//爱好
private String uaddress;//地址
private int upower;//权限
private String ucomment;//备注
public Users() {
// TODO Auto-generated constructor stub
}
public int getUuid() {
return uuid;
}
public void setUuid(int uuid) {
this.uuid = uuid;
}
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public String getUpwd() {
return upwd;
}
public void setUpwd(String upwd) {
this.upwd = upwd;
}
public String getUsex() {
return usex;
}
public void setUsex(String usex) {
this.usex = usex;
}
public int getUage() {
return uage;
}
public void setUage(int uage) {
this.uage = uage;
}
public String getUhonney() {
return uhonney;
}
public void setUhonney(String uhonney) {
this.uhonney = uhonney;
}
public String getUaddress() {
return uaddress;
}
public void setUaddress(String uaddress) {
this.uaddress = uaddress;
}
public int getUpower() {
return upower;
}
public void setUpower(int upower) {
this.upower = upower;
}
public String getUcomment() {
return ucomment;
}
public void setUcomment(String ucomment) {
this.ucomment = ucomment;
}
public Users(int uuid, String uname, String upwd, String usex, int uage, String uhonney, String uaddress,
int upower, String ucomment) {
super();
this.uuid = uuid;
this.uname = uname;
this.upwd = upwd;
this.usex = usex;
this.uage = uage;
this.uhonney = uhonney;
this.uaddress = uaddress;
this.upower = upower;
this.ucomment = ucomment;
}
//注册
public Users(String uname, String upwd, String usex, int uage, String uhonney, String uaddress, String ucomment) {
super();
this.uname = uname;
this.upwd = upwd;
this.usex = usex;
this.uage = uage;
this.uhonney = uhonney;
this.uaddress = uaddress;
this.ucomment = ucomment;
}
//登录
public Users(String uname, String upwd) {
super();
this.uname = uname;
this.upwd = upwd;
}
@Override
public String toString() {
return "Users [uuid=" + uuid + ", uname=" + uname + ", upwd=" + upwd + ", usex=" + usex + ", uage=" + uage
+ ", uhonney=" + uhonney + ", uaddress=" + uaddress + ", upower=" + upower + ", ucomment=" + ucomment
+ "]";
}
}
编写登录方法
/**
* 登录
* @param uname 账户
* @param upwd 密码
* @return 是否
*/
public boolean Logon(String uname,String upwd) {
boolean f=false;
try {
con=DBHelper.getCon();
sql="select * from tb_users where uname='"+uname+"' and upwd='"+upwd+"'";
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
if(rs.next()) {
f=true;
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBHelper.myClose(con, ps, rs);
}
return f;
}
编写登录jsp前端页面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<!-- 登录 -->
<form action="logonServlet.do" method="post">
<div>
账号:<input type="text" name="uname"/>
</div>
<div>
密码:<input type="password" name="upwd"/>
</div>
<div>
<button>登录</button>
<a href="index.jsp">注册</a>
</div>
</form>
</body>
</html>
编写登录servlet程序代码
package com.zking.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.zking.dao.UsersDao;
import com.zking.entity.Users;
/**
* 登录
*
*/
public class LogonServlet extends HttpServlet{
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//设置编码模式
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
//获取out对象
PrintWriter out = resp.getWriter();
//处理业务逻辑代码 登录
String uname = req.getParameter("uname");
String upwd = req.getParameter("upwd");
//调动用户登录方法
UsersDao usersdao=new UsersDao();
boolean f=usersdao.Logon(uname, upwd);
if(f) {//密码正确
out.print("<script>alert('登录成功!');location.href='登录成功后想跳转页面的名称';</script>");
}else {//密码错误
out.print("<script>alert('登录失败!');location.href='登录失败后想跳转页面的名称';</script>");
}
}
}
配置web.xml文件
<!--登录 -->
<servlet>
<servlet-name>logonServlet</servlet-name>//这个建议大家保持和登录servlet程序类名称一致首字母小写
<servlet-class>com.zking.servlet.LogonServlet</servlet-class>//这个是登录程序类完整名称(包名和登录servlet类名一致)
</servlet>
<servlet-mapping>
<servlet-name>logonServlet</servlet-name>//这个建议大家保持和登录servlet程序类名称一致首字母小写
<url-pattern>/logonServlet.do</url-pattern>//这个以/开头以.do结尾中间写的参数路径名如果是ABC路径就为ABC.do
</servlet-mapping>