网上名片管理系统
题目
设计一个网上名片管理系统,实现名片的增、删、改、查等操作。该系统包括如下功能:
1.名片信息显示
2.查询名片
3.添加名片
4.删除名片
5.添加名片
代码
建表
CREATE TABLE stu(
id INT,
name VARCHAR(20),
password INT,
sex VARCHAR(15),
age INT,
work VARCHAR(20)
);
stu表的信息如下:
页面设计
index.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>网上名片管理系统</title>
</head>
<frameset rows="80,*">
<frame src="index_title.jsp" scrolling="no">
<frameset cols="140,*">
<frame src="index_left.jsp" scrolling="no">
<frame src="index_right.jsp" scrolling="no" name="right">
</frameset>
</frameset>
</html>
index_left.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>菜单列表</title>
</head>
<body>
<p><a href = "find_1.jsp" target = "right">查看全部名片</a></p>
<p><a href = "find_3_tijiao.jsp" target = "right">查询名片</a></p>
<p><a href = "insert_2_tijiao.jsp" target = "right">添加名片</a></p>
<p><a href = "delete_2_tijiao.jsp" target = "right">删除名片</a></p>
<p><a href = "update_2_tijiao.jsp" target = "right">修改名片</a></p>
</html>
index_right.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>信息显示页面</title>
</head>
<body>
</body>
</html>
index_title.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>页面标题</title>
</head>
<body>
<center><h1>网上名片管理系统</h1></center>
</body>
</html>
查询名片
find_1.jsp:
<%@ page contentType = "text/html" language="java" import="java.sql.*" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>显示所有名片信息</title>
</head>
<body>
<center>
<%
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useSSL=false&&characterEncoding=utf-8";
Connection conn = DriverManager.getConnection(url,"root","123456");
//String driverName = "com.mysql.jdbc.Driver";//MySQL数据库驱动程序名
//String userName = "root";//数据库用户名
//String userPwd = "123465";//密码
//String dbName = "test";//数据库名
//String url1 = "jdbc:mysql://localhost:3306" + dbName;
//String url2 = "?user=" + userName + "&password=" + userPwd;
//String url3 = "&useUnicode=true&characterEncoding=UTF-8";
//String url = url1 + url2 + url3;
//Class.forName(driverName);
//Connection conn = DriverManager.getConnection(url);
String sql = "select * from stu";
request.setCharacterEncoding("UTF-8");
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
rs.last();//移至最后一条记录
%>
名片信息共有:
<font size = "5"color = "red"><%=rs.getRow() %></font>个
<table border = "2" bgcolor = "ccceee" width = "650">
<tr bgcolor = "CCCCCC" align = "center">
<td>序号</td>
<td>姓名</td>
<td>密码</td>
<td>性别</td>
<td>年龄</td>
<td>职业</td>
</tr>
<%
rs.beforeFirst();//移至第一条名片之前
while(rs.next()){
%>
<tr align = "center">
<td><%=rs.getInt("id")%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("password")%></td>
<td><%=rs.getString("sex")%></td>
<td><%=rs.getInt("age")%></td>
<td><%=rs.getString("work")%></td>
</tr>
<%}%>
</table>
</center>
<%
if(rs != null){
rs.close();
}
if(ps != null){
ps.close();
}
if(conn != null){
conn.close();
}
%>
</body>
</html>
find_3.jsp:
<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>获取提交页面的查询条件并实现查询的页面</title>
</head>
<body>
<center>
<%
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useSSL=false&&characterEncoding=utf-8";
Connection conn = DriverManager.getConnection(url,"root","123456");
//String driverName = "com.mysql.jdbc.Driver";//MySQL数据库驱动程序名
//String userName = "root";//数据库用户名
//String userPwd = "123465";//密码
//String dbName = "test";//数据库名
//String url1 = "jdbc:mysql://localhost:3306" + dbName;
//String url2 = "?user=" + userName + "&password=" + userPwd;
//String url3 = "&useUnicode=true&characterEncoding=UTF-8";
//String url = url1 + url2 + url3;
//Class.forName(driverName);
//Connection conn = DriverManager.getConnection(url);
request.setCharacterEncoding("UTF-8");
int n1 = Integer.parseInt(request.getParameter("a1"));
int n2 = Integer.parseInt(request.getParameter("a2"));
String sql = "select * from stu where age >= ? and age <= ?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1,n1);
ps.setInt(2,n2);
ResultSet rs = ps.executeQuery();
rs.last();//移至最后一条记录
%>
查询的名片信息如下:<br />
查询的名片信息共有<font size = "5" color = "red"><%=rs.getRow()%></font>个
<table border = "2" bgcolor = "ccceee" width = "650">
<tr bgcolor = "CCCCCC" align = "center">
<td>序号</td>
<td>姓名</td>
<td>密码</td>
<td>性别</td>
<td>年龄</td>
<td>职业</td>
</tr>
<%
rs.beforeFirst();//移至第一条记录以前
while(rs.next()){
%>
<tr align = "center">
<td><%=rs.getString("id")%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("password")%></td>
<td><%=rs.getString("sex")%></td>
<td><%=rs.getInt("age")%></td>
<td><%=rs.getString("work")%></td>
</tr>
<%}%>
</table>
</center>
<%
if(rs != null){
rs.close();
}
if(ps != null){
ps.close();
}
if(conn != null){
conn.close();
}
%>
</body>
</html>
find_3_tijiao.jsp:
<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>查询名片提交页面</title>
</head>
<body>
请选择查询条件:<hr width = "100%" size = "3">
<form action = "find_3.jsp" method = "post">
年龄范围:<p>
最小:<input type = "text" name = "a1"><br /><br />
最大:<input type = "text" name = "a2"><br /><br /></p>
<input type = "submit" value = "查询">
<input type= "reset" value = "取消">
</form>
</body>
</html>
添加名片
insert_2.jsp:
<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>添加名片</title>
</head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useSSL=false&&characterEncoding=utf-8";
Connection conn = DriverManager.getConnection(url,"root","123456");
//String driverName = "com.mysql.jdbc.Driver";//MySQL数据库驱动程序名
//String userName = "root";//数据库用户名
//String userPwd = "123465";//密码
//String dbName = "test";//数据库名
//String url1 = "jdbc:mysql://localhost:3306" + dbName;
//String url2 = "?user=" + userName + "&password=" + userPwd;
//String url3 = "&useUnicode=true&characterEncoding=UTF-8";
//String url = url1 + url2 + url3;
//Class.forName(driverName);
//Connection conn = DriverManager.getConnection(url);
String sql = "insert into stu(id,name,password,sex,age,work) value(?,?,?,?,?,?)";
request.setCharacterEncoding("UTF-8");
PreparedStatement ps = conn.prepareStatement(sql);
int id = Integer.parseInt(request.getParameter("id"));
String name = request.getParameter("name");
String password = request.getParameter("password");
String sex = request.getParameter("sex");
int age = Integer.parseInt(request.getParameter("age"));
String work = request.getParameter("work");
ps.setInt(1,id);
ps.setString(2,name);
ps.setString(3,password);
ps.setString(4,sex);
ps.setInt(5,age);
ps.setString(6,work);
int n = ps.executeUpdate();
if(n == 1){
%>
数据库插入成功!<br />
<%}
else{
%>
数据插入失败!<br />
<%}
if(ps != null){
ps.close();
}
if(conn != null){
conn.close();
}
%>
</body>
</html>
insert_2_tijiao.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>添加名片提交页面</title>
</head>
<body>
<form action = "insert_2.jsp" method = "post">
<table border = "0' width = "238" heigth = "252">
<tr>
<td>序号</td>
<td><input type = "text" name = "id"></td>
</tr>
<tr>
<td>姓名</td>
<td><input type = "text" name = "name"></td>
</tr>
<tr>
<td>密码</td>
<td><input type = "text" name = "password"></td>
</tr>
<tr>
<td>性别</td>
<td><input type = "text" name = "sex"></td>
</tr>
<tr>
<td>年龄</td>
<td><input type = "text" name = "age"></td>
</tr>
<tr>
<td>职业</td>
<td><input type = "text" name = "work"></td>
</tr>
<tr align = "center">
<td>
<input type = "submit" value = "提交" style = "background-color: chartreuse;">
<input type = "reset" value = "取消" style = "background-color : chartreuse;">
</td>
</tr>
</table>
</form>
</body>
</html>
删除名片
delete_2.jsp:
<%@ page language="java" import="java.sql.*" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>删除名片信息页面</title>
</head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useSSL=false&&characterEncoding=utf-8";
Connection conn = DriverManager.getConnection(url,"root","123456");
//String driverName = "com.mysql.jdbc.Driver";//MySQL数据库驱动程序名
//String userName = "root";//数据库用户名
//String userPwd = "123465";//密码
//String dbName = "test";//数据库名
//String url1 = "jdbc:mysql://localhost:3306" + dbName;
//String url2 = "?user=" + userName + "&password=" + userPwd;
//String url3 = "&useUnicode=true&characterEncoding=UTF-8";
//String url = url1 + url2 + url3;
//Class.forName(driverName);
//Connection conn = DriverManager.getConnection(url);
request.setCharacterEncoding("UTF-8");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String s = "1=1";
if(!name.equals(""))
s = s + " and name='"+name+"'";
if(!sex.equals(""))
s = s + " and sex='"+sex+"'";
String sql = "delete from stu where " + s;
PreparedStatement ps = conn.prepareStatement(sql);
int n = ps.executeUpdate();
if(n == 1){
%>
数据库删除操作成功!<br />
<%
}
else{
%>
数据库删除操作失败!<br />
<%
}
if(ps != null){
ps.close();
}
if(conn != null){
conn.close();
}
%>
</body>
</html>
delete_2_tijiao.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>删除条件提交页面</title>
</head>
<body>
请选择删除条件<hr width = "100%" size = "3">
<form action = "delete_2.jsp" method = "post">
姓名:<input type = "text" name = "name"><br /><br />
性别:<input type = "text" name = "sex"><br /><br />
<input type = "submit" value = "删除">
<input type = "reset" value = "取消">
</form>
</body>
</html>
修改名片
update_2_edit.jsp:
<%@ page language="java" import="java.sql.*" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>修改编辑名片页面</title>
</head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useSSL=false&&characterEncoding=utf-8";
Connection conn = DriverManager.getConnection(url,"root","123456");
//String driverName = "com.mysql.jdbc.Driver";//MySQL数据库驱动程序名
//String userName = "root";//数据库用户名
//String userPwd = "123465";//密码
//String dbName = "test";//数据库名
//String url1 = "jdbc:mysql://localhost:3306" + dbName;
//String url2 = "?user=" + userName + "&password=" + userPwd;
//String url3 = "&useUnicode=true&characterEncoding=UTF-8";
//String url = url1 + url2 + url3;
//Class.forName(driverName);
//Connection conn = DriverManager.getConnection(url);
request.setCharacterEncoding("UTF-8");
String sex = request.getParameter("sex");
String name = request.getParameter("name");
session.setAttribute("sex",sex);
session.setAttribute("name",name);
String sql = "select * from stu where sex=? and name=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,sex);
ps.setString(2,name);
ResultSet rs = ps.executeQuery();
if(rs.next()){
int id = rs.getInt("id");
String name1 = rs.getString("name");
String password = rs.getString("password");
String sex1 = rs.getString("sex");
int age = rs.getInt("age");
String work = rs.getString("work");
if(rs != null){
rs.close();
}
if(ps != null){
ps.close();
}
if(conn != null){
conn.close();
}
%>
<form action = "update_2.jsp" method = "post">
<table border = "0" width = "238" height = "252">
<tr>
<td>序号</td>
<td><input type = "text" name = "id" value = <%=id%>></td>
</tr>
<tr>
<td>姓名</td>
<td><input type = "text" name = "name1" value = <%=name1%>></td>
</tr>
<tr>
<td>密码</td>
<td><input type = "text" name = "password" value = <%=password%>></td>
</tr>
<tr>
<td>性别</td>
<td><input type = "text" name = "sex1" value = <%=sex1%>></td>
</tr>
<tr>
<td>年龄</td>
<td><input type = "text" name = "age" value = <%=age%>></td>
</tr>
<tr>
<td>职业</td>
<td><input type = "text" name = "work" value = <%=work%>></td>
</tr>
<tr align = "center">
<td colspan = "2">
<input type = "submit" value = "修改">
<input type= "reset" value = "取消">
</td>
</tr>
</table>
</form>
<%
}
else{
%>
没有找到合适条件的名片!!!
<%
if(rs != null){
rs.close();
}
if(ps != null){
ps.close();
}
if(conn != null){
conn.close();
}
}%>
</body>
</html>
update_2_tijiao.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>修改名片的条件提交页面</title>
</head>
<body>
请选择修改名片的条件:<hr width = "100%" size = "3">
<form action = "update_2_edit.jsp" method = "post">
姓名:<input type = "text" name = "name"><br /><br />
性别:<input type = "text" name = "sex"><br /><br />
<input type = "submit" value = "修改">
<input type = "reset" value = "取消">
</form>
</body>
</html>
update_2.jsp:
<%@ page language="java" import="java.util.*" import="java.sql.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>修改后重写记录页面</title>
</head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useSSL=false&&characterEncoding=utf-8";
Connection conn = DriverManager.getConnection(url,"root","123456");
//String driverName = "com.mysql.jdbc.Driver";//MySQL数据库驱动程序名
//String userName = "root";//数据库用户名
//String userPwd = "123465";//密码
//String dbName = "test";//数据库名
//String url1 = "jdbc:mysql://localhost:3306" + dbName;
//String url2 = "?user=" + userName + "&password=" + userPwd;
//String url3 = "&useUnicode=true&characterEncoding=UTF-8";
//String url = url1 + url2 + url3;
//Class.forName(driverName);
//Connection conn = DriverManager.getConnection(url);
request.setCharacterEncoding("UTF-8");
String sql = "update stu set id=?,name=?,password=?,sex=?,age=?,work=? where name=? and sex=?";
PreparedStatement ps = conn.prepareStatement(sql);
int id = Integer.parseInt(request.getParameter("id"));
String name1 = request.getParameter("name1");
String password = request.getParameter("password");
String sex1 = request.getParameter("sex1");
int age = Integer.parseInt(request.getParameter("age"));
String work = request.getParameter("work");
String name = (String)session.getAttribute("name");
String sex = (String)session.getAttribute("sex");
ps.setInt(1,id);
ps.setString(2,name1);
ps.setString(3,password);
ps.setString(4,sex1);
ps.setInt(5,age);
ps.setString(6,work);
ps.setString(7,name);
ps.setString(8,sex);
int n = ps.executeUpdate();
if(n >= 1){
%>
重写数据操作成功!<br />
<%}
else{
%>
重写数据操作失败!<br />
<%}
if(ps != null){
ps.close();
}
if(conn != null){
conn.close();
}
%>
</body>
</html>
运行效果
主页效果
查询全部名片效果
查询名片
添加名片效果
通过查询全部名片显示添加名片效果:
删除名片效果

通过查询全部名片来查看删除名片效果:
修改名片
通过查询全部名片来查看修改名片效果:
注:动态视频效果显示在上传视频中查看
备注
网上名片管理系统使用了jsp、jdbc,实现简单的增、删、改、查功能,页面设计太过粗糙简陋,后期会再次精修的。