mysql+tomcat+jsp增删改查（三）

作者vip1024c交流
73 阅读1分钟

out.print("" + rs.getInt("id") + "");

out.print("" + rs.getString("name") + "");

out.print("" + rs.getInt("age") + "");

out.print("" + rs.getString("gender") + "");

out.print("" + rs.getString("major") + "");

%>

">删除 ">修改

<%

out.print("");

}

%>



返回查询页面

<%

if(rs != null)

{

rs.close();

rs = null;

}

if(stat != null)

{

stat.close();

stat = null;

}

if(conn != null)

{

conn.close();

conn = null;

}

%>

select_for_gender

<%@ 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 gender = request.getParameter("gender");

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();

rs = stat.executeQuery("select * from student where gender='" + gender + "'");

%>


符合条件的学生信息


<%

while(rs.next())

{

out.print("

");

out.print("

");

out.print("

");

out.print("

");

out.print("

");

out.print("

");

%>

<%

out.print("

");

}

%>

学号姓名年龄性别专业
" + rs.getInt("id") + "" + rs.getString("name") + "" + rs.getInt("age") + "" + rs.getString("gender") + "" + rs.getString("major") + "">删除">修改


返回查询页面

<%

if(rs != null)

{

rs.close();

rs = null;

}

if(stat != null)

{

stat.close();

stat = null;

}

if(conn != null)

{

conn.close();

conn = null;

}

%>

select_for_id.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();

rs = stat.executeQuery("select * from student where id=" + id + "");

%>


符合条件的学生信息


<%

if(rs.next())

{

out.print("

");

out.print("

");

out.print("

");

out.print("

");

out.print("

");

out.print("

");

%>

<%

out.print("

");

}

else{

out.print("

不存在此条件的信息！

");

}

%>

学号姓名年龄性别专业
" + rs.getInt("id") + "" + rs.getString("name") + "" + rs.getInt("age") + "" + rs.getString("gender") + "" + rs.getString("major") + "">删除">修改


返回查询页面

<%

if(rs != null)

{

rs.close();

rs = null;

}

if(stat != null)

{

stat.close();

stat = null;

}

if(conn != null)

{

conn.close();

conn = null;

}

%>

select_for_major.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");

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

// String age=request.getParameter("age");

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

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

//major=;

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();

rs = stat.executeQuery("select * from student where major='" + major + "'");

%>


符合条件的学生信息


<%

while(rs.next())

{

out.print("

");

out.print("

");

out.print("

");

out.print("

");

out.print("

");

out.print("

");

%>

<%

out.print("

");

}

%>

学号姓名年龄性别专业
" + rs.getInt("id") + "" + rs.getString("name") + "" + rs.getInt("age") + "" + rs.getString("gender") + "" + rs.getString("major") + " ">删除">修改


返回查询页面

<%

if(rs != null)

{

rs.close();

rs = null;

}

if(stat != null)

{

stat.close();

stat = null;

}

if(conn != null)

{

conn.close();

conn = null;

}

%>

select_for_name.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 name = request.getParameter("name");

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();

rs = stat.executeQuery("select * from student where name='" + name + "'");

%>


符合条件的学生信息


<%

while(rs.next())

{

out.print("

");

out.print("

");

out.print("

");

out.print("

");

out.print("

");

out.print("

");

%>

<%

out.print("

");

}

%>

学号姓名年龄性别专业
" + rs.getInt("id") + "" + rs.getString("name") + "" + rs.getInt("age") + "" + rs.getString("gender") + "" + rs.getString("major") + "">删除">修改


返回查询页面

<%

if(rs != null)

{

rs.close();

rs = null;

}

if(stat != null)

{

stat.close();

stat = null;

}

if(conn != null)

{

conn.close();

conn = null;

}

%>

showInfo.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+"/";

%>

学生信息

   

<%

response.setCharacterEncoding("UTF-8");

request.setCharacterEncoding("UTF-8");

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

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

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

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

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

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();

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

%>


学生信息

 
   

全部学生信息如下

<%

while(rs.next())

{

学号姓名年龄性别专业
avatar
文章
阅读
粉丝