jsp mysql增删改查代码_java+jsp+mysql实现对数据库增删改查(无servlet)

忘是亡心i 2023-01-11 13:29 123阅读 0赞

无servelt就是连接和操作都写在jsp里面

代码：

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

学生管理系统

# 学生管理系统 #

添加学生信息

try\{

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanagement?useUnicode=true&characterEncoding=utf-8", "root","root");//使用Statement对象

Statement stmt =con.createStatement();

ResultSet rs= stmt.executeQuery("select \* from student");while(rs.next()) \{int sno = rs.getInt(1);

out.println("

" + rs.getString(1) + "" + rs.getString(2) + ""

\+ rs.getString(3) + "

" + rs.getString(4) + "" + rs.getString(5)+ " 修改  删除");

rs.close();

stmt.close();

con.close();

\}catch(Exception e) \{

out.println("Exception:" +e.getMessage());

\}%>

--------------------

style="text-align: center; width: 100%; font-size: 12px; color: \#333;">

index.jsp

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

添加图书信息

## 添加学生信息 ##

add.jsp

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

添加图书信息

String submit= request.getParameter("submit");

String sno= request.getParameter("sno");

String name= request.getParameter("name");

String gender= request.getParameter("gender");

String birthday= request.getParameter("birthday");

String address= request.getParameter("address");

Class.forName("com.mysql.jdbc.Driver");

Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanagement?useUnicode=true&characterEncoding=utf-8", "root", "root");

PreparedStatement stmt= con.prepareStatement("insert into student(sno,name,gender,birthday,address) values(?, ?, ?,?,?)");

stmt.setString(1, sno);

stmt.setString(2, name);

stmt.setString(3, gender);

stmt.setString(4, birthday);

stmt.setString(5, address);int i =stmt.executeUpdate();if (i == 1) \{

out.println("

## 添加成功！ ##

");

out.println("返回首页");

\}else\{

out.println("

## 添加失败！ ##

");

out.println("重新添加");

stmt.close();

con.close();%>

addsave.jsp

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

删除图书信息

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanagement?useUnicode=true&characterEncoding=utf-8","root","root");

Statement stmt=con.createStatement();

String id=request.getParameter("id");int i=stmt.executeUpdate("delete from student where sno="+id);if(i==1)

out.println("

## 删除成功！ ##

");

\}else\{

out.println("

## 删除失败！ ##

");

out.println("返回首页");

stmt.close();

con.close();%>

del.jsp

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

修改学生信息

String id= request.getParameter("id");

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanagement?useUnicode=true&characterEncoding=utf-8", "root","root");

PreparedStatement stmt= con.prepareStatement("select \* from student where sno=?");

stmt.setString(1, id);

ResultSet rs=stmt.executeQuery();

rs.next();%>

## 修改学生信息 ##

stmt.close();

con.close();%>

edit.jsp

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

修改完成

String sno= request.getParameter("sno");

String name= request.getParameter("name");

String gender= request.getParameter("gender");

String birthday= request.getParameter("birthday");

String address= request.getParameter("address");

Class.forName("com.mysql.jdbc.Driver");

Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanagement?useUnicode=true&characterEncoding=utf-8", "root", "root");

PreparedStatement stmt= con.prepareStatement("update student set name=?,gender=?,birthday=?,address=? where sno=?");

stmt.setString(5, sno);

stmt.setString(1, name);

stmt.setString(2, gender);

stmt.setString(3, birthday);

stmt.setString(4, address);int i =stmt.executeUpdate();if (i == 1) \{

out.println("

## 修改成功！ ##

");

out.println("返回首页");

\}else\{

out.println("

## 修改失败！ ##

");

out.println("重新添加");

stmt.close();

con.close();%>

editsave.jsp

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

error page

error.jsp

效果：

其他增删改查都一样，不再赘述

![3345cd322fe572c1a92f490efc7f79b6.png][]

[8f900a89c6347c561fdf2122f13be562.png]: /images/20221119/b6637f2e9a0a4f64870fcde230e2417c.png
[961ddebeb323a10fe0623af514929fc1.png]: https://img-blog.csdnimg.cn/img_convert/961ddebeb323a10fe0623af514929fc1.png
[3345cd322fe572c1a92f490efc7f79b6.png]: https://img-blog.csdnimg.cn/img_convert/3345cd322fe572c1a92f490efc7f79b6.png