资源简介

用java编写的web物流管理系统,有数据库,页面有美化,适合学习

资源截图

代码片段和文件信息

package wuliu;
import java.sql.*;
public class conndata {
Connection conn=null;
ResultSet rs=null;
  Statement st=null;
  boolean n=false;

  public conndata() {
    try
    {
     Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver“);
    }catch(Exception e)
    {e.printStackTrace();}
  }
  public ResultSet executeQuery(String sql)
  {
    try
    {
      conn=DriverManager.getConnection(“jdbc:odbc:dbsource““sa“““);
     st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_READ_ONLY);
     rs=st.executeQuery(sql);
    }catch(SQLException e)
    {
      e.printStackTrace();
      System.out.println(“Query Exception“);
    }
return rs;
  }
  public boolean executeUpdata(String sql)
  {
  try
  {
    conn=DriverManager.getConnection(“jdbc:odbc:dbsource““sa“““);
  st=conn.createStatement();
  int m=st.executeUpdate(sql);
  n=true;
  }catch(Exception e)
  {
    n=false;
    e.printStackTrace();
    System.out.print(“Updata Exception“);
  }
  return n;
  }
  public  boolean executeInsert(String sql)
  {
    try
    {
      conn=DriverManager.getConnection(“jdbc:odbc:dbsource““sa“““);
    st=conn.createStatement();
    st.executeUpdate(sql);
    n=true;
   }catch(Exception ex)
    {
      n=false;
     ex.printStackTrace();
     System.out.println(“Insert Exception“);
    }
return n;

  }
  public boolean executeDelete(String sql)
  {
  try
  {
    conn=DriverManager.getConnection(“jdbc:odbc:dbsource““sa“““);
  st=conn.createStatement();
  st.executeUpdate(sql);
   n=true;
  }
  catch(Exception e)
  {
    n=false;
    e.printStackTrace();
    System.out.println(“Delete exception“);
  }
  return n;
  }
  public void closeConn()
  {
  try
  {
  conn.close();
  }catch(Exception e)
  {e.printStackTrace();}
  }
  public void closeStatement()
  {
  try
  {
  st.close();
  }catch(Exception e)
  {e.printStackTrace();}

  }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       3394  2006-03-30 00:52  logistics\Active\active.jsp

     文件       1682  2006-02-12 00:16  logistics\Active\activeshow.jsp

     文件       1045  2005-01-24 17:56  logistics\Active\image\banner.JPG

     文件       1045  2005-01-24 17:55  logistics\Active\image\banner1.JPG

     文件       1670  2005-01-24 17:53  logistics\Active\image\date.JPG

     文件      41708  2005-01-24 17:40  logistics\Active\image\head.gif

     文件       6984  2006-02-13 17:05  logistics\Assistant\Assistant.jsp

     文件       1045  2005-01-24 17:56  logistics\Assistant\image\banner.JPG

     文件       1045  2005-01-24 17:55  logistics\Assistant\image\banner1.JPG

     文件       1670  2005-01-24 17:53  logistics\Assistant\image\date.JPG

     文件      41708  2005-01-24 17:40  logistics\Assistant\image\head.gif

     文件       7680  2006-02-11 21:56  logistics\Assistant\image\Thumbs.db

     文件       7320  2005-01-03 18:06  logistics\Assistant\js\number.js

     文件       7746  2004-12-23 17:43  logistics\Assistant\js\road.js

     文件      11308  2005-02-09 18:15  logistics\Assistant\road.jsp

     文件        787  2006-02-11 23:38  logistics\bottom.jsp

     文件       4023  2006-02-16 00:40  logistics\Cars\CarMessage.jsp

     文件       4862  2006-02-11 21:02  logistics\Cars\CarMessageadd.jsp

     文件       1783  2006-02-10 19:23  logistics\Cars\CarMessageadd_config.jsp

     文件       4308  2006-02-17 23:37  logistics\Cars\CarMessageshow.jsp

     文件       5996  2006-02-13 21:14  logistics\Cars\CarMessage_change.jsp

     文件       2284  2006-02-10 19:24  logistics\Cars\CarMessage_change_config.jsp

     文件        612  2005-02-07 01:20  logistics\Cars\CarMessage_delete.jsp

     文件       1045  2005-01-24 17:56  logistics\Cars\image\banner.JPG

     文件       1045  2005-01-24 17:55  logistics\Cars\image\banner1.JPG

     文件       1670  2005-01-24 17:53  logistics\Cars\image\date.JPG

     文件      41708  2005-01-24 17:40  logistics\Cars\image\head.gif

     文件       1817  2005-11-11 19:04  logistics\CSS\style.css

     文件    2228224  2008-10-29 22:57  logistics\database\DB_WuLiu_Data.MDF

     文件    1048576  2008-10-29 22:57  logistics\database\DB_WuLiu_Log.LDF

............此处省略222个文件信息

评论

共有 条评论