Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.*;
- import java.net.*;
- import java.io.FileOutputStream;
- import java.io.ObjectInputStream;
- import java.io.ObjectOutputStream;
- import java.net.ServerSocket;
- import java.net.Socket;
- import java.io.File;
- import java.sql.*;
- class TCPServer
- {
- public static void main(String argv[]) throws Exception
- {
- String clientSentence,clientpassword;
- String capitalizedSentence;
- ServerSocket welcomeSocket = new ServerSocket(4003);
- Connection con = null;
- String url = "jdbc:mysql://localhost:3306/";
- String db = "database";
- String driver = "com.mysql.jdbc.Driver";
- String user = "root";
- String pass = "root";
- while(true)
- {
- Socket connectionSocket = welcomeSocket.accept();
- BufferedReader inFromClient =
- new BufferedReader(new InputStreamReader(connectionSocket.getInputStream()));
- BufferedReader inFromClient1 =
- new BufferedReader(new InputStreamReader(connectionSocket.getInputStream()));
- DataOutputStream outToClient = new DataOutputStream(connectionSocket.getOutputStream());
- clientSentence = inFromClient.readLine();
- clientpassword = inFromClient.readLine();
- System.out.println("Received User Name: " + clientSentence);
- System.out.println("Received Password: " + clientpassword);
- Class.forName(driver).newInstance();
- con = DriverManager.getConnection(url+db, user, pass);
- Statement st = con.createStatement();
- ResultSet res = st.executeQuery("SELECT * FROM table WHERE user='clientSentence' AND password='clientpassword'");
- while (res.next()) {
- String u = res.getString("user");
- String p = res.getString("password");
- if (clientSentence.equals(u) && clientpassword.equals(p)){
- capitalizedSentence = "Welcome "+clientSentence+" n";
- outToClient.writeBytes(capitalizedSentence);
- }else{
- capitalizedSentence = "Sorry, not authorized n";
- outToClient.writeBytes(capitalizedSentence);
- }
- }
- }con.close();
- }
- }
- import java.io.*;
- import java.net.*;
- import java.io.File;
- import java.io.FileInputStream;
- import java.io.ObjectInputStream;
- import java.io.ObjectOutputStream;
- import java.net.Socket;
- import java.util.Arrays;
- import java.lang.*;
- import java.util.Scanner;
- class TCPClient
- {
- public static void main(String argv[]) throws Exception
- {
- String sentence,sentence1;
- String modifiedSentence;
- BufferedReader inFromUser = new BufferedReader( new InputStreamReader(System.in));
- BufferedReader inFromUser1 = new BufferedReader( new InputStreamReader(System.in));
- Socket clientSocket = new Socket("localhost", 4003);
- DataOutputStream outToServer = new DataOutputStream(clientSocket.getOutputStream());
- DataOutputStream outToServer1 = new DataOutputStream(clientSocket.getOutputStream());
- BufferedReader inFromServer = new BufferedReader(new InputStreamReader(clientSocket.getInputStream()));
- Console console = System.console();
- String username = console.readLine("Enter your Username :");
- char pswd[] = console.readPassword("Enter your Password :");
- String upwd=new String(pswd);
- outToServer.writeBytes(username + 'n');
- outToServer1.writeBytes(upwd + 'n');
- modifiedSentence = inFromServer.readLine();
- System.out.println("FROM SERVER: " + modifiedSentence);
- }
- clientSocket.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement