javaweb增删改查

阅读：评论：0

javaweb增删改查

赠书 | AI专栏（AI圣经！《深度学习》中文版） 每周荐书：Kotlin、分布式、Keras（评论送书） 【获奖公布】征文 | 你会为 AI 转型么？

javaweb增删改查

2013-06-08 13:29 3322人阅读评论(0) 收藏举报分类： java Web（19）作者同类文章 X

[html] view plain copy print ?

大二下学期机考题目：基于javaweb对Address的增删改查

大二下学期机考题目：基于javaweb对Address的增删改查

Address类

[java] view plain copy print ?

package entity;
public class Address{
private int id;
private String name;
private String street;
private String city;
private String state;
private String zip;
public int getId(){
return id;
}
public void setId(int id){
this.id = id;
}
public String getName(){
return name;
}
public void setName(String name){
this.name = name;
}
public String getStreet(){
return street;
}
public void setStreet(String street){
this.street = street;
}
public String getCity(){
return city;
}
public void setCity(String city){
this.city = city;
}
public String getState(){
return state;
}
public void setState(String state){
this.state = state;
}
public String getZip(){
return zip;
}
public void setZip(String zip){
this.zip = zip;
}
}

package entity;public class Address{private int id;private String name;private String street;private String city;private String state;private String zip;public int getId(){return id;}public void setId(int id){this.id = id;}public String getName(){return name;}public void setName(String name){this.name = name;}public String getStreet(){return street;}public void setStreet(String street){this.street = street;}public String getCity(){return city;}public void setCity(String city){this.city = city;}public String getState(){return state;}public void setState(String state){this.state = state;}public String getZip(){return zip;}public void setZip(String zip){this.zip = zip;}
}

工具类

[java] view plain copy print ?

package util;
import java.sql.*;
public class JdbcUtil{
static{
try{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName(&#sql.jdbc.Driver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException{
//return Connection("jdbc:odbc:address");
return Connection("jdbc:mysql://localhost:3306/address?user=root&password=root&characterEncoding=utf-8");
}
public static void close(Statement stmt,Connection conn)throws SQLException{
stmt.close();
conn.close();
}
public static void close(ResultSet rs,Statement stmt,Connection conn)throws SQLException{
rs.close();
close(stmt,conn);
}
}

package util;import java.sql.*;public class JdbcUtil{static{try{//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Class.forName(&#sql.jdbc.Driver");}catch(ClassNotFoundException e){e.printStackTrace();}}public static Connection getConnection() throws SQLException{//Connection("jdbc:odbc:address");Connection("jdbc:mysql://localhost:3306/address?user=root&password=root&characterEncoding=utf-8");}public static void close(Statement stmt,Connection conn)throws SQLException{stmt.close();conn.close();}public static void close(ResultSet rs,Statement stmt,Connection conn)throws SQLException{rs.close();close(stmt,conn);}}

dao包

[java] view plain copy print ?

//DAO:Data Access Object,Design Pattern设计模式
package dao;
import java.sql.*;
import java.util.*;
import entity.*;
import util.*;
public class AddressDao{
public void add(Address address){
try{
Connection conn = Connection();
PreparedStatement pstmt = conn.prepareStatement("insert into address (name,street,city,state,zip) values (?,?,?,?,?)");
pstmt.setString(Name());
pstmt.setString(Street());
pstmt.setString(City());
pstmt.setString(State());
pstmt.setString(Zip());
uteUpdate();
JdbcUtil.close(pstmt,conn);
}catch(SQLException e){
e.printStackTrace();
throw new RuntimeException(e);
}
}
public void delete(int id){
try{
Connection conn = Connection();
PreparedStatement pstmt = conn.prepareStatement("delete from address where id =?");
pstmt.setInt(1,id);
uteUpdate();
JdbcUtil.close(pstmt,conn);
}catch(SQLException e){
e.printStackTrace();
throw new RuntimeException(e);
}
}
public void update(Address address){
try{
Connection conn = Connection();
PreparedStatement pstmt = conn.prepareStatement("update address set name=?,street=?,city=?,state=?,zip=? where id=?");
pstmt.setString(Name());
pstmt.setString(Street());
pstmt.setString(City());
pstmt.setString(State());
pstmt.setString(Zip());
pstmt.setInt(Id());
uteUpdate();
JdbcUtil.close(pstmt,conn);
}catch(SQLException e){
e.printStackTrace();
throw new RuntimeException(e);
}
}
public List<Address> findAll(){
List<Address> list = new ArrayList<Address>();
try{
Connection conn = Connection();
PreparedStatement pstmt = conn.prepareStatement("select * from address");
ResultSet rs = uteQuery();
()){
Address address = new Address();
address.Int(1));
address.String(2));
address.String(3));
address.String(4));
address.String(5));
address.String(6));
list.add(address);
}
JdbcUtil.close(pstmt,conn);
}catch(SQLException e){
e.printStackTrace();
throw new RuntimeException(e);
}
return list;
}
public Address findById(int id){
Address address = new Address();
try{
Connection conn = Connection();
PreparedStatement pstmt = conn.prepareStatement("select * from address where id=?");
pstmt.setInt(1,id);
ResultSet rs = uteQuery();
()){
address.Int(1));
address.String(2));
address.String(3));
address.String(4));
address.String(5));
address.String(6));
}
JdbcUtil.close(pstmt,conn);
}catch(SQLException e){
e.printStackTrace();
throw new RuntimeException(e);
}
return address;
}
}

