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

queryVip.jsp

pageEncoding="UTF-8"%>

数据库的增删改查

添加数据

查询用户信息

---

cellspacing="1" bgcolor="#CBD8AC" style="margin-pttom: 8px">+

ID姓名昵称电话地址学校操作

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

}

i=0;

while(i

%>

">修改|

href="delVip.jsp? id=">删除

i++;

}

rs.close();

statement.close();

connection.close();

%>

共条记录，分页显示，第页

if(intpage>1){

%>上一页

}

%>

if(intpage

%>

下一页

}

%>

}

catch(Exception e){

e.printStackTrace();

}

%>

insert.jsp

pageEncoding="UTF-8"%>

Insert title here

id号码:

姓名：

昵称：

电话:

地址:

学校:

addVip.jsp

pageEncoding="UTF-8"%>

Insert title here

添加用户

---

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) {

}

%>

编辑数据

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

My JSP 'alter.jsp' starting page

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){

}

%>

添加数据

pageEncoding="UTF-8"%>

Insert title here

添加用户

---

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) {

}

%>

查询数据：

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

My JSP 'checkUser.jsp' starting page

username:

显示查询数据

String path = request.getContextPath();

String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()

+ path + "/";

%>

My JSP 'editVip.jsp' starting page

用户名:

cellspacing="1" bgcolor="#CBD8AC" style="margin-pttom: 8px">+

ID姓名昵称电话地址学校操作

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

}

i=0;

id=String.valueOf(rs.getInt("id"));

while(i

%>

">

">

编辑| >删除

--%>

i++;

}

rs.close();

statement.close();

connection.close();

%>

共条记录，分页显示，第页

if(intpage>1){

%>上一页

}

%>

if(intpage

%>

下一页

}

%>

}

}

catch(Exception e){

e.printStackTrace();

}

%>