netbeans login help

[rudr@]

login wenne nane bn me code eken,

String sql;
sql = "select * from studentreg where uname = ? and password = ?";
try
{
pst = (PreparedStatement) con.prepareStatement(sql);
pst.setString(1, uname1.getText());
pst.setString(2, password1.getText());
rs = pst.executeQuery();
if (rs.next())
{
JOptionPane.showMessageDialog(null, "Username and Password correct");
close();

main s= new main();
s.setVisible(true);
}
else
{
JOptionPane.showMessageDialog(null, "invalid username and password");
}
}
catch (HeadlessException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
}

 

[amilapradeep100]

login wenne nane bn me code eken,

String sql;
sql = "select * from studentreg where uname = ? and password = ?";
try
{
pst = (PreparedStatement) con.prepareStatement(sql);
pst.setString(1, uname1.getText());
pst.setString(2, password1.getText());
rs = pst.executeQuery();
if (rs.next())
{
JOptionPane.showMessageDialog(null, "Username and Password correct");
close();

main s= new main();
s.setVisible(true);
}
else
{
JOptionPane.showMessageDialog(null, "invalid username and password");
}
}
catch (HeadlessException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
}

මොකක්ද වෙන්න ඕනෙ උයාට

 

[rudr@]

මොකක්ද වෙන්න ඕනෙ උයාට

database eken username ekai password ekai galapunahama main page ekata yanna ona bn, meke yanne nane bn..

invalid username and password , kiyala watenawa.

 

[amilapradeep100]

login wenne nane bn me code eken,

String sql;
sql = "select * from studentreg where uname = ? and password = ?";
try
{
pst = (PreparedStatement) con.prepareStatement(sql);
pst.setString(1, uname1.getText());
pst.setString(2, password1.getText());
rs = pst.executeQuery();
if (rs.next())
{
JOptionPane.showMessageDialog(null, "Username and Password correct");
close();

main s= new main();
s.setVisible(true);
}
else
{
JOptionPane.showMessageDialog(null, "invalid username and password");
}
}
catch (HeadlessException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
}

Declare කොරලා නැනෙ

 

[rudr@]

Declare කොරලා නැනෙ

package interfac;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import java.awt.HeadlessException;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import mycode.dbconnect;


public class login extends javax.swing.JFrame {

Connection con = null;
PreparedStatement pst = null;
ResultSet rs=null;



/**
* Creates new form login
*/
public login() {
initComponents();

// connect to db
con = dbconnect.connect();
}



/**
* 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() {

jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jButton1 = new javax.swing.JButton();
uname1 = new javax.swing.JTextField();
password1 = new javax.swing.JTextField();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
});

jLabel1.setText("user name");

jLabel2.setText("password");

jButton1.setText("Login");
jButton1.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jButton1MouseClicked(evt);
}
});
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(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()
.addGap(106, 106, 106)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(jLabel1))
.addGap(60, 60, 60)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton1)
.addComponent(uname1, javax.swing.GroupLayout.PREFERRED_SIZE, 143, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(password1, javax.swing.GroupLayout.PREFERRED_SIZE, 143, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(268, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(104, 104, 104)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(uname1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(41, 41, 41)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(password1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(46, 46, 46)
.addComponent(jButton1)
.addContainerGap(160, Short.MAX_VALUE))
);

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

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {





}

private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {

String sql;
sql = "select * from studentreg where uname = ? and password = ?";
try
{
pst = (PreparedStatement) con.prepareStatement(sql);
pst.setString(1, uname1.getText());
pst.setString(2, password1.getText());
rs = pst.executeQuery();
if (rs.next())
{
JOptionPane.showMessageDialog(null, "Username and Password correct");
close();

main s= new main();
s.setVisible(true);
}
else
{
JOptionPane.showMessageDialog(null, "invalid username and password");
}
}
catch (HeadlessException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
}


}

private void formWindowOpened(java.awt.event.WindowEvent evt) {

con = dbconnect.connect();
}

/**
* @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 | InstantiationException | IllegalAccessException | javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>

//</editor-fold>

/* Create and display the form */
java.awt.EventQueue.invokeLater(() -> {
new login().setVisible(true);
});
}

// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JTextField password1;
private javax.swing.JTextField uname1;
// End of variables declaration

private void close() {


throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
}
}


hadala bn thiyenne,

 

[DooA]

