javaweb访问数据库技术(实现显示数据库数据和添加数据)

queryVip.jsp
<%@page import=“java.sql.Connection”%>
<%@page import=“java.sql.Statement”%>
<%@page import=“java.sql.ResultSet”%>
<%@page import=“java.sql.DriverManager”%>

<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>

添加数据

查询用户信息

---

+ <% ResultSet rs=null; Statement statement=null; try{ Class.forName("com.mysql.jdbc.Driver"); Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/demo", "root", "933032"); String sql="select * from vip "; statement=connection.createStatement(); rs=statement.executeQuery(sql); int pagesize,count,pageCount,intpage; String strPage; int i; pagesize=3; strPage=request.getParameter("page"); if(strPage==null){ intpage=1; }else{ intpage=Integer.parseInt(strPage); } if(intpage<1){ intpage=1; } rs.last(); count=rs.getRow(); pageCount=(count+pagesize-1)/pagesize; if(intpage>count){ intpage=count; } if(count>0){ rs.absolute((intpage-1)*pagesize+1);

ID

姓名

昵称

电话

地址

学校

操作

}
i=0;
while(i<pagesize&&!rs.isAfterLast()){
%>

<%=rs.getInt("id") %> <%=rs.getString("name") %> <%=rs.getString("nickname") %> <%=rs.getInt("phone") %> <%=rs.getString("address") %> <%=rs.getString("school") %>

%>

共<%=count %>条记录，分<%=pageCount %>页显示，第<%=intpage %>页 <% if(intpage>1){

%>上一页
<%
}
%>
<%
if(intpage<pageCount){
%>
下一页
<%
}
%>
<%
}
catch(Exception e){
e.printStackTrace();
}
%>

insert.jsp <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> id号码: 姓名： 昵称： 电话: 地址: 学校: addVip.jsp

<%@page import=“java.sql.PreparedStatement”%>
<%@page import=“java.sql.Connection”%>
<%@page import=“java.sql.Driver”%>
<%@page import=“java.sql.DriverManager”%>
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>

添加用户

---

<% int id = Integer.parseInt(request.getParameter("id")); String name = request.getParameter("name"); String nickname = request.getParameter("nickname"); int phone = Integer.parseInt(request.getParameter("phone")); String address = request.getParameter("address"); String school = request.getParameter("school"); %>

<%
try {
Driver driver = new com.mysql.jdbc.Driver();
DriverManager.registerDriver(driver);
Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost:3306/demo”, “root”,
“933032”);
String sql = “insert into vip values(?,?,?,?,?,?)”;
PreparedStatement ps = connection.prepareStatement(sql);
ps.setInt(1, id);
ps.setString(2, name);
ps.setString(3, nickname);
ps.setInt(4, phone);
ps.setString(5, address);
ps.setString(6, school);
int result = ps.executeUpdate();
if (result == 1) {
response.sendRedirect(“queryVip.jsp”);
} else {
out.print(“添加失败”);
}
} catch (Exception e) {

}
%>

编辑数据<%@page import="java.sql.Connection"%> <%@page import="java.sql.PreparedStatement"%> <%@page import="java.sql.DriverManager"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %>

<title>My JSP 'alter.jsp' starting page</title>

<%=request.getParameter("id") %> <%=request.getParameter("name") %> <%=request.getParameter("nickname") %> <%=request.getParameter("address") %> <% String name=request.getParameter("name"); String nickname=request.getParameter("nickname"); String phone=request.getParameter("phone"); int Vipid=Integer.parseInt(request.getParameter("id")); String address=request.getParameter("address"); String school=request.getParameter("school"); try{ Class.forName("com.mysql.jdbc.Driver"); Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/demo","root","933032"); String sql="update vip set name='"+name+"',nickname='"+nickname+"',phone='"+phone+"',address='"+address+"',school='"+school+"' where Id="+Integer.parseInt(request.getParameter("id")); PreparedStatement ps=connection.prepareStatement(sql); int result=ps.executeUpdate(); if(result==1){ response.sendRedirect("queryVip.jsp"); }else{ out.print("编辑失败"); } }catch(Exception e){ } %> <%=name %> <%=school %> 添加数据

<%@page import=“java.sql.PreparedStatement”%>
<%@page import=“java.sql.Connection”%>
<%@page import=“java.sql.Driver”%>
<%@page import=“java.sql.DriverManager”%>
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>

添加用户

---

<% int id = Integer.parseInt(request.getParameter("id")); String name = request.getParameter("name"); String nickname = request.getParameter("nickname"); int phone = Integer.parseInt(request.getParameter("phone")); String address = request.getParameter("address"); String school = request.getParameter("school"); %>

<%
try {
Driver driver = new com.mysql.jdbc.Driver();
DriverManager.registerDriver(driver);
Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost:3306/demo”, “root”,
“933032”);
String sql = “insert into vip values(?,?,?,?,?,?)”;
PreparedStatement ps = connection.prepareStatement(sql);
ps.setInt(1, id);
ps.setString(2, name);
ps.setString(3, nickname);
ps.setInt(4, phone);
ps.setString(5, address);
ps.setString(6, school);
int result = ps.executeUpdate();
if (result == 1) {
response.sendRedirect(“queryVip.jsp”);
} else {
out.print(“添加失败”);
}
} catch (Exception e) {

}
%>

查询数据：<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %>

<title>My JSP 'checkUser.jsp' starting page</title>

username: 显示查询数据<%@page import="java.sql.Connection"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.ResultSet"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> 用户名:

+ <% ResultSet rs = null; Statement statement = null; String id = request.getParameter("id"); int vipId = Integer.parseInt(id); try { Class.forName("com.mysql.jdbc.Driver"); Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/demo", "root", "933032"); String sql = "select * from vip where id=" + vipId; statement=connection.createStatement(); rs=statement.executeQuery(sql); String name, nickname, phone, address, school; while (rs.next()) { name = rs.getString("name"); nickname = rs.getString("nickname"); phone = rs.getString("phone"); address = rs.getString("address"); school = rs.getString("school"); request.setAttribute("name", name); request.setAttribute("nickname", nickname); request.setAttribute("phone", phone); request.setAttribute("address", address); request.setAttribute("school", school); int pagesize,count,pageCount,intpage; String strPage; int i; pagesize=3; strPage=request.getParameter("page"); if(strPage==null){ intpage=1; }else{ intpage=Integer.parseInt(strPage); } if(intpage<1){ intpage=1; } rs.last(); count=rs.getRow(); pageCount=(count+pagesize-1)/pagesize; if(intpage>count){ intpage=count; } if(count>0){ rs.absolute((intpage-1)*pagesize+1);

ID

姓名

昵称

电话

地址

学校

操作

}
i=0;
id=String.valueOf(rs.getInt(“id”));
while(i<pagesize&&!rs.isAfterLast()){
%>

<%=rs.getInt("id") %> <%=rs.getString("name") %> <%=rs.getString("nickname") %> <%=rs.getInt("phone") %> <%=rs.getString("address") %> <%=rs.getString("school") %>

<%rs.next();
i++;
}
rs.close();
statement.close();
connection.close();

%>

共<%=count %>条记录，分<%=pageCount %>页显示，第<%=intpage %>页 <% if(intpage>1){

%>上一页
<%
}
%>
<%
if(intpage<pageCount){
%>
下一页
<%
}
%>
<%
}
}
catch(Exception e){
e.printStackTrace();
}
%>