package edu.javaee.dao;public class TblFile {
private String FileID;
private String FileName;
private String FilePath;
private String FileType;
private String FileOwner;
private String FileSubject;
private String Created;
public String getFileID() {
return FileID;
}
public void setFileID(String fileID) {
FileID = fileID;
}
public String getFileName() {
return FileName;
}
public void setFileName(String fileName) {
FileName = fileName;
}
public String getFilePath() {
return FilePath;
}
public void setFilePath(String filePath) {
FilePath = filePath;
}
public String getFileType() {
return FileType;
}
public void setFileType(String fileType) {
FileType = fileType;
}
public String getFileOwner() {
return FileOwner;
}
public void setFileOwner(String fileOwner) {
FileOwner = fileOwner;
}
public String getFileSubject() {
return FileSubject;
}
public void setFileSubject(String fileSubject) {
FileSubject = fileSubject;
}
public String getCreated() {
return Created;
}
public void setCreated(String created) {
Created = created;
}
}package edu.javaee.dao;import java.util.List;public interface TblFileDAO {
public int upoaldFile(TblFile tf); //上传文件的接口
public List<TblFile> ListFile(); //列出上传文件
public int delFile(String id); //删除文件}package edu.javaee.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 edu.javaee.common.DBPool; public class TblFileDAOImpl implements TblFileDAO {
static DBPool pool=DBPool.getInstance();
protected Connection con=null;
protected PreparedStatement ps=null;
protected ResultSet rs=null;
public int upoaldFile(TblFile tf){ //实现上传文件的方法
int s=0;
try{
con=pool.getConnection();
ps=con.prepareStatement("insert into tblfile"+"(FileName,FilePath,FileType,FileOwner,FileSubject,FileCreated)"
+"values ('"+tf.getFileName()+"','"+tf.getFilePath()+"','"+
tf.getFileType()+"','"+tf.getFileOwner()+"','"+tf.getFileSubject()+"',now())");
s=ps.executeUpdate();
}catch(SQLException e){
e.printStackTrace();
}catch(ClassNotFoundException e){
e.printStackTrace();
}finally{
try{
ps.close();
con.close();
}catch(SQLException e){
e.printStackTrace();
}
}
return s;
}
public List<TblFile> ListFile(){
List<TblFile> res=new ArrayList<TblFile>();
try{
con=pool.getConnection();
ps=con.prepareStatement("select * from tblfile");
rs=ps.executeQuery();
while(rs.next()){
TblFile tfile=new TblFile();
tfile.setFileID(rs.getString("fileID"));
tfile.setFileName(rs.getString("fileName"));
tfile.setFilePath(rs.getString("filePath"));
tfile.setFileType(rs.getString("fileType"));
tfile.setFileOwner(rs.getString("fileOwner"));
tfile.setFileSubject(rs.getString("fileSubject"));
// tfile.setCreated(rs.getString("created"));
res.add(tfile);
}
}catch(Exception e){
e.printStackTrace();
}
finally{
try{
con.close();
rs.close();
ps.close();
}catch(Exception e){
e.printStackTrace();
}
}
return res;
}
public int delFile(String id){
int res=0;
try{
con=pool.getConnection();
ps=con.prepareStatement("delete from tblfile where fileID=?");
ps.setString(1, id);
res=ps.executeUpdate();
}catch(Exception e){
e.printStackTrace();
}finally{
try {
ps.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return res;
}
}
private String FileID;
private String FileName;
private String FilePath;
private String FileType;
private String FileOwner;
private String FileSubject;
private String Created;
public String getFileID() {
return FileID;
}
public void setFileID(String fileID) {
FileID = fileID;
}
public String getFileName() {
return FileName;
}
public void setFileName(String fileName) {
FileName = fileName;
}
public String getFilePath() {
return FilePath;
}
public void setFilePath(String filePath) {
FilePath = filePath;
}
public String getFileType() {
return FileType;
}
public void setFileType(String fileType) {
FileType = fileType;
}
public String getFileOwner() {
return FileOwner;
}
public void setFileOwner(String fileOwner) {
FileOwner = fileOwner;
}
public String getFileSubject() {
return FileSubject;
}
public void setFileSubject(String fileSubject) {
FileSubject = fileSubject;
}
public String getCreated() {
return Created;
}
public void setCreated(String created) {
Created = created;
}
}package edu.javaee.dao;import java.util.List;public interface TblFileDAO {
public int upoaldFile(TblFile tf); //上传文件的接口
public List<TblFile> ListFile(); //列出上传文件
public int delFile(String id); //删除文件}package edu.javaee.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 edu.javaee.common.DBPool; public class TblFileDAOImpl implements TblFileDAO {
static DBPool pool=DBPool.getInstance();
protected Connection con=null;
protected PreparedStatement ps=null;
protected ResultSet rs=null;
public int upoaldFile(TblFile tf){ //实现上传文件的方法
int s=0;
try{
con=pool.getConnection();
ps=con.prepareStatement("insert into tblfile"+"(FileName,FilePath,FileType,FileOwner,FileSubject,FileCreated)"
+"values ('"+tf.getFileName()+"','"+tf.getFilePath()+"','"+
tf.getFileType()+"','"+tf.getFileOwner()+"','"+tf.getFileSubject()+"',now())");
s=ps.executeUpdate();
}catch(SQLException e){
e.printStackTrace();
}catch(ClassNotFoundException e){
e.printStackTrace();
}finally{
try{
ps.close();
con.close();
}catch(SQLException e){
e.printStackTrace();
}
}
return s;
}
public List<TblFile> ListFile(){
List<TblFile> res=new ArrayList<TblFile>();
try{
con=pool.getConnection();
ps=con.prepareStatement("select * from tblfile");
rs=ps.executeQuery();
while(rs.next()){
TblFile tfile=new TblFile();
tfile.setFileID(rs.getString("fileID"));
tfile.setFileName(rs.getString("fileName"));
tfile.setFilePath(rs.getString("filePath"));
tfile.setFileType(rs.getString("fileType"));
tfile.setFileOwner(rs.getString("fileOwner"));
tfile.setFileSubject(rs.getString("fileSubject"));
// tfile.setCreated(rs.getString("created"));
res.add(tfile);
}
}catch(Exception e){
e.printStackTrace();
}
finally{
try{
con.close();
rs.close();
ps.close();
}catch(Exception e){
e.printStackTrace();
}
}
return res;
}
public int delFile(String id){
int res=0;
try{
con=pool.getConnection();
ps=con.prepareStatement("delete from tblfile where fileID=?");
ps.setString(1, id);
res=ps.executeUpdate();
}catch(Exception e){
e.printStackTrace();
}finally{
try {
ps.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return res;
}
}
解决方案 »
- 求解tomcat问题,独立运行可以,但是在eclipse或者是myeclipse运行出现问题
- MyEclipse6.0启动的奇怪问题 大家都帮我看看吧 O(∩_∩)O谢谢
- struts资源文件中的bad key该怎么定义?
- 什么ARP防火墙最好啊?
- JSP中如何改变String变量的值
- 话说springframework怎么下载
- datasource问题
- Can't resolve "Hello"...
- jsoup获取<span id="curCredit">508</span>中的508失败,只能得到--
- 为什么找不到这个类?Could not initialize class java.awt.image.BufferedImage
- 这段代码可不可以精简一下?
- 广域网上传输大文件
private String FileID;
private String FileName;
private String FilePath;
private String FileType;
private String FileOwner;
private String FileSubject;
private String Created;
public String getFileID() {
return FileID;
}
public void setFileID(String fileID) {
FileID = fileID;
}
public String getFileName() {
return FileName;
}
public void setFileName(String fileName) {
FileName = fileName;
}
public String getFilePath() {
return FilePath;
}
public void setFilePath(String filePath) {
FilePath = filePath;
}
public String getFileType() {
return FileType;
}
public void setFileType(String fileType) {
FileType = fileType;
}
public String getFileOwner() {
return FileOwner;
}
public void setFileOwner(String fileOwner) {
FileOwner = fileOwner;
}
public String getFileSubject() {
return FileSubject;
}
public void setFileSubject(String fileSubject) {
FileSubject = fileSubject;
}
public String getCreated() {
return Created;
}
public void setCreated(String created) {
Created = created;
}
} package edu.javaee.dao; import java.util.List; public interface TblFileDAO { public int upoaldFile(TblFile tf); //上传文件的接口
public List <TblFile> ListFile(); //列出上传文件
public int delFile(String id); //删除文件 } package edu.javaee.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 edu.javaee.common.DBPool; public class TblFileDAOImpl implements TblFileDAO {
static DBPool pool=DBPool.getInstance();
protected Connection con=null;
protected PreparedStatement ps=null;
protected ResultSet rs=null; public int upoaldFile(TblFile tf){ //实现上传文件的方法
int s=0;
try{
con=pool.getConnection(); //打开数据库的连接
ps=con.prepareStatement("insert into tblfile"+"(FileName,FilePath,FileType,FileOwner,FileSubject,FileCreated)"
+"values ('"+tf.getFileName()+"','"+tf.getFilePath()+"','"+
tf.getFileType()+"','"+tf.getFileOwner()+"','"+tf.getFileSubject()+"',now())"); //实现插入数据的sql语句
s=ps.executeUpdate(); //执行sql语句
}catch(SQLException e){
e.printStackTrace();
}catch(ClassNotFoundException e){
e.printStackTrace();
}finally{
try{
ps.close();
con.close();//关闭数据库连接
}catch(SQLException e){
e.printStackTrace();
}
}
return s;
} public List <TblFile> ListFile(){
List <TblFile> res=new ArrayList <TblFile>();
try{
con=pool.getConnection();
ps=con.prepareStatement("select * from tblfile"); //在tblfile表里查处文件保存信息
rs=ps.executeQuery();
while(rs.next()){
TblFile tfile=new TblFile(); //new 一个对象
tfile.setFileID(rs.getString("fileID"));
tfile.setFileName(rs.getString("fileName"));
tfile.setFilePath(rs.getString("filePath"));
tfile.setFileType(rs.getString("fileType"));
tfile.setFileOwner(rs.getString("fileOwner"));
tfile.setFileSubject(rs.getString("fileSubject")); //把查出来的信添加到新NEW的对象里去
// tfile.setCreated(rs.getString("created"));
res.add(tfile); //向数据库增加数据
}
}catch(Exception e){
e.printStackTrace();
}
finally{
try{
con.close();
rs.close();
ps.close();
}catch(Exception e){
e.printStackTrace();
}
}
return res;
} public int delFile(String id){
int res=0;
try{
con=pool.getConnection();
ps=con.prepareStatement("delete from tblfile where fileID=?");
ps.setString(1, id);
res=ps.executeUpdate();
}catch(Exception e){
e.printStackTrace();
}finally{
try {
ps.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return res;
}
}
package edu.javaee.dao;public class TblFile {
private String FileID; //文件ID
private String FileName; //文件名称
private String FilePath; //文件路径
private String FileType; //文件类型
private String FileOwner; //文件所有者
private String FileSubject; //文件主题
private String Created; //创建者 /*
* 以下是上面所述属性的get, set方法
*/
public String getFileID() {
return FileID;
} public void setFileID(String fileID) {
FileID = fileID;
} public String getFileName() {
return FileName;
} public void setFileName(String fileName) {
FileName = fileName;
} public String getFilePath() {
return FilePath;
} public void setFilePath(String filePath) {
FilePath = filePath;
} public String getFileType() {
return FileType;
} public void setFileType(String fileType) {
FileType = fileType;
} public String getFileOwner() {
return FileOwner;
} public void setFileOwner(String fileOwner) {
FileOwner = fileOwner;
} public String getFileSubject() {
return FileSubject;
} public void setFileSubject(String fileSubject) {
FileSubject = fileSubject;
} public String getCreated() {
return Created;
} public void setCreated(String created) {
Created = created;
}
}package edu.javaee.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;public class TblFileDAOImpl implements TblFileDAO { //类TblFileDAOImpl实现了接口TblFileDAO, 也必须要实现TblFileDAO所定义的方法 static DBPool pool = DBPool.getInstance(); //通过单例模式得到数据库连接池的连接
protected Connection con = null; //初始化Connection
protected PreparedStatement ps = null; //初始化预处理命令
protected ResultSet rs = null; //初始化结果集 public int upoaldFile(TblFile tf) { // 实现上传文件的方法
int s = 0;
try {
con = pool.getConnection(); //得到数据库的连接
ps = con
.prepareStatement("insert into tblfile"
+ "(FileName,FilePath,FileType,FileOwner,FileSubject,FileCreated)"
+ "values ('" + tf.getFileName() + "','"
+ tf.getFilePath() + "','" + tf.getFileType()
+ "','" + tf.getFileOwner() + "','"
+ tf.getFileSubject() + "',now())"); //执行SQL语句,插入数据
s = ps.executeUpdate(); //更新数据库中的数据
} catch (SQLException e) { //捕捉异常,处理异常
e.printStackTrace();
} catch (ClassNotFoundException e) { // 类没有找到异常. 这条语句不应该在这里写,而且没有ClassNotFoundException,不需要捕捉
e.printStackTrace(); //或者改为一般的Exception
} finally {
try {
ps.close(); //关闭ps
con.close(); //关闭连接con
} catch (SQLException e) {
e.printStackTrace();
}
}
return s; //返回结果,返回类型为int
} public List<TblFile> ListFile() { //方法的返回值为List<TblFile> 运用了范型
List<TblFile> res = new ArrayList<TblFile>(); //初始化
try {
con = pool.getConnection(); //得到连接
ps = con.prepareStatement("select * from tblfile"); //创建SQL语句
rs = ps.executeQuery(); //执行查询
while (rs.next()) { //当有数据时,循环得到结果
TblFile tfile = new TblFile(); //实例化一个类TblFile, 将结果集中的数据设定到TblFile中.
tfile.setFileID(rs.getString("fileID")); //fileID是数据库中的字段
tfile.setFileName(rs.getString("fileName"));
tfile.setFilePath(rs.getString("filePath"));
tfile.setFileType(rs.getString("fileType"));
tfile.setFileOwner(rs.getString("fileOwner"));
tfile.setFileSubject(rs.getString("fileSubject"));
// tfile.setCreated(rs.getString("created"));
res.add(tfile); //最后把TblFile的数据加入到List集合中
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
con.close();
rs.close();
ps.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return res;
} public int delFile(String id) { //执行删除操作
int res = 0;
try {
con = pool.getConnection();
ps = con.prepareStatement("delete from tblfile where fileID=?");
ps.setString(1, id); //fileID=?中的?插入id
res = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
ps.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return res; //返回int 类型
}
}