1. 데이터베이스 만들기

데이터베이스 동물 만들기;

테이블 만들기 동물(

sno int,

이름 varchar(20),

무게 varcahr(20),

색상 varchar(20),

생년월일

);

데이터 삽입

동물 값에 삽입('1','사자','200kg','yellow','2014-07-30'),('3','tiger',' 180kg','노란색','2010-02-14'),('2','원숭이','20kg','갈색','2003-04-14'),('6','코끼리' ,'1000kg','검정색','2009-07-12'),('5','기린','700kg','노란색','2007-07-13');

picture:

2. 웹 프로젝트 만들기

lib 폴더에 5개의 패키지 가져오기:

프로젝트 이름: Animal1

프로젝트에는 세 개의 패키지가 있습니다. 엔터티 , action, util

jsp 파일: An.jsp

ConnManager.java

 1 package util; 2  3 import java.sql.Connection; 4 import java.sql.DriverManager; 5  6 public class ConnManager { 7  8     //数据库5大参数 9     private static final String IP = "127.0.0.1";10     private static final String PORT = "3306";11     private static final String DATABASE_NAME = "zhz";12     private static final String USER_NAME = "root";13     private static final String PASSWORD = "";14     private static final String DRIVER = "org.gjt.mm.mysql.Driver";15     16     public static Connection getConnection() throws Exception {17         String url = "jdbc:mysql://"+IP+":"+PORT+"/"+DATABASE_NAME+"?user="+USER_NAME+"&password="+PASSWORD+"";18         Class.forName(DRIVER);19         Connection conn = DriverManager.getConnection(url);20         return conn;21     }22 23 }

로그인 후 복사

Pig.java의 코드

 1 package entity; 2  3 import java.util.Date; 4  5 public class Pig { 6     private Integer id=null; 7     private String name=null; 8     private String weight=null; 9     private String color=null;10     private Date birth=null;11     public Integer getId() {12         return id;13     }14     public void setId(Integer id) {15         this.id = id;16     }17     public String getName() {18         return name;19     }20     public void setName(String name) {21         this.name = name;22     }23     public String getWeight() {24         return weight;25     }26     public void setWeight(String weigth) {27         this.weight = weigth;28     }29     public String getColor() {30         return color;31     }32     public void setColor(String color) {33         this.color = color;34     }35     public Date getBirth() {36         return birth;37     }38     public void setBirth(Date birth) {39         this.birth = birth;40     }41     42 }

로그인 후 복사

showPig.java 코드

rreee

An.jsp의 코드

 1 package action; 2  3 import java.io.IOException; 4 import java.sql.Connection; 5 import java.sql.PreparedStatement; 6 import java.sql.ResultSet; 7 import java.util.ArrayList; 8 import java.util.List; 9 10 import javax.servlet.ServletException;11 import javax.servlet.annotation.WebServlet;12 import javax.servlet.http.HttpServlet;13 import javax.servlet.http.HttpServletRequest;14 import javax.servlet.http.HttpServletResponse;15 16 import entity.Pig;17 import util.ConnManager;18 19 @WebServlet("/showPig")20 public class showPig extends HttpServlet {21     private static final long serialVersionUID = 1L;22       23    24     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {25         try {26             Connection conn = ConnManager.getConnection();27             String sql = "select * from animal";28             PreparedStatement ps = conn.prepareStatement(sql);29             //建立一个池，用于存放数据30             List<Pig> pigList = new ArrayList<Pig>();31             ResultSet rs = ps.executeQuery();32             while(rs.next()){34                 Integer id = rs.getInt("id");35                 String name = rs.getString("name");36                 String weight = rs.getString("weight");37                 String color = rs.getString("color");38                 java.sql.Date birth= rs.getDate("birth");39                 Pig s = new Pig();40                 s.setId(id);41                 s.setName(name);42                 s.setWeight(weight);43                 s.setColor(color);44                 s.setBirth(birth);45                 pigList.add(s);46             }47             rs.close();48             ps.close();49             conn.close();50             request.setAttribute("pigList", pigList);51             request.getRequestDispatcher("An.jsp").forward(request, response);52             53         } catch (Exception e) {54             System.out.println("发生异常"+e.getMessage());55         }56     }57 58     59     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {60         61         doGet(request, response);62     }63 64 }

로그인 후 복사