笔记

1连接数据库：dao

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import entity.Pet;
import service.PetServiceImpl;

public class PetServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
PrintWriter out = response.getWriter();
String act=request.getParameter("act");
if("add".equals(act)){
String nc=request.getParameter("nc");
String pz=request.getParameter("pz");
String sex=request.getParameter("sex");
String csrq=request.getParameter("csrq");
String cwms=request.getParameter("cwms");
if(nc!=null && nc!="" && csrq!=null && csrq!=""){
Pet pt=new Pet();
pt.setPetName(nc);
pt.setPetBreed(Integer.parseInt(pz));
pt.setPetSex(Integer.parseInt(sex));
pt.setDescription(cwms);
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
try {
pt.setBirthday(sdf.parse(csrq));
} catch (ParseException e) {
e.printStackTrace();
}
int sum=new PetServiceImpl().add(pt);
if(sum>0){
response.sendRedirect("slet");
}else{
out.print("添加失败！！");
}
}
}else if("yz".equals(act)){
String nc=request.getParameter("nc");
String js=new PetServiceImpl().yz(nc);
out.print("{\"jyjg\":\""+js+"\"}");

}else{
String pz=request.getParameter("pz");
int sum=0;
if(pz!=null && pz!=""){
sum=Integer.parseInt(pz);
}
List<Pet> list=new PetServiceImpl().getAllorBy(sum);
request.setAttribute("Alist", list);
request.getRequestDispatcher("index.jsp").forward(request, response);
}
out.flush();
out.close();
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
doGet(request, response);

}

}

2 Dao 接口

package dao;

import java.util.List;

import entity.Pet;

public interface PetDao {
//编写查询方法，获取全部宠物信息
//编写查询方法，根据品种查询宠物信息
List<Pet> getAllorBy(int pz);

//编写增加方法，实现添加宠物功能
int add(Pet pt);

//编写验证宠物昵称的方法，实现宠物昵称唯一性判断
String yz(String nc);

}

3 dao接口实现类

package dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import entity.Pet;