//DAO:Data Access Object,Design Pattern设计模式
package dao;import java.sql.*;
import java.util.*;import entity.*;
import util.*;public class AddressDao{public void add(Address address){try{Connection conn = Connection();PreparedStatement pstmt = conn.prepareStatement("insert into address (name,street,city,state,zip) values (?,?,?,?,?)");pstmt.setString(Name());pstmt.setString(Street());pstmt.setString(City());pstmt.setString(State());pstmt.setString(Zip());uteUpdate();JdbcUtil.close(pstmt,conn);}catch(SQLException e){e.printStackTrace();throw new RuntimeException(e);}}public void delete(int id){try{Connection conn = Connection();PreparedStatement pstmt = conn.prepareStatement("delete from address where id =?");pstmt.setInt(1,id);uteUpdate();JdbcUtil.close(pstmt,conn);}catch(SQLException e){e.printStackTrace();throw new RuntimeException(e);}}public void update(Address address){try{Connection conn = Connection();PreparedStatement pstmt = conn.prepareStatement("update address set name=?,street=?,city=?,state=?,zip=? where id=?");pstmt.setString(Name());pstmt.setString(Street());pstmt.setString(City());pstmt.setString(State());pstmt.setString(Zip());pstmt.setInt(Id());uteUpdate();JdbcUtil.close(pstmt,conn);}catch(SQLException e){e.printStackTrace();throw new RuntimeException(e);}}public List<Address> findAll(){List<Address> list = new ArrayList<Address>();try{Connection conn = Connection();PreparedStatement pstmt = conn.prepareStatement("select * from address");ResultSet rs = uteQuery();()){Address address = new Address();address.Int(1));address.String(2));address.String(3));address.String(4));address.String(5));address.String(6));list.add(address);}JdbcUtil.close(pstmt,conn);}catch(SQLException e){e.printStackTrace();throw new RuntimeException(e);}return list;}public Address findById(int id){Address address = new Address();try{Connection conn = Connection();PreparedStatement pstmt = conn.prepareStatement("select * from address where id=?");pstmt.setInt(1,id);ResultSet rs = uteQuery();()){address.Int(1));address.String(2));address.String(3));address.String(4));address.String(5));address.String(6));}JdbcUtil.close(pstmt,conn);}catch(SQLException e){e.printStackTrace();throw new RuntimeException(e);}return address;}	
}

首先在首页index.jsp文件中定向到AddressServlet类中

[html] view plain copy print ?

<html>
<head>
<title>My JSP 'index.jsp' starting page</title>
</head>
<body>
<jsp:forward page="AddressServlet?method=list"/>
</body>
</html>

<html><head><title>My JSP 'index.jsp' starting page</title></head><body><jsp:forward page="AddressServlet?method=list"/></body>
</html>

AddressServlet类负责处理底层数据

[html] view plain copy print ?

package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import dao.AddressDao;
import entity.Address;
public class AddressServlet extends HttpServlet {
private AddressDao addressDao = new AddressDao();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String method = Parameter("method");
String path="list.jsp";
if(method.equals("list")){
List<Address> list = addressDao.findAll();
request.setAttribute("list", list);
}else if(method.equals("add")){
String name = Parameter("name");
String street = Parameter("street");
String city = Parameter("city");
String state = Parameter("state");
String zip = Parameter("zip");
Address address = new Address();
address.setName(name);
address.setStreet(street);
address.setCity(city);
address.setState(state);
address.setZip(zip);
addressDao.add(address);
path="AddressServlet?method=list";
}else if(method.equals("delete")){
int id = Integer.Parameter("id"));
addressDao.delete(id);
path="AddressServlet?method=list";
}else if(method.equals("toedit")){
int id = Integer.Parameter("id"));
Address address = addressDao.findById(id);
request.setAttribute("address", address);
path ="edit.jsp";
}else if(method.equals("edit")){
int id = Integer.Parameter("id"));
String name = Parameter("name");
String street = Parameter("street");
String city = Parameter("city");
String state = Parameter("state");
String zip = Parameter("zip");
Address address = new Address();
address.setId(id);
address.setName(name);
address.setStreet(street);
address.setCity(city);
address.setState(state);
address.setZip(zip);
addressDao.update(address);
path="AddressServlet?method=list";
}
RequestDispatcher(path).forward(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}

