实例，JSP 连接MySQL实现增删改查，注册登录

最新推荐文章于 2024-05-27 12:05:55 发布

Tirzano

最新推荐文章于 2024-05-27 12:05:55 发布

阅读量2.7w

点赞数 37

分类专栏： jsp 文章标签： jsp mysql javaweb 实例

本文链接：https://blog.csdn.net/by2233/article/details/83425085

版权

jsp 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

简单实例JSP 连接MySQL实现增删改查，注册登录。
本文实例下载地址。
https://download.csdn.net/download/by2233/10747249
**1，运行环境MySQL5.5，Tomacat7，JDBC驱动，Eclipse Luna-SR2 **

2，环境配置

下载Java 专用的连接MySQL的驱动包mysql-connector-java-5.1.47-bin.jar。
MySQL官网可以下载，下载地址https://dev.mysql.com/downloads/connector/j/
把mysql-connector-java-x.x.x-bin.jar拷贝到Tomcat的安装bin目录。X:\XXX\Tomcat\lib下,或者直接拷进Eclipse工程WEB-INF\lib下。

3，JSP连接MySQL
建立数据库xxx，建立表xxx。
有三个列，id，username，password，类型自定义即可。
我这里用了两个表。
现在使用jsp连接mysql了。
建立一个页面userlist.jsp 。

代码如下，查询user表下所有数据

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>用户列表</title>
</head>
<body>
<% 
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/kongdechang","root","root");
Statement statement=con.createStatement();

ResultSet rs=statement.executeQuery("SELECT * FROM user");
//sql.execute("SELECT*FROM user");
//rs.next();
%>
<table border="1">
<tr><td>用户id</td><td>用户名</td><td>密码</td></tr>
<%
while(rs.next()){
	

    <tr>
        
        <td><%out.println(rs.getInt("id"));%></td>
        <td><%out.println(rs.getString("username"));%></td>
        <td><%out.println(rs.getString("password"));%></td>
     
    </tr>
<%
}

rs.close();
statement.close();
con.close();
%>
</table>
</body>
</html>

添加页面，jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>添加用户</title>
</head>
<body>
<form action="add.jsp"method="post" name="re">
			用户名<input type="text" name="name" id="name">
			<br/>
			密码&nbsp&nbsp
			<input type="password" name="pwd" id="pwd">
			<br/>
			&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
			<input type="submit"  name="Submit" value="添加" >
			</form>

</body>

</html>

添加操作

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
<% 
request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");  
String pwd = request.getParameter("pwd");
Class.forName("com.mysql.jdbc.Driver");
//桥接
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/kongdechang","root","root");
//连接数据库
String sql = "insert into admin values(null,?, ?)";

PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1,name);
ps.setString(2,pwd);
ps.executeUpdate();
con.close();
response.sendRedirect("adduser.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>删除用户</title>
</head>
<body>
<form action="delete.jsp"method="post" name="re">
            ID <input type="text" name="id" id="id" value="请输入要删除的ID">
         
			<input type="submit"  name="Submit" value="删除" >
			</form>
</body>
</html>

删除操作

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
<% 
request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");  
String pwd = request.getParameter("pwd");
String id= request.getParameter("id");
Class.forName("com.mysql.jdbc.Driver");
//桥接
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/kongdechang","root","root");
//连接数据库

String sql = "DELETE FROM `kongdechang`.`user` WHERE (`id` = ?)";
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1,id);

ps.executeUpdate();

con.close();
response.sendRedirect("deleteuser.jsp");
%>

修改页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>修改用户</title>
</head>
<body>
<form action="update.jsp"method="post" name="re">
            ID<input type="text" name="id" id="id">
            <br>
			用户名<input type="text" name="username" id="username">
			<br/>
			密码&nbsp&nbsp
			<input type="password" name="password" id="username">
			<br/>
			&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
			<input type="submit"  name="Submit" value="修改" >
			</form>

</body>

</html>

修改操作

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
<% 
request.setCharacterEncoding("utf-8");
String username = request.getParameter("username");  
String password = request.getParameter("password");
String id= request.getParameter("id");
Class.forName("com.mysql.jdbc.Driver");
//桥接
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/kongdechang","root","root");
//连接数据库

String sql = "UPDATE user SET"+" username='"+username+"',"+"password='"+password+"'"+ " WHERE (`id` = ?)";
Statement statement=con.createStatement();
//语句对象
//String sql = "select * from admin where name='"+ name +"'and pwd='"+ pwd + "'";
//ResultSet rs=statement.executeQuery(sql);
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1,id);
//ps.setString(2,username);
//ps.setString(3,password);
ps.executeUpdate();

con.close();
response.sendRedirect("updateuser.jsp");
%>

登录页面与注册

<form action="lo.jsp"method="post">
			用户名<input type="text" name="name" id="name">
			<br/>
			&nbsp密码 &nbsp<input type="password" name="pwd" id="pwd">
			<br/>
			&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
			<input type="submit"value= "登录">&nbsp&nbsp&nbsp&nbsp
			<input type="reset" value= "重  置">&nbsp&nbsp&nbsp&nbsp
			<a href="register.jsp">注册</a>
		</form>

<form action="re.jsp"method="post" name="re">
			用户名<input type="text" name="name" id="name">
			<br/>
			密码&nbsp&nbsp
			<input type="password" name="pwd" id="pwd">
			<br/>
			&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
			<input type="submit"  name="Submit" value="注册" >
			
			&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
			<input type="reset" value= "重  置">
		
			&nbsp
			<a href="login.jsp">登录</a>
		</form>

登录处理

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*"%> 
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html>
<html>
<head>  
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<head><base href="<%=basePath%>">
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");
String name = request.getParameter("name");  
String pwd =  request.getParameter("pwd");
%>
<%
Class.forName("com.mysql.jdbc.Driver");
//桥接
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/kongdechang","root","root");
//连接数据库
Statement statement=con.createStatement();
//语句对象
String sql = "select * from admin where name='"+ name +"'and pwd='"+ pwd + "'";
ResultSet rs=statement.executeQuery(sql);	
//语句对象			
if(rs.next()){
                    response.sendRedirect("loginsuccess.jsp");  
                }else{
                    response.sendRedirect("login.jsp"); 
                }
     rs.close();
     statement.close();
     con.close();

%>


</body>
</html>

注册处理

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
    
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html>
<html>
<head><base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

</head>
<body>
<% 
request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");  
String pwd = request.getParameter("pwd");
Class.forName("com.mysql.jdbc.Driver");
//桥接
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/kongdechang","root","root");
//连接数据库
String sql = "insert into admin values(null,?, ?)";

PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1,name);
ps.setString(2,pwd);
ps.executeUpdate();
con.close();
response.sendRedirect("registersuccess.jsp");
%>
</body>
</html>

Tirzano

关注

37
点赞
踩
305

收藏

觉得还不错? 一键收藏
41
评论
实例，JSP 连接MySQL实现增删改查，注册登录

简单实例JSP 连接MySQL实现增删改查，注册登录。**1，运行环境MySQL5.5，Tomacat7，JDBC驱动，Eclipse Luna-SR2 **2，环境配置下载Java 专用的连接MySQL的驱动包mysql-connector-java-5.1.47-bin.jar。MySQL官网可以下载，下载地址https://dev.mysql.com/downloads/connec...
复制链接

扫一扫

专栏目录