1,105,581 Community Members

problem with Database to access Server/ServerSocket

Member Avatar
raj.mscking
Newbie Poster
15 posts since Feb 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

Good To Meet you All!

Sir In my server

This is the JButton action for start server

private void strsrvActionPerformed(java.awt.event.ActionEvent evt) {                                         
    getClint();
}

This is action Performed sir..,

public void getClint()
{


                try
                {
            ServerSocket ss=new ServerSocket(1030);


                        try
                        {
                            JOptionPane.showMessageDialog(null,"Server is runing");
                        while(true)
                   {
                       Socket s=ss.accept();
                       Service a=new Service(s);
                       a.start();
                   }
                        }
                        catch(Exception e)
                        {
                              System.out.println(e);
                }
            }

        catch(IOException ex)
        {
            Logger.getLogger(MainF.class.getName()).log(Level.SEVERE, null,ex);
        }
}

This Is the Inner class code for to access clients

public class Service extends Thread 
{
        public Socket s;
        public Service(Socket t) 

        {
             s=t;
        }
        public void run()
        {
            try
    {
         BufferedReader input = new BufferedReader(new InputStreamReader(s.getInputStream()));
                PrintWriter output = new PrintWriter(new OutputStreamWriter(s.getOutputStream()));
                String userName = input.readLine();
                String password = input.readLine();
                String getd=input.readLine();
                try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/payslip", "root", "root");
        PreparedStatement ps = conn.prepareStatement("select * from employeenew where un='"+userName+"' and pw='"+password+"'");
         ps.execute();
       while(true)
        {
            PreparedStatement ps1 = conn.prepareStatement("insert into attents (un='"+userName+"',pw='"+password+"',intim='"+getd+"')");
            output.println("You Have LogIn" + userName);
            ps1.executeUpdate();
             conn.close();
          }

    } catch (Exception e) {
        JOptionPane.showMessageDialog(rootPane,"LoginFailed");
    }
                output.close();
                input.close();
                s.close();
                }
                catch(Exception e)
                {
                    System.out.println(e);
                }
                }
                }

The client code is

a/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * Client.java
 *
 * Created on Apr 28, 2012, 10:58:31 AM
 */

import java.io.*;
import java.net.*;
import java.util.Calendar;
import java.util.Date;
import javax.swing.JOptionPane;
/**
 *
 * @author e-soft
 */
public class Client extends javax.swing.JFrame {
Socket s;
    /** Creates new form Client */
    public Client() {
        initComponents();
    }
        /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        un = new javax.swing.JTextField();
        pw = new javax.swing.JTextField();
        lin = new javax.swing.JButton();
        lo = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        lin.setText("LogIn");
        lin.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mousePressed(java.awt.event.MouseEvent evt) {
                linMousePressed(evt);
            }
        });
        lin.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                linActionPerformed(evt);
            }
        });

        lo.setText("LogOut");
        lo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                loActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addComponent(pw, javax.swing.GroupLayout.PREFERRED_SIZE, 113, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(un, javax.swing.GroupLayout.PREFERRED_SIZE, 113, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGap(22, 22, 22))
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(lin)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 94, Short.MAX_VALUE)
                        .addComponent(lo)
                        .addGap(79, 79, 79))))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(37, 37, 37)
                .addComponent(un, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(pw, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(lin)
                    .addComponent(lo))
                .addContainerGap(24, Short.MAX_VALUE))
        );

        pack();
    }// </editor-fold>                        

private void linActionPerformed(java.awt.event.ActionEvent evt) {                                    
// TODO add your handling code here:
         try
        {
      Socket s=new Socket("192.168.1.8",1030);
      PrintWriter output = new PrintWriter(new OutputStreamWriter(s.getOutputStream()));
      String userName =un.getText();
      output.println(userName);
      String password =pw.getText();
      output.println(password);
      Date dt=Calendar.getInstance().getTime();
      Date timzn=(dt);
      output.println(timzn);
      output.flush();
      BufferedReader input = new BufferedReader(new InputStreamReader(s.getInputStream()));
      String response = input.readLine();
      JOptionPane.showMessageDialog(rootPane, response);
      output.close();
      input.close();
      s.close();
      lo.setEnabled(true);
      lin.setEnabled(false);
       }
        catch (Exception e)
        {
            JOptionPane.showMessageDialog(rootPane, "Server Is Not In Conection");

       }

}                                   

private void loActionPerformed(java.awt.event.ActionEvent evt) {                                   
// TODO add your handling code here:
    lin.setEnabled(true);
    lo.setEnabled(false);
}                                  

private void linMousePressed(java.awt.event.MouseEvent evt) {                                 
// TODO add your handling code here:

}                                

    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {

               /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(Client.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(Client.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(Client.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(Client.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        /* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                new Client().setVisible(true);
            }
        });
    }
    // Variables declaration - do not modify                     
    private javax.swing.JButton lin;
    private javax.swing.JButton lo;
    private javax.swing.JTextField pw;
    private javax.swing.JTextField un;
    // End of variables declaration                   
}

My problem is
the server can use the username and password as static declaration only

But

if i connect to database it showing error while before access the database,
(even it not access the database try Block)
and the error message also unable to read, it showing transparent-able or black screen sir..,

(I Don't know how to properly use the database with server)

Anyone can help me please..,
Thank you..,

Member Avatar
NormR1
Posting Sage
7,723 posts since Jun 2010
Reputation Points: 563 [?]
Q&As Helped to Solve: 793 [?]
Skill Endorsements: 16 [?]
Team Colleague
 
0
 

Cross posted at Click Here

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article