Reply to thread

Message

<blockquote data-quote="Chathuranga1" data-source="post: 19016257" data-attributes="member: 75417">මචන් මේක පොඩ්ඩක් ට්‍රයි කරලා බලහන් ..මම ගහපු එකක් ඕක [CODE]&nbsp;public void login() {&nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ResultSet rset = db.getdata(&quot;SELECT * FROM login&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (rset.next()) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String username = rset.getString(&quot;name&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String password = rset.getString(&quot;password&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ((username.equals(txt_username.getText()) &amp;&amp; password.equals(String.valueOf(txt_pass.getPassword())))) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; new Home().setVisible(true);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.dispose();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JOptionPane.showMessageDialog(this, &quot; &quot;, &quot;Login Eroor&quot;, WIDTH, null);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; System.out.println(e);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }[/CODE]මේක තමයි DB class එක ..මේක උබ ගහන ඕනේ ෆෝරම් එකකට ඉම්පෝර්ට් කරපන් ..[CODE]/*&nbsp;* To change this template, choose Tools | Templates&nbsp;* and open the template in the editor.&nbsp;*/package config;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;/**&nbsp;*&nbsp;* @author Rish&nbsp;*/public class DB {&nbsp; &nbsp; static Connection con() throws Exception{&nbsp; &nbsp; &nbsp; &nbsp; Class.forName(&quot;com.mysql.jdbc.Driver&quot;);&nbsp; &nbsp; &nbsp; &nbsp; Connection con=DriverManager.getConnection(&quot;jdbc:mysql://localhost:3306/test-app?useUnicode=true&amp;characterEncoding=UTF-8&quot;,&quot;root&quot;,&quot;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; // Statement st=con.createStatement();&nbsp; &nbsp; &nbsp; &nbsp; return con;&nbsp; &nbsp; }&nbsp; &nbsp; public ResultSet getdata(String sql) throws Exception{&nbsp; &nbsp; &nbsp; &nbsp; Statement st=con().createStatement();&nbsp; &nbsp; &nbsp; &nbsp; ResultSet rset = st.executeQuery(sql);&nbsp; &nbsp; &nbsp; &nbsp; return rset;&nbsp; &nbsp; }&nbsp;&nbsp; public void putdata(String sql) throws Exception{&nbsp; &nbsp; &nbsp; &nbsp; Statement st=con().createStatement();&nbsp; &nbsp; &nbsp; &nbsp; st.executeUpdate(sql);&nbsp; &nbsp; }}[/CODE]</blockquote>

[QUOTE="Chathuranga1, post: 19016257, member: 75417"] මචන් මේක පොඩ්ඩක් ට්‍රයි කරලා බලහන් ..මම ගහපු එකක් ඕක [CODE] public void login() { try { ResultSet rset = db.getdata("SELECT * FROM login"); while (rset.next()) { String username = rset.getString("name"); String password = rset.getString("password"); if ((username.equals(txt_username.getText()) && password.equals(String.valueOf(txt_pass.getPassword())))) { new Home().setVisible(true); this.dispose(); } else { JOptionPane.showMessageDialog(this, " ", "Login Eroor", WIDTH, null); } } } catch (Exception e) { System.out.println(e); } } [/CODE] [B][SIZE="3"] මේක තමයි DB class එක ..මේක උබ ගහන ඕනේ ෆෝරම් එකකට ඉම්පෝර්ට් කරපන් ..[/SIZE][/B] [CODE] /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package config; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; /** * * @author Rish */ public class DB { static Connection con() throws Exception{ Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test-app?useUnicode=true&characterEncoding=UTF-8","root",""); // Statement st=con.createStatement(); return con; } public ResultSet getdata(String sql) throws Exception{ Statement st=con().createStatement(); ResultSet rset = st.executeQuery(sql); return rset; } public void putdata(String sql) throws Exception{ Statement st=con().createStatement(); st.executeUpdate(sql); } } [/CODE] [/QUOTE]

Verification

Hath warak paha keeyada? (hatha wadikireema paha)

Search

Latest ads

Reply to thread