Rekayasa Perangkat Lunak Tugas UAS With Database Access

Project Aplikasi Reservasi Bandara

Analisa Kebutuhan :

Aplikasi ini berfungsi untuk menyimpan dan Penjualan Tikel Online.
Mempermudah dalam memasukan data Ke server..

Disini Saya Menggunakan Themes Admin Panel Gentelella Alela, Untuk Mempercantik Tampilan nya,,,,

Rancangan Database Name heru_db.mdb

Table

penjualan ( ID, kode_pesawat, nama_pesawat, tujuan, harga_tiket, jumlah_penumpang, tanggal_keberangkatan )

DataBase Microsoft Access 2016

Interface Input Penjualan Di Visual Studio 2012

Interface View Data Di Visual Studio 2012

Interface Input Penjualan Saat Di Running DI Web (Google Chrome)

Interface View Data DI Web Sinkron Database DI Web (Google Chrome)

Interface Input Penjualan Saat Input Data Sukses Di Input Masuk Ke Database DI Web (Google Chrome)

Source Code Form Input Penjualan

Imports System.Data
Imports System.Data.OleDb

Public Class WebForm3
    Inherits System.Web.UI.Page
    Dim Koneksi As String = "provider=microsoft.jet.oledb.4.0;data source=C:\Users\Heru\Documents\Visual Studio 2012\Projects\WebApplication6 (4)\WebApplication6\WebApplication6\App\heru_db.mdb"
    Dim objekKoneksi As New OleDb.OleDbConnection(Koneksi)

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        objekKoneksi.Open()
        Dim tambah As String = "INSERT INTO penjualan values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "') "
        Dim oCmd = New OleDbCommand(tambah, objekKoneksi)
        oCmd.ExecuteNonQuery()
        objekKoneksi.Close()
        MsgBox("Sukses")
    End Sub

    Protected Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
        TextBox1.Text = ""
        TextBox2.Text = ""
        TextBox3.Text = ""
        TextBox4.Text = ""
        TextBox5.Text = ""
        TextBox6.Text = ""
        TextBox7.Text = ""
    End Sub

    Protected Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
        Response.Redirect("DataBase.aspx")
    End Sub
End Class

Source Code HTML Form Input Penjualan

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WebForm3.aspx.vb" Inherits="WebApplication6.WebForm3" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <!-- Meta, title, CSS, favicons, etc. -->
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <title>Dashboard | Bandara</title>

    <!-- Bootstrap -->
    <link href="themes/vendors/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
    <!-- Font Awesome -->
    <link href="themes/vendors/font-awesome/css/font-awesome.min.css" rel="stylesheet">
    <!-- NProgress -->
    <link href="themes/vendors/nprogress/nprogress.css" rel="stylesheet">
    
    <!-- Custom styling plus plugins -->
    <link href="themes/build/css/custom.min.css" rel="stylesheet">
  </head>

<body class="nav-md">
    <div class="container body">
      <div class="main_container">
        <div class="col-md-3 left_col">
          <div class="left_col scroll-view">
            <div class="navbar nav_title" style="border: 0;">
              <a href="index.html" class="site_title"><i class="fa fa-paw"></i> <span>Tiket bandara</span></a>
            </div>
<div class="clearfix">
</div>
<!-- menu profile quick info -->
            <div class="profile clearfix">
              <div class="profile_pic">
                <img src="themes/foto.jpg" alt="themes." class="img-circle profile_img">
              </div>
<div class="profile_info">
                <span>Welcome,</span>
                <h2>
Muhamad Bambang Heru</h2>
</div>
</div>
<!-- /menu profile quick info -->

            <br />

            <!-- sidebar menu -->
            <div id="sidebar-menu" class="main_menu_side hidden-print main_menu">
              <div class="menu_section">
                <h3>
