2.struts2 数据库里取数据

1.目录结构

2.引入的包

3.类详细

SQL语句：

drop table if exists t_project;

create table t_project(

              id int(11) NOT NULL auto_increment,

              username varchar(50) default null,

              start_date date default null,

              end_date date default null,

              primary key(id)

              )engine=InnoDB;

 

insert intot_project(username,start_date,end_date) values('ddd1','2009-08-08','2009-09-09');

insert into t_project(username,start_date,end_date)values('ddd2','2009-08-08','2009-09-09');

insert intot_project(username,start_date,end_date) values('ddd3','2009-08-08','2009-09-09');

insert intot_project(username,start_date,end_date) values('ddd4','2009-08-08','2009-09-09');

insert into t_project(username,start_date,end_date) values('ddd5','2009-08-08','2009-09-09');

 

Project.java

 

package com.hf.star.entity;

 

import java.util.Date;

 

public class Project {

    private int id;

    private String username;

    private Date   start_date;

    private Date    end_date;

    public int getId() {

       return id;

    }

    public void setId(int id) {

       this.id = id;

    }

    public String getUsername() {

       return username;

    }

    public void setUsername(String username) {

       this.username = username;

    }

    public Date getStart_date() {

       return start_date;

    }

    public void setStart_date(Date start_date) {

       this.start_date = start_date;

    }

    public Date getEnd_date() {

       return end_date;

    }

    public void setEnd_date(Date end_date) {

       this.end_date = end_date;

    }

   

}

 

 

 

ProjectDao.java

 

package com.hf.star.dao;

 

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import com.hf.star.util.*;

 

import com.hf.star.entity.Project;

 

public class ProjectDao {

    privatestatic final String findAll ="select id,username,start_date,end_date fromt_project";

   

    /*publicstatic void main(String[] args){

       ProjectDaopd = new ProjectDao();

        List<Project> list = pd.findAll();

       for(Projectp : list ){

           System.out.println(p.getUsername());

       }

    }*/

    publicList<Project> findAll(){

       Connectionconn = null;

       PreparedStatementstmt = null;

       ResultSetrs =null;

       List<Project>list= null;

       try{

           conn= ConnetionUtil.openConnection();

           stmt= conn.prepareStatement(findAll);

           rs   = stmt.executeQuery();

           list= new ArrayList<Project>();

           while(rs.next()){

              Projectproject = new Project();

              project.setId(rs.getInt(1));

              project.setUsername(rs.getString(2));

              project.setStart_date(rs.getDate(3));

              project.setEnd_date(rs.getDate(4));

              list.add(project);

           }

          

       }catch (SQLException e) {

           e.printStackTrace();

       }

      

       returnlist;

    }

   

}

 

 

Welcome.Action

 

package com.hf.star;

 

import java.util.List;

 

importcom.opensymphony.xwork2.ActionSupport;

import com.hf.star.dao.ProjectDao;

import com.hf.star.entity.*;

 

 

public class WelcomeAction extendsActionSupport{

       privateList<Project> projects;

      

       publicList<Project> getProjects() {

           returnprojects;

       }

 

       publicvoid setProjects(List<Project> projects) {

           this.projects= projects;

       }

 

       @Override

       publicString execute() throws Exception {

           ProjectDaoprojectdao = new ProjectDao();

           projects= projectdao.findAll();

           return"success";

       }

      

      

}

 

 

 

ConnectionUtil.java

 

packagecom.hf.star.util;

 

importjava.io.IOException;

importjava.util.Properties;

importjava.sql.*;

 

public classConnetionUtil {

       private static String url;

       private static String username;

       private static String password;

       private static String driver;

      

       static {

              Properties props = newProperties();

              try{

              props.load(ConnetionUtil.class.getClassLoader().getResourceAsStream("database.properties"));

              }catch(IOException e){

                     e.printStackTrace();

              }

             

              if(props !=null){

                     url=props.getProperty("url");

                     username=props.getProperty("username");

                     password=props.getProperty("password");

                     driver=props.getProperty("driver");

              }

             

              try {

                     Class.forName(driver);

              } catch (ClassNotFoundException e){

                     e.printStackTrace();

              }

       }

      

       public static Connection openConnection()throws SQLException{

              returnDriverManager.getConnection(url,username,password);

       }

      

       public void closeConnection(Connectioncon){

              if(con != null){

                     try {

                            con.close();

                     } catch (SQLException e) {

                            e.printStackTrace();

                     }

              }

       }

      

       public void closeStatement(Statementstm){

              if(stm != null){

                     try {

                            stm.close();

                     } catch (SQLException e) {

                            e.printStackTrace();

                     }

              }

       }

      

       public void closeResualtSet(ResultSetrst){

              if(rst != null){

                     try {

                            rst.close();

                     } catch (SQLException e) {

                            e.printStackTrace();

                     }

              }

             

       }

      

}

 

database.properties

 

username=root

password=123456

driver=com.mysql.jdbc.Driver

url=jdbc\:mysql\://localhost\:3306/test1

 

 

welcome.jsp

 

<%@page pageEncoding="utf-8"%>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<html>

    <head>

    </head>

   

    <body>

       <h1>

         Project list

       </h1>

      

       <table width="90%" border="2">

           <tr>

              <td>ID</td>

              <td>NAME</td>

              <td>START DATE</td>

              <td>END DATE</td>

           </tr>

           <c:forEach items ="${projects}" var="project">

              <tr>

                  <td>${project.id}</td>

                  <td>${project.username}</td>

                  <td>${project.start_date}</td>

                  <td>${project.end_date}</td>

              </tr>

           </c:forEach>

       </table>

    </body>

 

</html>