Java Socket+mysql實現簡易檔案上傳器的代碼_java

最近跟著某網站學習了一個小項目，因為白天有課，所以都是晚上寫的，今天把它完成了。

項目主要是實現一個檔案上傳器，通過用戶端的登陸，把本地檔案上傳到伺服器的資料庫（本地的）。

首先建兩個表如下：

一個檔案資訊表

CREATE TABLE `fileinfo` ( `Fname` char(50) NOT NULL, `FInfo` blob NOT NULL, `FId` int(10) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`FId`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; 

一個使用者資訊表

CREATE TABLE `user` ( `username` char(25) NOT NULL, `password` char(25) NOT NULL, `useid` int(10) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`useid`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

User類

package fileUpload; import java.io.Serializable; /* * 使用者實體類 */ public class User implements Serializable{ private static final long serialVersionUID = -7279093338433393181L; private int useid;//使用者編號 private String usename;//使用者名稱 private String usepsd;//使用者密碼 public User(){ } public User(String usename,String usepsd){ super(); this.usename = usename; this.usepsd = usepsd; } public User(int useid,String usename,String usepsd){ super(); this.useid = useid; this.usename = usename; this.usepsd = usepsd; } public int getUseid() { return useid; } public void setUseid(int useid) { this.useid = useid; } public String getUsename() { return usename; } public void setUsename(String usename) { this.usename = usename; } public String getUsepsd() { return usepsd; } public void setUsepsd(String usepsd) { this.usepsd = usepsd; } }

UserService類

package fileUpload; /** * 使用者登陸與註冊操作類 */ import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class UserService { private Connection conn = null; private PreparedStatement ptmt = null; private ResultSet rs = null; // 使用者登入 public boolean login(User user) { String url = "jdbc:mysql://localhost:3306/fileupload";// 資料庫連接字串 String sql = "select * from user where username=? and password=?"; try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); conn = DriverManager.getConnection(url, "root", "1995520"); ptmt = conn.prepareStatement(sql); ptmt.setString(1, user.getUsename()); ptmt.setString(2, user.getUsepsd()); rs = ptmt.executeQuery(); if (rs.next()) { return true; } } catch (Exception e) { e.printStackTrace(); } finally { try { rs.close(); ptmt.close(); } catch (SQLException e) { e.printStackTrace(); } } return false; } //使用者註冊 public boolean register(User user){ System.out.println("hello"); String url = "jdbc:mysql://localhost:3306/fileupload";// 資料庫連接字串 String sql = "insert into user(username,password) values (?,?)"; try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); conn = DriverManager.getConnection(url, "root", "1995520"); ptmt = conn.prepareStatement(sql); ptmt.setString(1, user.getUsename()); ptmt.setString(2, user.getUsepsd()); ptmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); return false; } finally { try { //rs.close(); ptmt.close(); } catch (SQLException e) { e.printStackTrace(); } } return true; } }

FileIofo類

package fileUpload; import java.io.Serializable; /* * 檔案實體類 */ public class FileInfo implements Serializable{ private static final long serialVersionUID = 2554622626228481455L; private int fid;//檔案編號 private String fname;//檔案名稱 private byte[] fcontent;//檔案內容 public FileInfo(){ } public FileInfo(String fname,byte[] fcontent){ super(); this.fname = fname; this.fcontent = fcontent; } public FileInfo(int fid,String fname,byte[] fcontent){ super(); this.fid = fid; this.fname = fname; this.fcontent = fcontent; } public int getFid() { return fid; } public void setFid(int fid) { this.fid = fid; } public String getFname() { return fname; } public void setFname(String fname) { this.fname = fname; } public byte[] getFcontent() { return fcontent; } public void setFcontent(byte[] fcontent) { this.fcontent = fcontent; } }

FileService類

package fileUpload; /** * 檔案上傳操作類 */ import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class FileService { private Connection conn = null; private PreparedStatement ptmt = null; //將檔案儲存到資料庫中 public boolean save(FileInfo file){ String url = "jdbc:mysql://localhost:3306/fileupload";//資料庫連接字串 String sql = "insert into fileinfo(Fname,Finfo) value (?,?)"; try{ Class.forName("org.gjt.mm.mysql.Driver").newInstance(); conn = DriverManager.getConnection(url, "root", "1995520"); ptmt = conn.prepareStatement(sql); ptmt.setString(1, file.getFname()); ptmt.setBytes(2,file.getFcontent()); ptmt.executeUpdate(); }catch(Exception e){ e.printStackTrace(); return false; }finally{ try { ptmt.close(); } catch (SQLException e) { e.printStackTrace(); } } return true; } }

package fileUpload;

import java.io.IOException; import java.net.ServerSocket; import java.net.Socket; /* * 啟動伺服器類 */ public class StartServer { @SuppressWarnings("resource") public static void main(String[] args){ try { // 1.建立一個伺服器端Socket，即ServerSocket,指定綁定的連接埠，並監聽此連接埠 ServerSocket serverSocket = new ServerSocket(8888); Socket socket = null; System.out.println("伺服器已啟動，等待用戶端的串連..."); //迴圈監聽等待用戶端的串連 while (true) { // 2.調用accept()方法開始監聽，等待用戶端的串連 socket = serverSocket.accept(); //建立一個新的線程 ServerThread serverThread = new ServerThread(socket); //啟動線程 serverThread.start(); } } catch (IOException e) { // TODO 自動產生的 catch 塊 e.printStackTrace(); } } } [java] view plain copy 在CODE上查看代碼片派生到My Code片package fileUpload; import java.io.IOException; /** * 啟動用戶端類 */ public class StartClient { public static void main(String[] args) throws IOException{ SocketClient client = new SocketClient(); client.showMainMenu();//顯示主菜單 } }

package fileUpload;

import java.io.IOException; import java.io.ObjectInputStream; import java.io.ObjectOutputStream; import java.net.Socket; import javax.swing.JOptionPane; /* * 伺服器端多執行緒類 */ public class ServerThread extends Thread { static Socket socket = null; private static ObjectInputStream ois = null;// 對象輸入資料流 private ObjectOutputStream oos = null;// 對象輸出資料流 private UserService us = new UserService();// 使用者業務對象 private FileService fs = new FileService();// 檔案業務對象 // 通過構造方法，初始化socket public ServerThread(Socket socket) { ServerThread.socket = socket; } public void run() { try { ois = new ObjectInputStream(socket.getInputStream());//接收用戶端發來的訊息 oos = new ObjectOutputStream(socket.getOutputStream());//用來向用戶端發送訊息 CommandTransfer transfer = (CommandTransfer) ois.readObject(); // 讀取用戶端發送到伺服器的指令操作 transfer = execute(transfer); // 執行用戶端送到伺服器的指令操作 oos.writeObject(transfer);// 響應用戶端 } catch (IOException | ClassNotFoundException e) { e.printStackTrace(); } } /* * 執行用戶端發送到伺服器的指令操作 */ private CommandTransfer execute(CommandTransfer transfer) { String cmd = transfer.getCmd();// 擷取當前操作的指令 if (cmd.equals("login")) { // 使用者登入 User user =(User)transfer.getData(); boolean flag = us.login(user); if(flag) JOptionPane.showMessageDialog(null, "登陸成功！"); transfer.setFlag(flag); if(flag){//判斷登陸是否成功 transfer.setResult("登陸成功！"); }else{ transfer.setResult("使用者名稱或密碼不正確，請重新登陸！"); } }else if(cmd.equals("register")){//使用者註冊 User user = (User) transfer.getData(); us.register(user);//註冊使用者 boolean flag = us.register(user); if(flag) JOptionPane.showMessageDialog(null, "註冊成功！"); transfer.setFlag(flag); if(flag){ transfer.setResult("註冊成功！"); }else{ transfer.setResult("註冊失敗！"); } }else if(cmd.equals("uploadFile")){ FileInfo file =(FileInfo)transfer.getData(); fs.save(file); boolean flag = fs.save(file); if(flag) JOptionPane.showMessageDialog(null, "上傳成功！"); transfer.setFlag(flag); if(flag){ transfer.setResult("上傳成功！"); }else{ transfer.setResult("上傳失敗！"); } } return transfer; } } package fileUpload; import java.io.BufferedInputStream; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.ObjectInputStream; import java.io.ObjectOutputStream; import java.net.Socket; import java.net.UnknownHostException; import java.util.Scanner; /** * 主菜單類 */ public class SocketClient { Scanner input = new Scanner(System.in); private static Socket socket = null;// 用戶端Socket // 主菜單 public void showMainMenu() throws IOException { System.out.println("******歡迎使用xx檔案上傳器******"); System.out.println("1.登入\n2.註冊\n3.退出"); System.out.println("****************************"); System.out.println("請選擇："); int choice = input.nextInt();// 擷取使用者的選擇 socket = new Socket("localhost", 8888); switch (choice) { case 1: showLogin();// 登入 break; case 2: showRegister();// 註冊 break; case 3: System.out.println("歡迎你對本系統的支援"); System.exit(0); default: System.out.println("輸入有誤！"); System.exit(0); } } // 使用者註冊 private void showRegister() throws IOException { User user = new User(); CommandTransfer transfer = new CommandTransfer(); int count = 0;// 登陸次數 while (true) { count++; if (count > 3) { System.out.println("你已連續3次登陸失敗，程式退出！"); System.exit(0); } System.out.print("請輸入使用者名稱："); user.setUsename(input.next()); System.out.print("請輸入密碼："); user.setUsepsd(input.next()); System.out.print("請再次輸入密碼："); String rePassword = input.next(); if (!user.getUsepsd().equals(rePassword)) { System.out.println("兩次輸入的密碼不一致！"); System.out.println("**********************"); continue; } transfer.setCmd("register"); transfer.setData(user); try { sendData(transfer);// 將資料發送到伺服器 transfer = getData();// 擷取伺服器返回的資料 System.out.println(transfer.getResult());// 輸出顯示結果 System.out.println("*****************************"); if (transfer.isFlag()) { break;// 如果註冊成功，則不再重複執行註冊 } } catch (UnknownHostException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } finally { } } showLogin();// 註冊成功後顯示登陸 } // 獲得伺服器的資料 public static CommandTransfer getData() throws IOException { // TODO Auto-generated method stub ObjectInputStream ois = null; CommandTransfer res = null; try { if(socket.isClosed()) socket = new Socket("localhost", 8888); ois = new ObjectInputStream(socket.getInputStream()); res = (CommandTransfer) ois.readObject(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { if (ois != null) { try { ois.close(); //socket.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return res; } /* * 上傳檔案 */ private void showUploadFile() throws IOException { System.out.println("請輸入上傳檔案的絕對路徑："); String path = input.next(); FileInfo file = null; FileInputStream fis = null; BufferedInputStream bis = null; String fname = path.substring(path.lastIndexOf("/") + 1); try { fis = new FileInputStream(path); byte[] fcontent = new byte[fis.available()]; bis = new BufferedInputStream(fis); bis.read(fcontent); file = new FileInfo(fname, fcontent); } catch (FileNotFoundException e) { e.printStackTrace(); } finally { bis.close(); fis.close(); } CommandTransfer transfer = new CommandTransfer(); transfer.setCmd("uploadFile"); transfer.setData(file); try { sendData(transfer);// 將資料發送到伺服器 transfer = getData();// 擷取伺服器返回的資料 System.out.println(transfer.getResult());// 輸出顯示結果 } catch (UnknownHostException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } finally { } } // 向伺服器發送資料 public static void sendData(CommandTransfer cmd) throws IOException { // TODO Auto-generated method stub ObjectOutputStream oos = null; try { if(socket.isClosed())//判斷socket是否被關閉，如果關閉，就開啟 socket = new Socket("localhost", 8888); oos = new ObjectOutputStream(socket.getOutputStream()); oos.writeObject(cmd); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } // 使用者登陸 private void showLogin() throws IOException { User user = new User(); CommandTransfer transfer = new CommandTransfer(); while (true) { System.out.print("請輸入使用者名稱："); user.setUsename(input.next()); System.out.print("請輸入密碼："); user.setUsepsd(input.next()); transfer.setCmd("login"); transfer.setData(user); try { sendData(transfer);// 將資料發送到伺服器 transfer = getData();// 擷取伺服器返回的資料 System.out.println(transfer.getResult());// 輸出顯示結果 System.out.println("*****************************"); if (transfer.isFlag()) { break;// 如果註冊成功，則不再重複執行註冊 } } catch (UnknownHostException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } finally { } } showUploadFile();// 登陸成功後進行檔案的上傳 } }

運行效果圖如下：

檔案已儲存到資料庫中了，這個項目對於想練練Socket通訊和mysql的朋友來說，還是挺不錯的。

以上所述是小編給大家介紹的Java Socket+mysql實現簡易檔案上傳器，希望對大家有所協助，如果大家有任何疑問請給我留言，小編會及時回複大家的。在此也非常感謝大家對雲棲社區網站的支援！