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..,