mysql+tomcat+jsp增删改查，不会真有人觉得mybatis很难学吧

添加学生信息

---

 学号：

 姓名：

 年龄：

 性别：男

女

 专业：

查询所有学生信息

delete.jsp

<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>

<%@ page import=“java.sql.*”%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+“😕/”+request.getServerName()+“:”+request.getServerPort()+path+“/”;

%>

   

<%

request.setCharacterEncoding(“UTF-8”);

String id = request.getParameter(“id”);

Connection conn = null;

Statement stat = null;

ResultSet rs = null;

Class.forName(“com.mysql.jdbc.Driver”);

String url = “jdbc:mysql://localhost:3306/jsp”;

String user = “root”;

String password = “root”;

conn = DriverManager.getConnection(url,user,password);

stat = conn.createStatement();

stat.executeUpdate("delete from student where id = " + id + “”);

rs = stat.executeQuery(“select * from student”);

if(rs.next())

{

out.print(“

删除成功！

”);

}

else{

out.print(“

删除失败！

”);

}

%>

返回添加信息页面 返回信息查询页面

<%

if(rs != null)

{

rs.close();

rs = null;

}

if(stat != null)

{

stat.close();

stat = null;

}

if(conn != null)

{

conn.close();

conn = null;

}

%>

index.jsp

<%@ page language=“java” import=“java.util.*” pageEncoding=“GB18030”%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+“😕/”+request.getServerName()+“:”+request.getServerPort()+path+“/”;

%>

   

点此添加学生信息

点此查询学生信息

点此修改学生信息

点此删除学生信息

insert.jsp

<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>

<%@ page import=“java.sql.*”%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+“😕/”+request.getServerName()+“:”+request.getServerPort()+path+“/”;

%>