Reply to thread

Message: <blockquote data-quote="sajithswa" data-source="post: 14145736" data-attributes="member: 67103">Machan java wediya danne nedda?Use ur form constructor for DB connetion.Menna me tika class eka patan gatthata passe danna.Connection con;Statement stm;ResultSet rs;Ita passe constructor eka athule me tika danna.try {            String ip = "localhost";            String un = "root";            String pw = "123";            con = null;            Class.forName("com.mysql.jdbc.Driver").newInstance();            con = DriverManager.getConnection("jdbc:mysql://" + ip + ":3306/pos", un, pw);            stm = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);        } catch (Exception e) {        }If ur class is frmGUI code look like this...import java.sql.*;import java.util.logging.Level;import java.util.logging.Logger;public class frmGUI extends javax.swing.JFrame {    Connection con;    Statement stm;    ResultSet rs;    public frmGUI() {        try {            String ip = "localhost";            String un = "root";            String pw = "123";            con = null;            Class.forName("com.mysql.jdbc.Driver").newInstance();            con = DriverManager.getConnection("jdbc:mysql://" + ip + ":3306/pos", un, pw);            stm = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);        } catch (Exception e) {        }    }}Then u an use stm variable for transaction like this way.public ResultSet select(String query) {        if (con != null) {            try {                System.out.println(query);                return rs = stm.executeQuery(query);            } catch (SQLException ex) {                Logger.getLogger(Database.class.getName()).log(Level.SEVERE, null, ex);            }        }        return null;    }</blockquote>

Verification: Hath warak paha keeyada? (hatha wadikireema paha)

Top Bottom