# xrandr --output VGA1 --auto
# xrandr --output VGA1 --left-of LVDS1
# nano /etc/ssh/sshd_config
#Port 22
#AddressFamily any
ListenAddress 127.0.0.1
#ListenAddress ::
#Port 22
#AddressFamily any
#ListenAddress 127.0.0.1
#ListenAddress ::
#PermitRootLogin yes
# service sshd restart
postgres=# CREATE TABLE sample (id char);
postgres=# \d
postgres=# ALTER TABLE sample RENAME to sampletable;
postgres=# \d
# nano /etc/sysconfig/apache2
# SuSEconfig
# service apache2 restart
http://site.com/index.php?p=home
http://site.com/home
RewriteEngine on
RewriteRule ^home$ index.php?p=home [L]
Options All -Indexes
zypper ar -f http://download.opensuse.org/repositories/X11:/MATE/12.2/ MATE
zypper ref
zypper in -t pattern mate-desktop-default
--> Idle Seconds = 300, disabling automatic reconnect.
wvdial: utils/wvtask.cc:401: static void WvTaskMan::_stackmaster(): Assertion `magic_number == -0x123678' failed.
Aborted
# rpm -Uvh *.rpm
while(true) {
System.out.print("> ");
// read message from user
String msg = scan.nextLine();
if (msg.length() <= 3) {
client.sendMessage(new ChatMessage(ChatMessage.MESSAGE, msg));
}
// logout if message is LOGOUT
else if(msg.equalsIgnoreCase("LOGOUT")) {
client.sendMessage(new ChatMessage(ChatMessage.LOGOUT, ""));
// break to do the disconnect
break;
}
// message WhoIsIn
else if(msg.equalsIgnoreCase("WHOISIN")) {
client.sendMessage(new ChatMessage(ChatMessage.WHOISIN, ""));
}
// Private Message
else if( (msg.substring(0,3)).equalsIgnoreCase("TO:")){
CEncrypt enc = new CEncrypt();
String[] arrayMsg=msg.split(" ");
String user=arrayMsg[0].substring(3);
String pesan="";
for (int i=1;i<arrayMsg.length;i++)
pesan = pesan +" "+ arrayMsg[i];
CEncrypt e = new CEncrypt();
String encMsg = e.encryptString(pesan);
client.sendMessage(new ChatMessage(ChatMessage.PM, user, encMsg)); }
else { // default to ordinary message
client.sendMessage(new ChatMessage(ChatMessage.MESSAGE, msg));
}
}
private synchronized void privateMessage(String message, String receiver, String sender) {
// add HH:mm:ss and \n to the message
String time = sdf.format(new Date());
//String messageLf = time + " " + message + "\n";
// display message on console or GUI
if(sg == null)
System.out.print(time + " PM from "+sender+" to "+receiver+" "+message);
else
sg.appendRoom(time + " PM from "+sender+" to "+receiver+" "+message); // append in the room window
// we loop in reverse order in case we would have to remove a Client
// because it has disconnected
for(int i = al.size(); --i >= 0;) {
ClientThread ct = al.get(i);
if (ct.username.equals(receiver)) { //Dekripsi jika nama user = user tujuan
CEncrypt denc = new CEncrypt();
ct.writeMsg(time +" PM from "+sender+" : "+ denc.decryptString(message));
}
else { //Pesan tidak di dekripsi jika tidak sama
ct.writeMsg(time +" PM from "+sender+" : "+ message);
}
}
}
public class CEncrypt
{
static final String key = "Encrypt"; // The key for 'encrypting' and 'decrypting'.
static String encryptString(String str)
{
StringBuffer sb = new StringBuffer (str);
//System.out.println("Insert Key : ");readln(key);
int lenStr = str.length();
int lenKey = key.length();
//
// For each character in our string, encrypt it...
for ( int i = 0, j = 0; i < lenStr; i++, j++ )
{
if ( j >= lenKey ) j = 0; // Wrap 'round to beginning of key string.
//
// XOR the chars together. Must cast back to char to avoid compile error.
//
sb.setCharAt(i, (char)(str.charAt(i) ^ key.charAt(j)));
}
return sb.toString();
}
static String decryptString(String str)
{
//
// To 'decrypt' the string, simply apply the same technique.
return encryptString(str);
}
}
![[Gambas] Koneksi dengan DBMS MYSQL](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCOIJR-QtsAqnFkj09ynUBdVsgUVoGxeQN0wdRgb-99MUowZDINxDC66T2lECnTMX7se7X-tEO-EMFFAdNj0UunPDW1A47DRbO0tGOlm0wkdwaWiw4bWhJ2rSjWzFsufy72_H-iRzF5w/s1600/konekgambas.png "[Gambas] Koneksi dengan DBMS MYSQL")
![[Gambas] Koneksi dengan DBMS MYSQL](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxmiE027F_pJmXjvzg8iDxKbajRM4g7aHvVcJ_FDlsvr8kpazXKZgxWc2dmlyGA49BIaAkPkZTwSpKs38cZaS0WoB3cYPJri7iMclLpa2iahP9a2EDLY0XQkHbql_FiAd0c97eKLp9Vw/s1600/project.png "[Gambas] Koneksi dengan DBMS MYSQL")
![[Gambas] Koneksi dengan DBMS MYSQL](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhieGnriWmqG4UyT6HXrawAuPJxt44KJWaFhQtcla1L2RAsCJL6CtKk6bNFAuwrE-tXglG-oO2h1A-NVw1C5yazMdur_tjK7Pjgg9qllyr8Hvl8nSeJAt1qWEGTD5-rsGb-NY9Jx4E9hQ/s1600/databasegambas.png "[Gambas] Koneksi dengan DBMS MYSQL")
![[Gambas] Koneksi dengan DBMS MYSQL](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBEBuOZGXccxigrc4saiuGzdRloQx3NHDiseNyy_DepQ76W8CNPZ5bfRlYA7cZDmyAV3uy3bFNyVCeNhvEHbaPBlQKqBDzfnrozXm2T-PoFOgPztTG61prNdM60SVRIB25Xo4orf9Htg/s1600/formkoneksigambas.png "[Gambas] Koneksi dengan DBMS MYSQL")
Dim con As New Connection
con.Host = "localhost"
con.type = "mysql"
con.Login = "root"
con.Password = "abi"
con.name = "gambas"
Try
con.Open
If Not Error Then
Message("Connected")
Else
Message("Not Connected")
Endif
Dim con As New Connection
con.Host = "localhost"
con.type = "mysql"
con.Login = "root"
con.Password = "abi"
con.name = "gambasxxx"
Try
con.Open
If Not Error Then
Message("Connected")
Else
Message("Not Connected")
Endif
' Gambas class file
Public Sub _new()
End
Public Sub Form_Open()
End
Public Sub Button1_Click()
Dim con As New Connection
con.Host = "localhost"
con.type = "mysql"
con.Login = "root"
con.Password = "abi"
con.name = "gambas"
Try
con.Open
If Not Error Then
Message("Connected")
Else
Message("Not Connected")
Endif
End
Public Sub Button2_Click()
Dim con As New Connection
con.Host = "localhost"
con.type = "mysql"
con.Login = "root"
con.Password = "abi"
con.name = "gambasxxx"
Try
con.Open
If Not Error Then
Message("Connected")
Else
Message("Not Connected")
Endif
End
Public Sub Button3_Click()
Quit
End
![[Gambas] Koneksi dengan DBMS MYSQL](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgruKEjWBLhUV1vdO2T1Dm04yzjDT9KWZ8YBLvvfZqats9odE-C9dIX6BEr-g2y8lkotz4yVNfjdSjFRLuxaQrGp1N5DkCXLxcYXViBqPjXz6oGz5LBGltUgJiWA4f_wsCc-5wzdEPH5Q/s1600/hasil2.png "[Gambas] Koneksi dengan DBMS MYSQL")
![[Gambas] Koneksi dengan DBMS MYSQL](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdUfOL6k7XsmdNygupzWMOFJA1eYWH5LaT89teaEfjZ9kgQZRTT1uqfdTV7WMpyCLe0SOj45NYxerTEeXrT-8gQxC4lKHgZMHCIWIcWxsI6YQnOZtK2eWNFQnPzWU-hEb-AZApXjjEBw/s1600/hasil3.png "[Gambas] Koneksi dengan DBMS MYSQL")
![[Gambas] Koneksi dengan DBMS MYSQL](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG2PB2Ie5LK3IzQP4HJZn10cw3hbmMPzfMLoAXeIYIorRvTjuOh1mkumyTnbMAj0nBFxKtDIhsaNn_FUFIjbs1rzU8IGOrf_DdjIpPH46X-fIsKuuSSy3ADpU6GV1ZrHUci3-olsD5ng/s1600/hasil4.png "[Gambas] Koneksi dengan DBMS MYSQL")
# zypper in udisks
> create database chat;
> use chat;
> create table chat(user varchar(50), message varchar(100), time datetime);
import java.sql.Connection;- Tambahkan Deklarasi Variabel untuk Koneksi Database Mysql :
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
Connection conn = null;
String dbUserName = "root"; // MySQL database username
String dbPassword = "abi"; // MySQL database password
String dbUrl = "jdbc:mysql://localhost/chat";
try {
Class forNam = Class.forName("com.mysql.jdbc.Driver");
try {
forNam.newInstance();
} catch (InstantiationException ex) {
Logger.getLogger(Server.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(Server.class.getName()).log(Level.SEVERE, null, ex);
}
} catch (ClassNotFoundException ex) {
Logger.getLogger(Server.class.getName()).log(Level.SEVERE, null, ex);
}
try {
conn = DriverManager.getConnection(dbUrl, dbUserName, dbPassword);
System.out.println("Database connection establish...!");
} catch (SQLException ex) {
System.out.println("Cannot connect to database server...!!");
Logger.getLogger(Server.class.getName()).log(Level.SEVERE, null, ex);
}
public void insert(String x) {
// try to close the connection
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost/chat","root","abi");
Statement st = conn.createStatement();
String insertSql = "INSERT chat VALUES('"+username+"','"+x+"','" + sdf.format(new Date()) + "')";
int val = st.executeUpdate(insertSql);
} catch (SQLException ex) {
System.out.println("Cannot connect to database server...!!");
Logger.getLogger(Server.class.getName()).log(Level.SEVERE, null, ex);
}
}
class ClientThread extends Thread {
- - - - - -
ClientThread(Socket socket) {
insert "Telah Terkoneksi");
}
}
public void run() {
- - - - - - -
case ChatMessage.MESSAGE:
broadcast(username + ": " + message);
//------------------------------
insert(message);
//------------------------------
break;
public void run() {
- - - - - - -
case ChatMessage.LOGOUT:
display(username + " disconnected with a LOGOUT message.");
keepGoing = false;
insert("disconnected with a LOGOUT message");
break;
public Server(int port, ServerGUI sg) {
// GUI or not
this.sg = sg;
// the port
this.port = port;
// to display hh:mm:ss
sdf = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
// ArrayList for the Client list
al = new ArrayList<ClientThread>();
}
' Gambas class file
Public Sub _new()
End
Public Sub Form_Open()
ComboBox1.Add("Bakso")
ComboBox1.Add("Mi Ayam")
ComboBox1.Add("Nasi Goreng")
ComboBox1.Add("Lotek")
End
Public Sub Button1_Click()
Select Case ComboBox1.Text
Case "Pilih Menu"
TextArea1.Text = "Pilih Menu dulu !!!"
Case "Bakso"
TextArea1.Text = "Anda Pesan Bakso"
Case "Mi Ayam"
TextArea1.Text = "Anda Pesan Mi Ayam"
Case "Nasi Goreng"
TextArea1.Text = "Anda Pesan Nasi Goreng"
Case "Lotek"
TextArea1.Text = "Anda Pesan Lotek"
End Select
End
Public Sub Button2_Click()
Select Case
Message.Question("Yakin Keluar?", "Ya", "Tidak")
Case 1
Me.Close
End Select
End
' Gambas class file
Public Sub _new()
End
Public Sub Form_Open()
End
Public Sub Button1_Click()
Select Case
Message.Question("Yakin Keluar?", "Ya", "Tidak")
Case 1
Me.Close
End Select
End
Public Sub Button2_Click()
Message.Question("Hai, ini adalah message question", "OK")
End
Public a As Integer
Public b As Integer
Public c As Integer
Public Sub _new()
End
Public Sub Form_Open()
End
Public Sub Button3_Click()
Quit
End
Public Sub Button4_Click()
TextBox1.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
End
Public Sub Button1_Click()
If TextBox1.Text == "" Or TextBox2.Text == "" Then
Label4.Text = "Nilai Haris diisi !!!"
Else
a = TextBox1.Text
b = TextBox2.Text
c = a + b
TextBox3.text = c
Endif
End
Public Sub Button2_Click()
If TextBox1.Text == "" Or TextBox2.Text == "" Then
Label4.Text = "Nilai Haris diisi !!!"
Else
a = TextBox1.Text
b = TextBox2.Text
c = a - b
TextBox3.text = c
Endif
End
1. mahasiswa2. mata_kuliah3. khs
Table "public.mahasiswa"
Column | Type | Modifiers
--------+-----------------------+-----------
nim | character(9) | not null
nama | character varying(50) | not nullTable "public.mata_kuliah"
Column | Type | Modifiers
-----------+-----------------------+-----------
kode_mk | character(5) | not null
nama_mk | character varying(30) |
sks | integer |
kurikulum | character(9) |Table "public.khs"
Column | Type | Modifiers
---------+--------------+-----------
nim | character(9) |
kode_mk | character(5) |
ta | character(9) |
smt | integer |
nilai | character(1) |
Foreign-key constraints:
nama_kelompok=> select * from mahasiswa;
nim | nama
-----------+------
091051080 | abby
091051081 | yoga
(2 rows)nama_kelompok=> select * from mata_kuliah ;
kode_mk | nama_mk | sks | kurikulum
---------+-----------------+-----+-----------
tifs1 | Pemrograman SQL | 3 | 2007/2008
tifs2 | Pemrograman Web | 3 | 2007/2008
tifs3 | Jarkom | 3 | 2007/2008
(3 rows)
nama_kelompok=> select * from khs;
nim | kode_mk | ta | smt | nilai
-----------+---------+-----------+-----+-------
091051080 | tifs1 | 2012/2013 | 5 | A
091051080 | tifs2 | 2012/2013 | 5 | A
091051080 | tifs3 | 2012/2013 | 5 | A
(3 rows)
nama_kelompok=> SELECT * from trans('091051080')
nim | kode_mk | nama_mk | nilai
-----------+---------+-----------------+-------
091051080 | tifs1 | Pemrograman SQL | A
091051080 | tifs2 | Pemrograman Web | A
091051080 | tifs3 | Jarkom | A
CREATE OR REPLACE FUNCTION trans(char) RETURNS table (nim char, kode_mk char, nama_mk varchar,nilai char) AS
$$
BEGIN
return query select khs.nim, khs.kode_mk, mata_kuliah.nama_mk, khs.nilai from khs join mata_kuliah using (kode_mk) where khs.kode_mk=mata_kuliah.kode_mk and khs.nim=$1 ;
RETURN;
END;
$$
LANGUAGE 'plpgsql' ;