package servlet;import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import dao.AddressDao;
import entity.Address;public class AddressServlet extends HttpServlet {private AddressDao addressDao = new AddressDao();   public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String method = Parameter("method");String path="list.jsp"; if(method.equals("list")){List<Address> list = addressDao.findAll();request.setAttribute("list", list);}else if(method.equals("add")){String name = Parameter("name");String street = Parameter("street");String city = Parameter("city");String state = Parameter("state");String zip = Parameter("zip");Address address = new Address();address.setName(name);address.setStreet(street);address.setCity(city);address.setState(state);address.setZip(zip);addressDao.add(address);path="AddressServlet?method=list";}else if(method.equals("delete")){int id = Integer.Parameter("id"));addressDao.delete(id);path="AddressServlet?method=list";}else if(method.equals("toedit")){int id = Integer.Parameter("id"));Address address =  addressDao.findById(id);request.setAttribute("address", address);path ="edit.jsp";}else if(method.equals("edit")){int id = Integer.Parameter("id"));String name = Parameter("name");String street = Parameter("street");String city = Parameter("city");String state = Parameter("state");String zip = Parameter("zip");Address address = new Address();address.setId(id);address.setName(name);address.setStreet(street);address.setCity(city);address.setState(state);address.setZip(zip);addressDao.update(address);path="AddressServlet?method=list";}RequestDispatcher(path).forward(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doGet(request, response);     }}

list文件显示所有信息

[html] view plain copy print ?

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@ page import="entity.Address;"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>list.jsp</title>
</head>
<body>
<table border="1">
<tr><td>Id</td><td>Name</td><td>Street</td>
<td>City</td><td>State</td><td>Zip</td><td>Option</td></tr>
<%
List<Address> list =(List<Address>)Attribute("list");
for(Address addr : list){
%>
<tr><td><%= Id() %></td><td><%= Name() %></td><td><%= Street() %></td>
<td><%= City() %></td><td><%= State() %></td><td><%= Zip() %></td>
<td><a href="AddressServlet?method=delete&id=<%= Id() %>">delete</a>
<a href="AddressServlet?method=toedit&id=<%= Id() %>">edit</a></td>
</tr>
<%
}
%>
</table>
<a href="add.jsp">Add</a>
</body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@ page import="entity.Address;"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title>list.jsp</title></head><body><table border="1"><tr><td>Id</td><td>Name</td><td>Street</td><td>City</td><td>State</td><td>Zip</td><td>Option</td></tr> <%  List<Address> list =(List<Address>)Attribute("list"); for(Address addr : list){%><tr><td><%= Id() %></td><td><%= Name() %></td><td><%= Street() %></td><td><%= City() %></td><td><%= State() %></td><td><%= Zip() %></td><td><a href="AddressServlet?method=delete&id=<%= Id() %>">delete</a>  <a href="AddressServlet?method=toedit&id=<%= Id() %>">edit</a></td></tr> <% }%></table><a href="add.jsp">Add</a></body>
</html>

add.jsp文件负责增加条目

[html] view plain copy print ?

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'index.jsp' starting page</title>
</head>
<body>
<form action="AddressServlet?method=add" method="post">
Name:<input type="text" name="name"><br>
Street:<input type="text" name="street"><br>
City:<input type="text" name="city"><br>
State:<input type="text" name="state"><br>
Zip:<input type="text" name="zip"><br>
<input type="submit" value="Add"><br>
</form>
</body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title>My JSP 'index.jsp' starting page</title></head><body><form  action="AddressServlet?method=add" method="post">Name:<input type="text" name="name"><br>Street:<input type="text" name="street"><br>City:<input type="text" name="city"><br>State:<input type="text" name="state"><br>Zip:<input type="text" name="zip"><br><input type="submit" value="Add"><br></form></body>
</html>

edit文件负责修改

[html] view plain copy print ?

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@ page import="entity.Address" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>edit.jsp</title>
</head>
<body>
<%
Address address = (Attribute("address");
%>
<form action="AddressServlet?method=edit&id=<%= Id() %>" method="post">
Name:<input type="text" name="name" value="<%= Name() %>"><br>
Street:<input type="text" name="street" value="<%= Street() %>"><br>
City:<input type="text" name="city" value="<%= City() %>"><br>
State:<input type="text" name="state" value="<%= State() %>"><br>
Zip:<input type="text" name="zip" value="<%= Zip() %>"><br>
<input type="submit" value="Edit"><br>
</form>
</body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@ page import="entity.Address" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title>edit.jsp</title></head><body><%  Address address =  (Attribute("address"); %><form  action="AddressServlet?method=edit&id=<%= Id() %>" method="post">Name:<input type="text" name="name" value="<%= Name() %>"><br>Street:<input type="text" name="street" value="<%= Street() %>"><br>City:<input type="text" name="city" value="<%= City() %>"><br>State:<input type="text" name="state" value="<%= State() %>"><br>Zip:<input type="text" name="zip" value="<%= Zip() %>"><br><input type="submit" value="Edit"><br></form></body>
</html>

顶

踩

上一篇java画直线算法 DDA 计算机图形学
下一篇【javaWeb第七天】-servlet详述