ලේසියෙන්ම හොයාගන්න මෙතනින්

NetBeans IDE සමග වැඩ කරමු 2 - connect with mysql and retrieve data

MySQL Database එකත් එක්ක NetBeans Project එක,
connect කරන විදිය,
database එක access කර data ලබා ගන්නා ආකාරය,
Login window එකෙන්, database එකේ saved user name, password check කරලා සාර්ථක නම්, Home(Main) window එක load කරන අයුරු.
Java Class files භාවිතය,
පැහැදිලි කිරීම් සමග.
video ව මෙතැනින් බා ගන්න.

File Size : 12.9 MB
After Extract : 1957.2 MB

http://www.mediafire.com/?hzeczqg11cade12

යොදාගත් coding,

DB_Connect.java , MySQL හා සම්බන්ධ වීමට MySQL database driver එක සැකසීමද, database එක හා connect වීමට path එක, access settings සැකසීම.

    public static Connection createDataBaseConnection() throws SQLException, ClassNotFoundException{
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql:///vehiclereservationsystem","root","");
        return conn;
    }

/////////////////////////////////////////////////////////////////////

DB_Access.java , Java Class file එක සඳහා. Database එකෙන් data ලබා ගැනීම හෝ database එකට data write, update කිරීමට.

    public static ResultSet getData(Connection conn, String query) throws SQLException{
        Statement statement = conn.createStatement();
        ResultSet resultset = statement.executeQuery(query);
        return resultset;
    }
   
    public static void setData(Connection conn, String query) throws SQLException{
        Statement statement = conn.createStatement();
        statement.executeUpdate(query);
    }

////////////////////////////////////////////////////////////////////

Login form එකේදී database එකේ user name, password validate කිරීම සහ, execute කිරීමට අදාළ query එක pass කිරීම.

        String username = textUserName.getText();
        String password = textPassword.getText();
        String checked;
        try{
            Connection connect = DB_Connect.createDataBaseConnection();
            Statement statement = connect.createStatement();
            ResultSet result = statement.executeQuery("select * from travelguide g, transportofficer t where (g.userName='"+username+"' and g.password='"+password+"') or (t.userName='"+username+"' and t.password='"+password+"')");
           
            if(result.next()){
                checked = result.getString(1);
                if(checked.equals(username)){
                    Home home = new Home();
                    home.setVisible(true);
                    this.dispose();
                }
            }
        }catch(Exception e){
           
        }

No comments :

Post a Comment