数据库连接操作(一)
- WBOY原创
- 2016-06-07 16:06:321119浏览
用纯JSP写的连接数据库操，具体包括数据查询、删除、修改，数据的添加在数据库里操作，数据库为MySQL 文件包括login.jsp,do_login.jsp(处理登录信息),index.jsp(显示登录用户名、密码和编辑删除操作),edit.jsp,do_edit.jsp,delete.jsp 登录页面 login.jsp vc
用纯JSP写的连接数据库操，具体包括数据查询、删除、修改，数据的添加在数据库里操作，数据库为MySQL
文件包括login.jsp,do_login.jsp(处理登录信息),index.jsp(显示登录用户名、密码和编辑删除操作),edit.jsp,do_edit.jsp,delete.jsp
登录页面
login.jsp喎?http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA PHByZSBjbGFzcz0="brush:sql;">2ab1cc2642648c73ea18855b07c21845 100db36a723c770d327fc0aef2ce13b1 93f0f5c25f18dab9d176bd4f6de5d30e b2386ffb911b14667cb8f0f91ea547a7登录页面6e916e0f7d1e588d4f442bf645aedb2f 9c3bca370b5104690d9ef395f2c5f8d1 6c04bd5ca3fcae76e30b72ad730ca86d 76d11bc288e4381d56dade7d2239a2a9 bacbf9e1ad7f40415ce1670e31edfee3 684271ed9684bde649abda8831d4d355欢迎注册该网站39528cedfa926ea0c01e69ef5b2ea9b0 83c862a8cdd6577575e27655a9aa01f1 f5d188ed2c074f8b944552db028f98a1 a34de1251f0d9fe1e645927f19a896e8 b6c5a531a458a2e790c1fd6421739d1c用户名b90dd5946f0946207856a8a37f441edf b6c5a531a458a2e790c1fd6421739d1cb97cf5df8b28e4a76caaaadaf8e76d05b90dd5946f0946207856a8a37f441edf fd273fcf5bcad3dfdad3c41bd81ad3e5 a34de1251f0d9fe1e645927f19a896e8 b6c5a531a458a2e790c1fd6421739d1c密码b90dd5946f0946207856a8a37f441edf b6c5a531a458a2e790c1fd6421739d1c941744aa44fdd721c0b67eb5ad94b319b90dd5946f0946207856a8a37f441edf fd273fcf5bcad3dfdad3c41bd81ad3e5 a34de1251f0d9fe1e645927f19a896e8 b6c5a531a458a2e790c1fd6421739d1cb90dd5946f0946207856a8a37f441edf b6c5a531a458a2e790c1fd6421739d1c ea734b99c21a0c29c78b18a8f0065d74 30fb92b6f220458601d91b78599af047 b90dd5946f0946207856a8a37f441edf fd273fcf5bcad3dfdad3c41bd81ad3e5 f16b1740fad44fb09bfe928bcc527e08 f5a47148e367a6035fd7a2faa965022e adca8a5fa06ffeafb062c2e3f274b930 36cc49f0c466276486e50c850b7e4956 73a6ac4ed44ffec12cee46588e518a5e do_login.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<html>
<head>
<title>登录处理页面</title>
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
response.setContentType("text/html;charset=gb2312");
String user=request.getParameter("username");
String pwd=request.getParameter("password");
final String DBDriver="com.mysql.jdbc.Driver";
final String DBUrl="jdbc:mysql://localhost:3306/mqsqltest";
final String DBUser="root";
final String DBPassword="686175";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
Class.forName(DBDriver);
conn=DriverManager.getConnection(DBUrl,DBUser,DBPassword);
String sql="select * from user where username='"+user+"'&&password='"+pwd+"'";
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
out.print("登录成功!");
response.setHeader("refresh","2;url=index.jsp");
}
else{
out.println("您登录的账号或密码错误!");
response.setHeader("refresh","2;url=login.jsp");
}
stmt.close();
conn.close();
%>
</body>
</html>
index.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<html>
<head>
<title>数据列表</title>
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
response.setContentType("text/html;charset=gb2312");
final String DBDriver="com.mysql.jdbc.Driver";
final String DBUrl="jdbc:mysql://localhost:3306/mqsqltest";
final String DBUser="root";
final String DBPassword="686175";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
Class.forName(DBDriver);
conn=DriverManager.getConnection(DBUrl,DBUser,DBPassword);
String sql="select * from user";
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
%>
<table border="1">
<tr>
<td>编号</td>
<td>帐号</td>
<td>密码</td>
<td>编辑</td>
<td>删除</td>
</tr>
<%
while(rs.next()){
%>
<tr>
<td><%=rs.getInt(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
<td><a href="edit.jsp?id=<%=rs.getInt(1)%>">更新</a></td>
<td><a href="delete.jsp?id=<%=rs.getInt(1)%>">删除</a></td>
</tr>
<%
}
stmt.close();
conn.close();
%>
</table>
</body>
</html>
编辑页面
编辑后
edit.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<html>
<head>
<title>编辑页面</title>
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
response.setContentType("text/html;charset=gb2312");
int id=Integer.parseInt(request.getParameter("id"));
session.setAttribute("id", id);
final String DBDriver="com.mysql.jdbc.Driver";
final String DBUrl="jdbc:mysql://localhost:3306/mqsqltest";
final String DBUser="root";
final String DBPassword="686175";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
Class.forName(DBDriver);
conn=DriverManager.getConnection(DBUrl,DBUser,DBPassword);
String sql="select * from user where id='"+id+"'";
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
rs.next();
%>
<center>
<h3>编辑页面</h3>
<form action="do_edit.jsp" method="post">
<table>
<tr>
<td>帐号</td>
<td><input type="text" name="username" value=<%=rs.getString(2)%>></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="password" value=<%=rs.getString(3)%>></td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" value="保存">
<input type="reset" value="取消">
</td>
</tr>
</table>
</form>
</center>
</body>
</html>
处理编辑页面
do_edit.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<%@ page import="java.util.*" %>
<html>
<head>
<title>编辑保存页面</title>
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
response.setContentType("text/html;charset=gb2312");
int id=Integer.parseInt(session.getAttribute("id").toString());
String user=request.getParameter("username");
String pwd=request.getParameter("password");
final String DBDriver="com.mysql.jdbc.Driver";
final String DBUrl="jdbc:mysql://localhost:3306/mqsqltest";
final String DBUser="root";
final String DBPassword="686175";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
Class.forName(DBDriver);
conn=DriverManager.getConnection(DBUrl,DBUser,DBPassword);
stmt=conn.createStatement();
if(user!=null&&pwd!=null){
String sql="update user set username='"+user+"',password='"+pwd+"' where id='"+id+"'";
stmt.executeUpdate(sql);
out.print("修改成功!");
response.setHeader("refresh","2;url=index.jsp");
}else{
out.print("帐号或密码不能为空!");
response.setHeader("refresh","2;url=edit.jsp");
}
%>
</body>
</html>
删除页面
delete.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<html>
<head>
<title>删除页面</title>
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
response.setContentType("text/html;charset=gb2312");
int id=Integer.parseInt(request.getParameter("id"));
final String DBDriver="com.mysql.jdbc.Driver";
final String DBUrl="jdbc:mysql://localhost:3306/mqsqltest";
final String DBUser="root";
final String DBPassword="686175";
Connection conn=null;
Statement stmt=null;
Class.forName(DBDriver);
conn=DriverManager.getConnection(DBUrl,DBUser,DBPassword);
String sql="delete from user where id='"+id+"'";
stmt=conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
out.print("删除成功!");
response.setHeader("refresh","2;url=index.jsp");
%>
</body>
</html>
在编译运行前还的将MySQL的驱动包导入WebRoot/WEB-INF/lib下