首页 > 代码库 > 数据库连接操作(一)
数据库连接操作(一)
用纯JSP写的连接数据库操，具体包括数据查询、删除、修改，数据的添加在数据库里操作，数据库为MySQL
文件包括login.jsp,do_login.jsp(处理登录信息),index.jsp(显示登录用户名、密码和编辑删除操作),edit.jsp,do_edit.jsp,delete.jsp
登录页面
login.jsp
<%@ page language="java" pageEncoding="utf-8"%>
<html>
<head>
<title>登录页面</title>
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
response.setContentType("text/html;charset=gb2312");
%>
<center>
<h3>欢迎注册该网站</h3>
<form action="do_login.jsp" method="post">
<table>
<tr>
<td>用户名</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" value=http://www.mamicode.com/"登录">>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=http://www.mamicode.com/"edit.jsp?id=">更新>编辑页面
编辑后
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=http://www.mamicode.com/>>处理编辑页面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下数据库连接操作(一)
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。