【Java TCP/IP Socket】服务端的实现(可连接oracle数据库)

欢迎关注本人公众号交流学习

 

1.Socket服务端实现步骤

 

1.创建ServerSocket对象，绑定并监听端口

2.通过accept监听客户端的请求

3.建立连接后，通过输出输入流进行读写操作

4.将读取的信息存入数据库，并进行下一次的监听

公众号代码实现链接：

https://mp.weixin.qq.com/s/pQAeKywNQXmqCKJNibhPSQ

 

2.代码实现

1.DBUtil.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
/**
 * JDBC操作数据库的工具类
* @ClassName: DBUtil 
 */
public class DBUtil {
	String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
	String userName="system";
	String password ="oracledba";
	private Connection conn=null;
	private Statement stmt=null;
	private PreparedStatement pstmt=null;
	private ResultSet resultSet =null;
	
	static{
		//第一步：加载驱动
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	/**
	 * 获取连接的工具方法
	 * @return
	 */
	public  Connection   getConn(){
			try {
			 //第二步：获取连接
			    conn =DriverManager.getConnection(url, userName, password);
			    return conn;
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		return null;
	}
	
	/**
	 * 获取语句对象的工具方法
	 * @return
	 */
	public  Statement getStatement(){
		
		try {
			if(conn==null || conn.isClosed()  ){
				 conn=  getConn();
			}
		    stmt = conn.createStatement();
			return stmt;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	
	/**
	 * 获取预处理语句对象PreparedStatement
	 * @param sql
	 * @return
	 */
	public PreparedStatement  getPreparedStatement(String sql ){
		try {
			if(conn==null || conn.isClosed() ){ 
				 conn=  getConn();
			}
			pstmt = conn.prepareStatement(sql);
			return pstmt; 
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	
	/**更新记录的方法:insert 、update 、delete
	 * @param sql
	 * @return
	 */
	public int  update(String sql){
		try {
			if(stmt==null || stmt.isClosed() ){
				getStatement();
			}
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		try {
			int res = stmt.executeUpdate(sql);
			return res;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("error"+e.getMessage());
		}finally{
			close();
		}
		return 0;
	}
	//注意：JDBC 执行完sql之后，要释放资源：倒叙关闭
	/**
	 * 释放资源的工具方法
	 */
	public  void close(){
		if(resultSet !=null ){
			try {
				resultSet.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(stmt!=null){
			try {
				stmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(pstmt!=null){
			try {
				pstmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(conn!=null){
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
	}
 
}

2.服务端接收实现

public static void main(String args[]) throws Exception {

		while (true) {

			@SuppressWarnings("resource")

			//创建Socket 实例，监听8899端口

			ServerSocket serverSocket = new ServerSocket(8899);

			while (true) {

				try {

					//获取客户端连接

					Socket socket = serverSocket.accept();

					//接收客户端的数据

					Reader r = new InputStreamReader(socket.getInputStream());

					int ch;

					StringBuffer sb = new StringBuffer();

					while ((ch = r.read()) != -1) {

						sb.append((char) ch);

					}

					putInDataBase(sb.toString());

					

				} catch (Exception e) {

					System.out.println(e.getMessage());

				}

			}

		}

	}

3.截取并存入数据库

public static  void putInDataBase(String sb){

		DBUtil db=new DBUtil();

		//客户端发送的数据是@开头，#结尾的，这里截取出来

		String s=sb.substring(sb.indexOf("@")+1,sb.indexOf("#"));

		System.out.println("************"+s+"******");

		Date date= new Date();

		SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

		String sj = sf.format(date);

		//拼接SQL语句

		String sql="insert into SYSTEM.ZGGL (T,Z,C,H,B,L,M,A) values ( '"+ sj+"',"+s;

		//执行SQL语句

		int a=db.update(sql);

		if(a==0){

			System.out.println("执行失败");

		}

		

	}

 

 

 

1.Socket服务端

1.