General</h3>
<ul class="nav side-menu">
<li><a href="http://localhost:6810/WebForm3.aspx"><i class="fa fa-laptop"></i> Penjualan Tiket </a></li>
<li><a href="http://localhost:6810/database.aspx"><i class="fa fa-laptop"></i> View Data </a></li>
</ul>
</div>
</div>
<!-- /sidebar menu -->

            <!-- /menu footer buttons -->
            <div class="sidebar-footer hidden-small">
              <a data-toggle="tooltip" data-placement="top" title="Settings">
                <span class="glyphicon glyphicon-cog" aria-hidden="true"></span>
              </a>
              <a data-toggle="tooltip" data-placement="top" title="FullScreen">
                <span class="glyphicon glyphicon-fullscreen" aria-hidden="true"></span>
              </a>
              <a data-toggle="tooltip" data-placement="top" title="Lock">
                <span class="glyphicon glyphicon-eye-close" aria-hidden="true"></span>
              </a>
              <a data-toggle="tooltip" data-placement="top" title="Logout" href="login.html">
                <span class="glyphicon glyphicon-off" aria-hidden="true"></span>
              </a>
            </div>
<!-- /menu footer buttons -->
          </div>
</div>
<!-- top navigation -->
        <div class="top_nav">
          <div class="nav_menu">
            <nav>
              <div class="nav toggle">
                <a id="menu_toggle"><i class="fa fa-bars"></i></a>
              </div>
<ul class="nav navbar-nav navbar-right">
<li class="">
                  <a href="javascript:;" class="user-profile dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
                    <img src="themes/foto.jpg" alt="">Muhamad Bambang Heru
                    <span class=" fa fa-angle-down"></span>
                  </a>
                  <ul class="dropdown-menu dropdown-usermenu pull-right">
<li><a href="javascript:;"> Profile</a></li>
<li>
                      <a href="javascript:;">
                        <span class="badge bg-red pull-right">50%</span>
                        <span>Settings</span>
                      </a>
                    </li>
<li><a href="javascript:;">Help</a></li>
<li><a href="login.html"><i class="fa fa-sign-out pull-right"></i> Log Out</a></li>
</ul>
</li>
<li role="presentation" class="dropdown">
                  <a href="javascript:;" class="dropdown-toggle info-number" data-toggle="dropdown" aria-expanded="false">
                    <i class="fa fa-envelope-o"></i>
                    <span class="badge bg-green">6</span>
                  </a>
                  <ul id="menu1" class="dropdown-menu list-unstyled msg_list" role="menu">
<li>
                      <a>
                        <span class="image"><img src="images/img.jpg" alt="Profile Image" /></span>
                        <span>
                          <span>John Smith</span>
                          <span class="time">3 mins ago</span>
                        </span>
                        <span class="message">
                          Film festivals used to be do-or-die moments for movie makers. They were wherethemes.
                        </span>
                      </a>
                    </li>
<li>
                      <a>
                        <span class="image"><img src="images/img.jpg" alt="Profile Image" /></span>
                        <span>
                          <span>John Smith</span>
                          <span class="time">3 mins ago</span>
                        </span>
                        <span class="message">
                          Film festivals used to be do-or-die moments for movie makers. They were wherethemes.
                        </span>
                      </a>
                    </li>
<li>
                      <a>
                        <span class="image"><img src="images/img.jpg" alt="Profile Image" /></span>
                        <span>
                          <span>John Smith</span>
                          <span class="time">3 mins ago</span>
                        </span>
                        <span class="message">
                          Film festivals used to be do-or-die moments for movie makers. They were wherethemes.
                        </span>
                      </a>
                    </li>
<li>
                      <a>
                        <span class="image"><img src="images/img.jpg" alt="Profile Image" /></span>
                        <span>
                          <span>John Smith</span>
                          <span class="time">3 mins ago</span>
                        </span>
                        <span class="message">
                          Film festivals used to be do-or-die moments for movie makers. They were wherethemes.
                        </span>
                      </a>
                    </li>
<li>
                      <div class="text-center">
                        <a>
                          <strong>See All Alerts</strong>
                          <i class="fa fa-angle-right"></i>
                        </a>
                      </div>
</li>
</ul>
</li>
</ul>
</nav>
          </div>
</div>
<!-- /top navigation -->

        <!-- page content -->
        <div class="right_col" role="main">
          <div class="">
            <div class="page-title">
              <div class="title_left">
                <h3>
