Laporan Aktivitas Belajar
Nama Lengkap
|
:
|
ERNI
|
No.
Registrasi
|
:
|
1108261309
|
Alamat
email
|
:
|
Ernytwin.94@gmail.com
|
Opsi
|
:
|
Aplikasi Perangkat lunak
|
Tahap Perkuliahan ke-
|
:
|
Tahap Perkuliahan Ke-29
|
USBJJ
|
:
|
SMKN 1 TANJUNG SELOR
|
Aktivitas Belajar Mandiri
|
Kolom
di
bawah ini berisi uraian singkat aktivitas belajar rutin saya selama Tahap Perkuliahan ini.
|
Perkuliahan ini di mulai tanggal 28 Oktober 2013 pada perkuliahan ini membahas tentang 29. Merancang basisdata dan koneksi dengan J2SE . |
Kolom
di bawah ini berisi uraian singkat aktivitas saya di USBJJ
selama Tahap Perkuliahan ini.
|
Pada tanggal 2 November diadakan perkuliahan di Usbjj SMK N 1 TANJUNG SELOR pada tahap ini saya mencari bahan referensi di internet dan serta elearning .
|
Kolom
di bawah ini berisi kendala-kendala yang saya hadapi selama Tahap Perkuliahan ini.
|
Kendala-kendala
yang saya selama mmenghadapi tahap
perkuliahan ini :
·
Jauhnya teman untuk
belajar bersama
·
Tidak adanya jaringan
untuk internet
- laptop yang tidak suport pada aplikasi yang digunakan |
Rangkuman Materi Perkuliahan
|
Kolomdi bawah ini berisi rangkuman materi perkuliahan
yang telah saya pelajari dan pahami selama Tahap Perkuliahan ini.
|
Pertama-tama kita ke neatbeans. kemudian buat projectnya dan masukan source codenya seperti di bawah ini: Untuk membuat database saya menggunakan XAMPP :
-
Database
saya berinama “login” :
CREATE
DATABASE login;
-
Membuat
Tabel “User” :
CREATE
TABLE `login`.`user` (
`id` int(
5 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 10 ) NOT NULL ,
`password` VARCHAR( 10 ) NOT NULL ,
PRIMARY KEY
( `id` )
) ENGINE = MYISAM ;
-
Memasukan
data kedalam tabel user :
INSERT
INTO `login`.`user` (`id`,`username`,`password`)
VALUES
('Null', 'erni', '12345');
Setelah
Membuat database selanjutnya Menambahkan Library
Source Code Connect Mysql
package Login;
import java.sql.*;
import javax.swing.*;
public class ConnectMySql {
Connection conn =
null;
public static
Connection ConDB(){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection
conn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/login","","");
JOptionPane.showMessageDialog(null, "Koneksi Database
Sukses");
return
conn;
}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
return null;
}
}
- Pada Project – Klik kanan library – add library – lalu pilih MySQL
JDBC Driver.
- Membuat class untuk koneksi ke database MySQL
Klik
Kanan pada project – new – class java
Masukan
Kode berikut ini :
- Membuat Desain From
 Menggkoneksikan mysql dengan neatbeans Klik Kanan pada project – new – class java
