第四次考核

最新推荐文章于 2024-10-02 00:27:17 发布

weixin_30550081

最新推荐文章于 2024-10-02 00:27:17 发布

阅读量49

点赞数

文章标签：数据库 java

原文链接：http://www.cnblogs.com/ztsxxny/p/10124327.html

版权

1.码云地址:https://gitee.com/ztsxxny/codes

2.服务器端：

import java.util.*;

import java.io.*;

import java.net.*;

public class Server_Main

{

    public static void main(String args[])

    {

    Scanner scanner = new Scanner(System.in);

    ServerSocket server = null;

    ServerThread thread;

    Socket kehu = null;

    while (true){

    try {

    server = new ServerSocket(2010);

    }

    catch(IOException e1){

        System.out.println("正在监听");

    }

    try {

        System.out.println("等待呼叫");

        kehu = server.accept();

    }

    catch (Exception e)

    {

        System.out.println("正在等待客户"+e);

    }

    if (kehu !=null){

    new ServerThread(kehu).start(); }

   }

  }

}

class ServerThread extends Thread{

    Scanner scanner = new Scanner(System.in);

    Socket socket;

    DataOutputStream out=null;

    DataInputStream in=null;

    String s = null;

    ServerThread(Socket t)

    {

        socket = t;

        try

        {

            out = new DataOutputStream(socket.getOutputStream());

            in = new DataInputStream(socket.getInputStream());

            for(int i=0;i<10;i++)

        {

            String s=in.readUTF(); 

            System.out.println("客户来话："+s);

            out.writeUTF(scanner.nextLine());

         

        }

        }

        catch (IOException e){}

    }

     

}

3.客户端：

import java.io.*;

import java.net.*;

import java.util.*;

public class Client_Main

{

    public static void main (String args[])

    {

        Socket mysocket;

        DataInputStream in=null;

        DataOutputStream out=null;

        try

        {

            mysocket = new Socket("127.0.0.1",2010);

            in = new DataInputStream(mysocket.getInputStream());

            out = new DataOutputStream(mysocket.getOutputStream());

            for (int i=0;i<10;i++)

            {

                Scanner scanner = new Scanner(System.in);    

                String source = scanner.nextLine();

                out.writeUTF(source);

                String s= in.readUTF();

                System.out.println("收到服务器的回答："+s);

                Thread.sleep(500);

            }

        }

        catch(Exception e)

        {

            System.out.println("服务器已断开"+e);

        }

    }

}

4.数据库：

Connection con=null;

Statement sql;

ResultSet rs;

try{ Class.forName("com.mysql.kdbc.Driver");

}

catch(Exception e){}

String uri="jdbc:mysql://localhost:3306/client?useSSL=true";

String user="root";

String password="111111";

try{con = DriverManager.getConnection(uri,user,password);}

catch(SQLException e){}

String jilu="";

String sqlStr = ""+jilu;

try{

sql=con.createStatement();

rs=sql.executeQuery("SELECT bir FROM mess WHERE Number=1001");

while(rs.next()){

String number=rs.getString(1);

//String name=rs.getString(2);

//Date date=rs.getDate(3);

//float height=rs.getFloat(4);

System.out.print(number);

//System.out.print(name);

//System.out.print(date);

//System.out.print(height);

}

con.close();

 

}

catch(SQLException e){

System.out.println(e);

}