Reservasi Pemesanan Tiket Bandara</h3>
</div>
<div class="title_right">
                <div class="col-md-5 col-sm-5 col-xs-12 form-group pull-right top_search">
                  <div class="input-group">
                    <input type="text" class="form-control" placeholder="Search forthemes.">
                    <span class="input-group-btn">
                        <button class="btn btn-default" type="button">Go!</button>
                    </span>
                  </div>
</div>
</div>
</div>
<div class="clearfix">
</div>
<div class="row">
              <div class="col-md-12">
                <div class="x_panel">
                  <div class="x_title">
                    <h2>
Reservasi Pemesanan Tiket Bandara</small></h2>
<ul class="nav navbar-right panel_toolbox">
<li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                      </li>
<li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-wrench"></i></a>
                        <ul class="dropdown-menu" role="menu">
<li><a href="#">Settings 1</a>
                          </li>
<li><a href="#">Settings 2</a>
                          </li>
</ul>
</li>
<li><a class="close-link"><i class="fa fa-close"></i></a>
                      </li>
</ul>
<div class="clearfix">
</div>
</div>
<div class="x_content">

                            <form id="form1" runat="server">
                            <div>


    
                                <br />
            <br />
               ID                                            
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                                                Harga Tiket                                
            <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
            <br />
            <br />
                Kode Pesawat                       
            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                                               Jumlah Penumpang                    
            <asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
            <br />
            <br />
                Nama Pesawat                      
            <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
                                               Tanggal Keberangkatan              
            <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox>
            <br />
            <br />
                 Tujuan                                  
            <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
                                                                                    
            <br />
            <br />
            <br />
            <br />
                                                                                                    
            <asp:Button ID="Button1" runat="server" Height="58px" style="margin-top: 0px" Text="SIMPAN" Width="209px" BackColor="#0066FF" ForeColor="White" />
            <asp:Button ID="Button2" runat="server" Height="58px" style="margin-top: 0px" Text="CLEAR" Width="209px" BackColor="#0066FF" ForeColor="White" />
            <asp:Button ID="Button3" runat="server" Height="58px" style="margin-top: 0px" Text="VIEW DATA" Width="209px" BackColor="#0066FF" ForeColor="White" />
            <br />


    
                            </div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- /page content -->

        <!-- footer content -->
        <footer>
          <div class="pull-right">
            Gentelella - Bootstrap Admin Template by <a href="https://colorlib.com">Colorlib</a>
          </div>
<div class="clearfix">
</div>
</footer>
        <!-- /footer content -->
      </div>
</div>
<!-- jQuery -->
    <script src="themes/vendors/jquery/dist/jquery.min.js"></script>
    <!-- Bootstrap -->
    <script src="themes/vendors/bootstrap/dist/js/bootstrap.min.js"></script>
    <!-- FastClick -->
    <script src="themes/vendors/fastclick/lib/fastclick.js"></script>
    <!-- NProgress -->
    <script src="themes/vendors/nprogress/nprogress.js"></script>

    <!-- Custom Theme Scripts -->
    <script src="themes/build/js/custom.min.js"></script>
  </body>
</html>

Source Code Form View Data Penjualan

Public Class WebForm4
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub


    Protected Sub GridView2_SelectedIndexChanged(sender As Object, e As EventArgs) Handles GridView2.SelectedIndexChanged

    End Sub

    Protected Sub GridView1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles GridView1.SelectedIndexChanged

    End Sub
End Class

kumpulan tutorial blogger

Rekayasa Perangkat Lunak Tugas UAS With Database Access

Posting Komentar

0 Komentar

Popular Posts

Facebook

Categories

Tags

Recent Posts

Categories

Tags

Recent in Recipes

Footer Menu Widget

kumpulan tutorial blogger

Rekayasa Perangkat Lunak Tugas UAS With Database Access

Anda mungkin menyukai postingan ini

Posting Komentar

0 Komentar

Popular Posts

Facebook

Categories

Tags

Recent Posts

Categories

Tags

Recent in Recipes

Footer Menu Widget