Masukan
Kode berikut ini :
Source Code Login Form
package Login;
import java.sql.*;
import java.awt.*;
import javax.swing.*;
public class LoginForm extends javax.swing.JFrame {
Connection conn =
null;
ResultSet rs =
null;
PreparedStatement
pst = null;
public LoginForm()
{
initComponents();
conn =
ConnectMySql.ConDB();
}
@SuppressWarnings("unchecked")
// <editor-fold
defaultstate="collapsed" desc="Generated Code">
private void
initComponents() {
jPanel1 = new
javax.swing.JPanel();
txt_user = new
javax.swing.JTextField();
jLabel1 = new
javax.swing.JLabel();
btn_login =
new javax.swing.JButton();
txt_pass = new
javax.swing.JPasswordField();
jLabel4 = new
javax.swing.JLabel();
jLabel3 = new
javax.swing.JLabel();
jLabel2 = new
javax.swing.JLabel();
jLabel5 = new
javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(null,
"Login", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,
javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Agency
FB", 1, 14), new java.awt.Color(51, 51, 255))); // NOI18N
jLabel1.setText("User Name");
btn_login.setText("Login");
btn_login.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
btn_loginActionPerformed(evt);
}
});
jLabel4.setText(":");
jLabel3.setText(":");
jLabel2.setText("Password");
javax.swing.GroupLayout jPanel1Layout = new
javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel2)
.addGap(24, 24,
24)
.addComponent(jLabel4))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel1)
.addGap(18, 18, 18)
.addComponent(jLabel3)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(txt_user)
.addComponent(txt_pass, javax.swing.GroupLayout.PREFERRED_SIZE, 106,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
jPanel1Layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,
108, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(btn_login)
.addGap(25, 25, 25)))
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(jLabel3)
.addComponent(txt_user, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(14, 14, 14)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(jLabel4)))
.addGroup(jPanel1Layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(txt_pass, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(btn_login)
.addContainerGap())
);
jLabel5.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/Login/imageslogin.jpg")));
// NOI18N
javax.swing.GroupLayout layout = new
javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 186,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(104, 104, 104))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(19, 19, 19)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel5, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGap(26, 26, 26))
);
pack();
}//
</editor-fold>
private void
btn_loginActionPerformed(java.awt.event.ActionEvent evt) {
String sql
= "select * from user where user=?
and password=?";
try{
pst =
conn.prepareStatement(sql);
pst.setString(1,txt_user.getText());
pst.setString(2,txt_pass.getText());
rs =
pst.executeQuery();
if(rs.next()){
JOptionPane.showMessageDialog(null,
"Login Sukses ");
EntriData F2 = new EntriData();
F2.setVisible(true);
}
else{
JOptionPane.showMessageDialog(null, "Login Gagal");
}
}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
public static void
main(String args[]) {
/* Set the
Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look
and feel setting code (optional) ">
/* If Nimbus
(introduced in Java SE 6) is not available, stay with the default look and
feel.
* For details
see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for
(javax.swing.UIManager.LookAndFeelInfo info :
javax.swing.UIManager.getInstalledLookAndFeels()) {
if
("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch
(ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(InstantiationException ex) {
java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(IllegalAccessException ex) {
java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
//</editor-fold>
/* Create and
display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public
void run() {
new
LoginForm().setVisible(true);
}
});
}
// Variables
declaration - do not modify
private
javax.swing.JButton btn_login;
private
javax.swing.JLabel jLabel1;
private
javax.swing.JLabel jLabel2;
private
javax.swing.JLabel jLabel3;
private
javax.swing.JLabel jLabel4;
private
javax.swing.JLabel jLabel5;
private
javax.swing.JPanel jPanel1;
private
javax.swing.JPasswordField txt_pass;
private
javax.swing.JTextField txt_user;
// End of
variables declaration
}
|
Video
Dokumentasi
|
Pada kolomini berisi cuplikan gambar
(screenshots) dari Video
Dokumentasi yang telah sayabuat pada Tahap Perkuliahan ini.
|
Kolom
di bawah ini merupakan uraian yang menceritakan isi Video Dokumentasi yang
telah saya buat.
|
Pada tahap perkuliahan ke-29 ini saya menjelaskan dari membuat project baru hingga prosese runing.
|
Kolom
di bawah ini berisi link yang
menampilan Video Dokumentasi yang telah saya upload di Youtube.
|
Part I
http://youtu.be/PMuxTgUGUA Part II
http://youtu.be/SA3jrr589FI
Part III
http://youtu.be/OYm8G0WBTq8
|
No comments:
Post a Comment