uname1.getText()
password1.getText()
මේ දෙක ලොග් කරලා බලන්න හරිද කියල values.


අනික ඔහොම කරන්න එපා. rs.next() නම් login කරන්න එපා. username and password compare කරලා බලන්න. නැත්නම් ඕක case sensitive නැ

 

[amilapradeep100]

login wenne nane bn me code eken,

String sql;
sql = "select * from studentreg where uname = ? and password = ?";
try
{
pst = (PreparedStatement) con.prepareStatement(sql);
pst.setString(1, uname1.getText());
pst.setString(2, password1.getText());
rs = pst.executeQuery();
if (rs.next())
{
JOptionPane.showMessageDialog(null, "Username and Password correct");
close();

main s= new main();
s.setVisible(true);
}
else
{
JOptionPane.showMessageDialog(null, "invalid username and password");
}
}
catch (HeadlessException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
}

login ගන්න දෙයක් නෑ...ස්පේස් නිසා කෙල වෙනවා වගේ ..trim කලොත් හරියයි වගේ...

 

[rudr@]

uname1.getText()
password1.getText()
මේ දෙක ලොග් කරලා බලන්න හරිද කියල values.


අනික ඔහොම කරන්න එපා. rs.next() නම් login කරන්න එපා. username and password compare කරලා බලන්න. නැත්නම් ඕක case sensitive නැ

variable name dekanam hari mcn, rs.next() නම් login කරන්න එපා meka therune ne bn..

 

[amilapradeep100]

login wenne nane bn me code eken,

String sql;
sql = "select * from studentreg where uname = ? and password = ?";
try
{
pst = (PreparedStatement) con.prepareStatement(sql);
pst.setString(1, uname1.getText().trim());
pst.setString(2, password1.getText().trim());
rs = pst.executeQuery();
if (rs.next())
{
JOptionPane.showMessageDialog(null, "Username and Password correct");
close();

main s= new main();
s.setVisible(true);
}
else
{
JOptionPane.showMessageDialog(null, "invalid username and password");
}
}
catch (HeadlessException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
}

uda eka balapan

 

[rudr@]

uda eka balapan

eth ne mcn..

 

[amilapradeep100]

eth ne mcn..

අලුතින් ඇඩ් කරපන් එකවුන්ට් එකක්... ඇඩ් කරද්දි trim කරපන් අනිවා... ඒකට චෙක් කරපන්.. උබගෙ ලොග්න් එක පට්ට පජාතයි බන්... දැක්කාම එපා වෙනව... හික්

 

[rudr@]

අලුතින් ඇඩ් කරපන් එකවුන්ට් එකක්... ඇඩ් කරද්දි trim කරපන් අනිවා... ඒකට චෙක් කරපන්.. උබගෙ ලොග්න් එක පට්ට පජාතයි බන්... දැක්කාම එපා වෙනව... හික්

kawada kapu takaranda bn mewa...

 

[amilapradeep100]

kawada kapu takaranda bn mewa...

 PreparedStatement stat = con.prepareStatement("select * from login where USERID = ?");
   stat.setString(1,jTextField1.getText().trim());
   ResultSet rs = stat.executeQuery();
   if(rs.next()){
   pass= rs.getString("PASSWORD").trim();
   TYPE = rs.getString("USERTYPE").trim();
   ID = rs.getString("CAID").trim();
   if(TYPE.equals("CASHIER")&& pass.equals(jPasswordField2.getText().trim()))
   {
   
   PURCHASE.Bill obj = new PURCHASE.Bill();
   obj.show();
obj.v(ID);
   this.dispose();
   
   
   
   }

username password දෙකම චෙක් කරපන්.. පුදපු ගමන් කන්න එපා..

 

[වැලි ගොව්වා]

උඹ use කරන්නෙ windows ද linux ද? Linux වල mysql query කරද්දි table names case sensitive සිද්ධියක් තියෙනවා.

 

[DooA]

උඹ use කරන්නෙ windows ද linux ද? Linux වල mysql query කරද්දි table names case sensitive සිද්ධියක් තියෙනවා.

Nope sql case sensitive na

 

[DooA]

variable name dekanam hari mcn, rs.next() නම් login කරන්න එපා meka therune ne bn..

Databse eke values wala space thiyenawada balanna.
E kiyanne result set eke result thiyenawanam login karanna rpa. Manually username and password compare karannam

 

[rudr@]

wade hari.. help karapu okkotama thanx...