public class PetDaoImpl extends BaseDao implements PetDao {

@Override
public List<Pet> getAllorBy(int pz) {
List<Pet> list=new ArrayList<Pet>();
ResultSet rs=null;
if(pz>0){
String sql="select * from pet where petBreed=?";
Object[] param={pz};
rs=exQuery(sql, param);
}else{
String sql="select * from pet";
Object[] param={};
rs=exQuery(sql, param);
}
try {
while(rs.next()){
Pet pt=new Pet();
pt.setPetId(rs.getInt("petId"));
pt.setPetName(rs.getString("petName"));
pt.setPetBreed(rs.getInt("petBreed"));
pt.setPetSex(rs.getInt("petSex"));
pt.setBirthday(rs.getDate("birthday"));
pt.setDescription(rs.getString("description"));
list.add(pt);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return list;
}

@Override
public int add(Pet pt) {
String sql="insert into pet(petName,petBreed,petSex,birthday,description) values(?,?,?,?,?)";
Object[] param={pt.getPetName(),pt.getPetBreed(),pt.getPetSex(),pt.getBirthday(),pt.getDescription()};
return exUpdate(sql, param);
}

@Override
public String yz(String nc) {
String sql="select petId from pet where petName=?";
Object[] param={nc};
ResultSet rs=exQuery(sql, param);
int sum=0;
String fhz=null;
try {
while(rs.next()){
sum++;
}
} catch (SQLException e) {
e.printStackTrace();
}

if(sum==0){
fhz="恭喜，昵称可用！";
}else{
fhz="昵称被占用，请重新更换！";
}

return fhz;
}

}

4.实体类

package entity;

import java.util.Date;

public class Pet {
private int petId;
private String petName;
private int petBreed;
private int petSex;
private Date birthday;
private String description;

public int getPetId() {
return petId;
}
public void setPetId(int petId) {
this.petId = petId;
}
public String getPetName() {
return petName;
}
public void setPetName(String petName) {
this.petName = petName;
}
public int getPetBreed() {
return petBreed;
}
public void setPetBreed(int petBreed) {
this.petBreed = petBreed;
}
public int getPetSex() {
return petSex;
}
public void setPetSex(int petSex) {
this.petSex = petSex;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}

5调用dao方法
}

package service;

import java.util.List;

import entity.Pet;

public interface PetService {
//编写查询方法，获取全部宠物信息
//编写查询方法，根据品种查询宠物信息
List<Pet> getAllorBy(int pz);

//编写增加方法，实现添加宠物功能
int add(Pet pt);

//编写验证宠物昵称的方法，实现宠物昵称唯一性判断
String yz(String nc);
}

package service;

import java.util.List;

import dao.PetDaoImpl;
import entity.Pet;

public class PetServiceImpl implements PetService {

@Override
public List<Pet> getAllorBy(int pz) {
return new PetDaoImpl().getAllorBy(pz);
}

@Override
public int add(Pet pt) {
return new PetDaoImpl().add(pt);
}

@Override
public String yz(String nc) {
return new PetDaoImpl().yz(nc);
}

}

6实现方法

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import entity.Pet;
import service.PetServiceImpl;

public class PetServlet extends HttpServlet {

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
doGet(request, response);

}

}

7显示页面

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'add.jsp'</title>
</head>

<body>

<form action="slet?act=add" method="post">
<table width="600px" border="2px">
<tr>
<td height="50" colspan="2" align="center"><h1>宠物基本信息</h1></td>
</tr>
<tr>
<td>昵称：</td>
<td><input type="text" name="nc" onblur="yz()" id="nc"><span id="yz"></span></td>
</tr>
<tr>
<td>品种：</td>
<td>
<select name="pz">
<option value="0">---请选择---</option>
<option value="1">狗</option>
<option value="2">猫</option>
<option value="3">鸟</option>
<option value="4">兔</option>
</select>
</td>
</tr>
<tr>
<td>性别：</td>
<td>
<input type="radio" name="sex" value="1" checked="checked">雄
<input type="radio" name="sex" value="2">雌
</td>
</tr>
<tr>
<td>出生日期：</td>
<td><input type="text" name="csrq"></td>
</tr>
<tr>
<td>宠物描述：</td>
<td><textarea rows="5" cols="50" name="cwms"></textarea></td>
</tr>
<tr>
<td colspan="2"><input type="submit" ></td>
</tr>
</table>

</form>
<script type="text/javascript" src="js/jquery.min63b9.js"></script>
<script >
function yz(){
var nc=$("#nc").val();
$.ajax({
url:"slet",
type:"post",
data:{
"act":"yz",
"nc":nc
},
dataType:"json",
success:function(dat){
$("#yz").html(dat.jyjg)
}
})

}
</script>
</body>
</html>

8添加

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'index.jsp' starting page</title>
</head>

<body>
<form action="slet">
<table width="600px" border="2px">
<tr>
<td>品种</td>
<td>
<select name="pz">
<option value="0">---请选择---</option>
<option value="1">狗</option>
<option value="2">猫</option>
<option value="3">鸟</option>
<option value="4">兔</option>
</select>
</td>
<td><input type="submit" value="查询"></td>
<td><a href="add.jsp">新增宠物信息</a></td>
</tr>
</table>
</form>
<br>
<table width="600px" border="2px">
<tr>
<td>宠物昵称</td>
<td>出生日期</td>
<td>性别</td>
</tr>

<c:forEach items="${Alist }" var="pt">
<tr>
<td>${pt.petName }</td>
<td>${pt.birthday }</td>
<td>
<c:if test="${pt.petSex==1 }">雄</c:if>
<c:if test="${pt.petSex==2 }">雌</c:if>
</td>
</tr>
</c:forEach>

</table>

</body>
</html>

posted @ 2020-07-21 08:39 张志文阅读(106) 评论(0) 收藏举报

刷新页面返回顶部

zhangzhiwen

笔记

笔记

公告