saya mau share bagaimana membuat aplikasi sekolah dengan java,
aplikasi ini belum rampung tapi apa salahnya saya share buat berbagi ilmu khususnya java desktop
aplikasi ini terdiri darai form
- INPUT PENDAFTARAN SISWA BARU/PINDAHAN
- REPORT DATA SISWA
- ACOUNTI/PEMBAYARAN SPP
- NEXT >>>PERHITUNGAN GAJI GURU>>>PERHITUNGAN PENGELUARAN(LISTRIK,PAM,INTERNET SEKOLAH)
Doain saja saya sehat selalu,karena aplikasi ini saya buat bukan utk di jual tapi utk di bagi kepeda yang membutuhkan
baik langsung baelah........
1.MEMBUAT FORM LOGIN
Klik Button Login dan ketikan Code Berikut "jangan di copy ya biar cepat bisa..heheheh"
package school;
import javax.swing.JOptionPane;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
public class Login extends javax.swing.JFrame {
Statement st =null;
ResultSet rs=null;
public Login() {
initComponents();
conection();
}
//Class pesan erorr-------------------------------------
public ClassErorr msgeror= new ClassErorr();
//----------------------------------------------------------
public void conection()
{
try {
st=ClassKoneksi.GetConnection().createStatement();
} catch (SQLException ex) {
Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void login()
{
try {
String id=txtid.getText().trim();
String pass=txtpass.getText();
conection();
String Query="select * from login where username='"+id+"' and password='"+pass+"'";
rs=st.executeQuery(Query);
if(rs.next())
{
JOptionPane.showMessageDialog(null, msgeror.LoginSuccess);
this.dispose();
Main_Menu mm=new Main_Menu();
mm.show();
}else
{
JOptionPane.showMessageDialog(null, msgeror.LoginEror);
}
} catch (SQLException ex) {
Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void proseslogin()
{
String id=txtid.getText().trim();
String pass=txtpass.getText();
if(id.equals("")|| pass.equals(""))
{
JOptionPane.showMessageDialog(null, msgeror.LognErorrtxt);
return;
}else
{
login();
}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
proseslogin();
}
2.MEMBUAT FORM UTAMA
ketikan code berikut
package school;
import java.awt.Dimension;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
public class Main_Menu extends javax.swing.JFrame {
public Main_Menu() {
initComponents();
setExtendedState(MAXIMIZED_BOTH);
}
private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {
try {
PENDAFTRAN_SISWA PS=new PENDAFTRAN_SISWA ();
jDesktopPane1.add(PS);
Dimension parentSize = jDesktopPane1.getSize();
Dimension childSize = PS.getSize();
PS.setLocation((parentSize.width - childSize.width)/2, (parentSize.height - childSize.height)/2);
PS.setVisible(true);
} catch (SQLException ex) {
Logger.getLogger(Main_Menu.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(Main_Menu.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Laporan lap=new Laporan();
jDesktopPane1.add(lap);
Dimension parentSize = jDesktopPane1.getSize();
Dimension childSize = lap.getSize();
lap.setLocation((parentSize.width - childSize.width)/2, (parentSize.height - childSize.height)/2);
lap.setVisible(true);
} catch (SQLException ex) {
Logger.getLogger(Main_Menu.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(Main_Menu.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {
Accounting acc= new Accounting();
jDesktopPane1.add(acc);
Dimension parentSize = jDesktopPane1.getSize();
Dimension childSize = acc.getSize();
acc.setLocation((parentSize.width - childSize.width)/2, (parentSize.height - childSize.height)/2);
acc.setVisible(true);
}
3.MEMBUAT FORM PENDAFTARAN SISWA
package school;import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.ImageIcon;
public class PENDAFTRAN_SISWA extends javax.swing.JInternalFrame {
Statement st=null;
ResultSet rs=null;
ClassErorr msgerorr= new ClassErorr ();
public PENDAFTRAN_SISWA() throws SQLException, ClassNotFoundException {
initComponents();
st=ClassKoneksi.GetConnection().createStatement();
}
//CONSTRUCT
private void savedata() throws SQLException, ClassNotFoundException
{
String nis=TXTNIS.getText().toUpperCase();
String nmSiswa=TXTNAMASISWA.getText().toUpperCase();
String NMortu=TXTORTU.getText().toUpperCase();
String kerjaortu=TXTPEKERJAAN.getText().toUpperCase();
String phone =TXTPHONE.getText().toUpperCase();
String Alamat=TXTALAMAT.getText().toUpperCase();
if(nmSiswa.equals("")|| NMortu.equals("") ||
kerjaortu.equals("") || phone.equals("") || Alamat.equals(""))
{
JOptionPane.showMessageDialog(null,msgerorr.ErorrSavetxt);
return;
}else
{
CallableStatement calllabelstetmen=null;
String InsertfromSP="{call insertdata(?,?,?,?,?)}";
calllabelstetmen=ClassKoneksi.GetConnection().prepareCall(InsertfromSP);
calllabelstetmen.setString("@namasiswa",nmSiswa);
calllabelstetmen.setString("@namaortu",NMortu);
calllabelstetmen.setString("@pekerjaanorto",kerjaortu);
calllabelstetmen.setString("@phone",phone);
calllabelstetmen.setString("@alamat",Alamat);
int i=calllabelstetmen.executeUpdate();
if(i==0)
{
JOptionPane.showMessageDialog(null,msgerorr.Erorrsave);
}else
{
JOptionPane.showMessageDialog(null,msgerorr.SuccessSave);
}
}
}
private void updatedatas() throws SQLException, ClassNotFoundException
{
String nis=TXTNIS.getText().toUpperCase();
String nmSiswa=TXTNAMASISWA.getText().toUpperCase();
String NMortu=TXTORTU.getText().toUpperCase();
String kerjaortu=TXTPEKERJAAN.getText().toUpperCase();
String phone =TXTPHONE.getText().toUpperCase();
String Alamat=TXTALAMAT.getText().toUpperCase();
String Query;
if(nis.equals("")|| nmSiswa.equals("")|| NMortu.equals("") ||
kerjaortu.equals("") || phone.equals("") || Alamat.equals(""))
{
JOptionPane.showMessageDialog(null,msgerorr.ErorrUpdatetxt);
return;
}else
{
CallableStatement calllabelstetmen=null;
String InsertfromSP="{call updatedata(?,?,?,?,?,?)}";
calllabelstetmen=ClassKoneksi.GetConnection().prepareCall(InsertfromSP);
calllabelstetmen.setString("@nis",nis);
calllabelstetmen.setString("@namasiswa",nmSiswa);
calllabelstetmen.setString("@namaortu",NMortu);
calllabelstetmen.setString("@pekerjaanorto",kerjaortu);
calllabelstetmen.setString("@phone",phone);
calllabelstetmen.setString("@alamat",Alamat);
int i=calllabelstetmen.executeUpdate();
if(i==0)
{
JOptionPane.showMessageDialog(null,msgerorr.ErorrUpdate);
}else
{
JOptionPane.showMessageDialog(null,msgerorr.SuccessUpdate);
}
}
}
private void deletedata() throws SQLException, ClassNotFoundException
{
String nis=TXTNIS.getText().toUpperCase();
String nmSiswa=TXTNAMASISWA.getText().toUpperCase();
String NMortu=TXTORTU.getText().toUpperCase();
String kerjaortu=TXTPEKERJAAN.getText().toUpperCase();
String phone =TXTPHONE.getText().toUpperCase();
String Alamat=TXTALAMAT.getText().toUpperCase();
if(nis.equals("")|| nmSiswa.equals("")|| NMortu.equals("") ||
kerjaortu.equals("") || phone.equals("") || Alamat.equals(""))
{
JOptionPane.showMessageDialog(null,msgerorr.ErorrDeletetxt);
return;
}else
{
CallableStatement calllabelstetmen=null;
String InsertfromSP="{call sp_deletedata(?)}";
calllabelstetmen=ClassKoneksi.GetConnection().prepareCall(InsertfromSP);
calllabelstetmen.setString("@nis",nis);
int i=calllabelstetmen.executeUpdate();
if(i==0)
{
JOptionPane.showMessageDialog(null,msgerorr.ErorrDelete
);
}else
{
JOptionPane.showMessageDialog(null,msgerorr.SuccessDelete);
}
}
}
private void showdata() throws SQLException
{
DefaultTableModel tbl = new DefaultTableModel();
tbl.addColumn("NIS");
tbl.addColumn("NAMA SISWA");
tbl.addColumn("NAMA ORANG TUA");
tbl.addColumn("PEKERJAAN ORANG TUA");
tbl.addColumn("PHONE");
tbl.addColumn("ALAMAT");
rs=st.executeQuery("select * from data_siswa");
while(rs.next())
{
tbl.addRow(new Object[]{rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6)});
}jTable1.setModel(tbl);
}
DEMIKIAN SEMOGA BERMANFAAT
Tidak ada komentar:
Posting Komentar