Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
Ad icon
ZTE MF283U 4G Unlocked Router (Used)
ayanthamaxi
Updated:
Sunday at 8:26 PM
ලංකාවේ හොඳම උපකාරක පන්ති සහ ගුරුවරුන් එකම තැනකින් - TopTuition.lk
dulithapathum
Updated:
Saturday at 8:07 AM
Colombo
RidhMathraa ’26 🎶✨
Tmadhusanka
Updated:
Wednesday at 11:58 PM
Ad icon
Colombo
PXN V10 Pro Direct Drive Racing Wheel (Under Warranty)
Abdur Rahman
Updated:
Wednesday at 10:23 PM
Ad icon
USDT ණය සේවාව - USDT Loan Service
පුරවැසියා
Updated:
Wednesday at 4:54 PM
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
ElaKiri Talk!
Java Help!
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="niyomax" data-source="post: 19016541" data-attributes="member: 514695"><p>meka kohomada balanna kauruhari (weda karanawa) mam keewe standard eka <img src="/styles/default/xenforo/smilies/default/P.gif" class="smilie" loading="lazy" alt=":P" title=":P :P" data-shortname=":P" /></p><p></p><p>DB Class</p><p></p><p>[CODE]package elakiri;</p><p>import java.sql.Connection;</p><p>import java.sql.DriverManager;</p><p>import java.sql.SQLException;</p><p></p><p>public class DBClass {</p><p> private static final String USERNAME= "root";</p><p> private static final String PASSWORD= "";</p><p> private static final String CONN_STRING= "jdbc:mysql://localhost:3306/exampleelakiri";</p><p> </p><p> public static Connection ConnectDB() throws SQLException{</p><p> </p><p> Connection conn=null;</p><p> </p><p> try{</p><p> conn=DriverManager.getConnection(CONN_STRING,USERNAME,PASSWORD);</p><p> return conn;</p><p> }catch(SQLException e){</p><p> System.err.println(e);</p><p> </p><p> }</p><p> return null;</p><p> }</p><p></p><p> </p><p>}[/CODE]</p><p></p><p>login class ekema</p><p>[CODE]</p><p>public class LoginForm extends javax.swing.JFrame {</p><p>Connection conn=null;</p><p>ResultSet rs=null;</p><p>PreparedStatement pst=null;</p><p></p><p> public LoginForm() throws SQLException {</p><p> initComponents();</p><p> conn= DBClass.ConnectDB();</p><p> }[/CODE]</p><p></p><p>Button</p><p>Action Perfomed ekata</p><p></p><p> [CODE] private void cmd_loginActionPerformed(java.awt.event.ActionEvent evt) { </p><p> String sql = "SELECT * from adminstbl where username=? and password=?";</p><p> try{</p><p> pst=conn.prepareStatement(sql);</p><p> pst.setString(1, uname.getText());</p><p> pst.setString(2, pword.getText());</p><p> </p><p> rs=pst.executeQuery();</p><p> if(rs.next()){</p><p> JOptionPane.showMessageDialog(null, "Username and Password is correct");</p><p> rs.close();</p><p> pst.close();</p><p> close();</p><p> </p><p> Options s=new Options();</p><p> s.setVisible(true);</p><p> </p><p> }</p><p> else{</p><p> JOptionPane.showMessageDialog(null, "Username and Password is incorrect");</p><p> }</p><p> }</p><p> catch(Exception e)</p><p> {</p><p> JOptionPane.showMessageDialog(null, e);</p><p> </p><p> }</p><p> </p><p> } [/CODE]</p></blockquote><p></p>
[QUOTE="niyomax, post: 19016541, member: 514695"] meka kohomada balanna kauruhari (weda karanawa) mam keewe standard eka :P DB Class [CODE]package elakiri; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBClass { private static final String USERNAME= "root"; private static final String PASSWORD= ""; private static final String CONN_STRING= "jdbc:mysql://localhost:3306/exampleelakiri"; public static Connection ConnectDB() throws SQLException{ Connection conn=null; try{ conn=DriverManager.getConnection(CONN_STRING,USERNAME,PASSWORD); return conn; }catch(SQLException e){ System.err.println(e); } return null; } }[/CODE] login class ekema [CODE] public class LoginForm extends javax.swing.JFrame { Connection conn=null; ResultSet rs=null; PreparedStatement pst=null; public LoginForm() throws SQLException { initComponents(); conn= DBClass.ConnectDB(); }[/CODE] Button Action Perfomed ekata [CODE] private void cmd_loginActionPerformed(java.awt.event.ActionEvent evt) { String sql = "SELECT * from adminstbl where username=? and password=?"; try{ pst=conn.prepareStatement(sql); pst.setString(1, uname.getText()); pst.setString(2, pword.getText()); rs=pst.executeQuery(); if(rs.next()){ JOptionPane.showMessageDialog(null, "Username and Password is correct"); rs.close(); pst.close(); close(); Options s=new Options(); s.setVisible(true); } else{ JOptionPane.showMessageDialog(null, "Username and Password is incorrect"); } } catch(Exception e) { JOptionPane.showMessageDialog(null, e); } } [/CODE] [/QUOTE]
Insert quotes…
Verification
Hath warak paha keeyada? (hatha wadikireema paha)
Post reply
Top
Bottom