设计用于连接数据库的javabean获取数据库连接对象,将连接数据库的业务处理与jsp程序分离
1,打开IDEA,在src文件下创建bean包,然后在包下创建DBcon.java类
package bean;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBcon {
private String driverStr="com.mysql.cj.jdbc.Driver";
private String url="jdbc:mysql://localhost:3306/letterwish";
private String username="root";
private String password="2001223";
public Connection getConnction() throws ClassNotFoundException, SQLException {
Class.forName(driverStr);
return DriverManager.getConnection(url,username,password);
}
}
2,jsp板块
- 创建一个login.jsp文件
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>$Title$</title>
<link rel="stylesheet" type="text/css" href="css/login.css">
</head>
<body>
<div id="loginDiv">
<form action="checkUser.jsp" method="post" target="_blank" id="form">
<h1 style="text-align: center;color: aliceblue;">LOGIN IN</h1>
<p>User Name:<input id="userNname" type="text" name="loginname"><label id="name_trip"></label></p>
<p>Password: <input id="password" type="password" name="password"><label id="password_trip"></label></p>
<div style="text-align: center;margin-top: 30px;">
<input type="submit" class="button" value="登录" onclick="RegisterSubmit()">
<input type="reset" class="button" value="重置">
</div>
</form>
</div>
<script>
function RegisterSubmit() {
var user=document.getElementById("userNname").value;
var pass=document.getElementById("password").value;
if(user==null||user==""){alert("请填写用户名");}
else if(pass==null||pass==""){alert("请填写密码");}
else submit();
}
</script>
</body>
</html>
- 创建一个checkuser.jsp文件
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<jsp:useBean id="db" class="bean.DBcon" scope="request"></jsp:useBean>
<html>
<head>
<title>Title</title>
</head>
<body>
<%
request.setCharacterEncoding("utf-8");
String name=request.getParameter("loginname");
String password=request.getParameter("password");
%>
你输入的用户名是:<%=name%><br><br>
<%
Connection con=db.getConnction();
Statement stmt=con.createStatement();
String sql="select * from users";
sql+= " where account='"+name+"' and pwd='"+password+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
session.setAttribute("username",name);
response.sendRedirect("main.jsp");
}else{
out.print("无此用户名或密码有误,登录失败!<br><br>");
out.print("<a href='index.jsp'>重新登录<//a>");
}
%>
</body>
</html>