JSP之的完美组合

精选转载

cx361 2011-12-28 23:43:46 博主文章分类：网络技术

文章标签 class private package public 完美组合 文章分类 Java 后端开发

-------------------------------------文件类-------------------------------------------

package com;

public class FirstLeveTitle {
private int id;    //序号
private String TitleName; //标题名称
private String Creator;  //创建者
private String CreateTime; //创建时间 public int getId() {
  return id; public void setId(int id) {
  this.id = id; public String getTitleName() {
  return TitleName; public void setTitleName(String titleName) {
  TitleName = titleName; public String getCreator() {
  return Creator; public void setCreator(String creator) {
  Creator = creator; public String getCreateTime() {
  return CreateTime; public void setCreateTime(String createTime) {
  CreateTime = createTime; public FirstLeveTitle(){}
public FirstLeveTitle(int id,String TitleName,String Creator,String CreateTime){
  this.id=id;
  this.TitleName=TitleName;
  this.Creator=Creator;
  this.CreateTime=CreateTime; }

-------------------------------------数据库的连接--------------------------------------

package com;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class ConnectionManager { private static final String DRIVER_CLASS="com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static final String DATABASE_URL="jdbc:sqlserver://127.0.0.1:1433;databasename=news"; private static final String DATABASE_USER="sa"; private static final String DATABASE_PASSWORD="123456"; //连接数据库的方法
public static Connection getConnection(){
  Connection dbConnection=null;
  try{
   Class.forName(DRIVER_CLASS);    dbConnection=DriverManager.getConnection(DATABASE_URL, DATABASE_USER, DATABASE_PASSWORD);   catch(Exception e){
   e.printStackTrace();   return dbConnection; //关闭数据库连接的方法
public static void closeConnection(Connection dbConnection){
  try{
   if(dbConnection!=null&&(!dbConnection.isClosed())){
    dbConnection.close();   }
  catch(SQLException sqlEx){
   sqlEx.printStackTrace(); //关闭数据集
public static void closeResultSet(ResultSet res){
  try{
   if(res!=null){
    res.close();
    res=null;   }
  catch(SQLException e){
   e.printStackTrace(); } public static void closeStatement(PreparedStatement pStatement){
  try{
   if(pStatement!=null){
    pStatement.close();
    pStatement=null;   }
  catch(SQLException e){
   e.printStackTrace(); }
}

-------------------------------------数据的全部读取【利用集合】-------------------------

package com;

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

public class NewFirstTitleDB6 { public static void main(String[] args) {
  List alltitle=getAllFirstLevelTitleList();
  System.out.println("新闻标题的总数为："+alltitle.size());
public static List getAllFirstLevelTitleList(){
  ArrayList list = new ArrayList();
  Connection dbConnection=null;
  PreparedStatement psStatement=null;
  ResultSet res=null;
  try{
   dbConnection=(Connection) ConnectionManager.getConnection();
   String strsql="select * from FirstLeveTitle order by createTime desc";
   psStatement=dbConnection.prepareStatement(strsql);
   res=psStatement.executeQuery();
   while(res.next()){
    int id =res.getInt("id");
    String title=res.getString("TitleName");
    String creator=res.getString("Creator");
    String time=res.getString("CreateTime");
    FirstLeveTitle ftitle=new FirstLeveTitle(id,title,creator,time);
    list.add(ftitle);   }
  catch(SQLException sqlE){
   sqlE.printStackTrace();   finally{
   ConnectionManager.closeConnection(dbConnection);
   ConnectionManager.closeResultSet(res);
   ConnectionManager.closeStatement(psStatement);   return list;
}