Mart 2017 – oflazoglu.org

Aylar: Mart 2017

Dosyalar Arasındaki Farkların Tespiti

caglarPosted on 31 Mart 2017 Genel, Nasıl ?, Ubuntu/Linux kategorisine gönderildi No Comments

Yine gerekli olduğunu düşündüğüm bir komutun kullanımını açıklamak üzere bu yazıya başladım. Her zaman söylediğim gibi şu Windows bataklığından kurtulup bir Linux dağıtımına geçmenizi temenni ediyorum. Benzer komut windowsta da mevcut (File Compare – FC). Çoğu zaman birden fazla dosya kopyası …

Dosyalar Arasındaki Farkların Tespiti Read More »

Etiketler: command, diff, dosya farkı bulma, dosya farkları, fc, file compare, linux, windows

İşletim Sistemleri (Bahar-2016) Hafta-7/2

caglarPosted on 22 Mart 2017 C/C++, Ders Notları, İşletim Sistemleri, Yazılım kategorisine gönderildi No Comments

#include<iostream>
#include<unistd.h>
#include<sys/wait.h>
#include<stdlib.h>

using namespace std;

int main()
{
	pid_t proc_id;
	int durum;
	
	cout<<"Basla:"<<getpid()<<endl;
	
	proc_id = fork();
	
	if(proc_id==0)
	{
		// cocuk
		cout<<"Selam Ben Cocuk!"<<getpid()<<endl;
		//exit(0);
		sleep(60);
	}
	else
	{
		// anne
		waitpid(proc_id,&durum,0);
		cout<<"Sonlanma:"<<durum<<endl;
	}
	

	return 0;
}

#include<iostream>

#include<unistd.h>

#include<sys/wait.h>

#include<stdlib.h>

using namespace std;

int main()

{

pid_t proc_id;

int durum;

cout<<"Basla:"<<getpid()<<endl;

proc_id = fork();

if(proc_id==0)

{

// cocuk

cout<<"Selam Ben Cocuk!"<<getpid()<<endl;

//exit(0);

sleep(60);

}

else

{

// anne

waitpid(proc_id,&durum,0);

cout<<"Sonlanma:"<<durum<<endl;

}

return 0;

}

#include<iostream>
#include<unistd.h>
#include<sys/wait.h>
#include<stdlib.h>

using namespace std;

int main()
{
	pid_t proc_id;
	int durum;
	
	cout<<"Basla:"<<getpid()<<" ::"<<SIGKILL<<endl;
	
	proc_id = fork();
	
	if(proc_id==0)
	{
		// cocuk
		cout<<"Selam Ben Cocuk!"<<endl;
		//exit(0);
	}
	else
	{
		// anne
		kill(proc_id,SIGSTOP);
		waitpid(proc_id,&durum,0);
		cout<<"Sonlanma:"<<durum<<endl;
	}
	

	return 0;
}

#include<iostream>

#include<unistd.h>

#include<sys/wait.h>

#include<stdlib.h>

using namespace std;

int main()

{

pid_t proc_id;

int durum;

cout<<"Basla:"<<getpid()<<" ::"<<SIGKILL<<endl;

proc_id = fork();

if(proc_id==0)

{

// cocuk

cout<<"Selam Ben Cocuk!"<<endl;

//exit(0);

}

else

{

// anne

kill(proc_id,SIGSTOP);

waitpid(proc_id,&durum,0);

cout<<"Sonlanma:"<<durum<<endl;

}

return 0;

}

#include<iostream>
#include<unistd.h>
#include<sys/wait.h>

using namespace std;

int main()
{
	pid_t proc_id;
	int durum;
	
	cout<<"Basla::"<<getpid()<<endl;
	
	proc_id=fork();
	
	if(proc_id==0)
	{
		cout<<"Ben Cocuk!::"<<getpid()<<endl;
		sleep(10);
	}
	else
	{
		cout<<"Ben Anne::"<<getpid()<<" Cocugun id::"<<proc_id<<endl;
		//kill(proc_id,SIGTERM);
		kill(proc_id,SIGSTOP);
		sleep(5);
		kill(proc_id,SIGCONT);
		waitpid(proc_id,&durum,0);
		cout<<"Sonlanma::"<<durum<<endl;
	}
	
	return 0;
}

#include<iostream>

#include<unistd.h>

#include<sys/wait.h>

using namespace std;

int main()

{

pid_t proc_id;

int durum;

cout<<"Basla::"<<getpid()<<endl;

proc_id=fork();

if(proc_id==0)

{

cout<<"Ben Cocuk!::"<<getpid()<<endl;

sleep(10);

}

else

{

cout<<"Ben Anne::"<<getpid()<<" Cocugun id::"<<proc_id<<endl;

//kill(proc_id,SIGTERM);

kill(proc_id,SIGSTOP);

sleep(5);

kill(proc_id,SIGCONT);

waitpid(proc_id,&durum,0);

cout<<"Sonlanma::"<<durum<<endl;

}

return 0;

}

#include<iostream>
#include<unistd.h>
#include<sys/wait.h>
#include<stdlib.h>

using namespace std;

int main()
{
	pid_t proc_id;
	int durum;
	cout<<"Basla:"<<getpid()<<endl;
	proc_id = fork();
	if(proc_id==0)
	{
		// cocuk
		cout<<"Selam Ben Cocuk!"<<endl;
		int x=0, y=0;
		int z=x/y;
		sleep(50);
	}
	else
	{
		// anne
		waitpid(proc_id,&durum,0);
		cout<<"Sonlanma:"<<durum<<endl;
	}
	
	return 0;
}

#include<iostream>

#include<unistd.h>

#include<sys/wait.h>

#include<stdlib.h>

using namespace std;

int main()

{

pid_t proc_id;

int durum;

cout<<"Basla:"<<getpid()<<endl;

proc_id = fork();

if(proc_id==0)

{

// cocuk

cout<<"Selam Ben Cocuk!"<<endl;

int x=0, y=0;

int z=x/y;

sleep(50);

}

else

{

// anne

waitpid(proc_id,&durum,0);

cout<<"Sonlanma:"<<durum<<endl;

}

return 0;

}

Etiketler: fork, getpid(), kill, SIGCONT, SIGSTOP, SIGTERM, waitpid()

İşletim Sistemleri (Bahar-2016) Hafta-7/1

caglarPosted on 22 Mart 2017 C/C++, Ders Notları, İşletim Sistemleri, Yazılım kategorisine gönderildi No Comments

#include<iostream>
#include<unistd.h>

using namespace std;

int main()
{
	cout<<"Merhaba ISTE:"<<getpid()<<endl;
	sleep(5);
	cout<<"Hoscakal ISTE"<<endl;
}

#include<iostream>

#include<unistd.h>

using namespace std;

int main()

{

cout<<"Merhaba ISTE:"<<getpid()<<endl;

sleep(5);

cout<<"Hoscakal ISTE"<<endl;

}

#include<iostream>
#include<unistd.h>

using namespace std;

int main()
{

	cout<<"Basla::"<<getpid()<<endl;
	execl("merhaba","merhaba",NULL,NULL);
	cout<<"Bitis"<<endl;

}

#include<iostream>

#include<unistd.h>

using namespace std;

int main()

{

cout<<"Basla::"<<getpid()<<endl;

execl("merhaba","merhaba",NULL,NULL);

cout<<"Bitis"<<endl;

}

#include<iostream>
#include<unistd.h>
#include<sys/wait.h>

using namespace std;

int main()
{
	pid_t id;
	cout<<"Basla::"<<getpid()<<endl;
	id=fork();
	if(id==0)
		execl("merhaba","merhaba",NULL,NULL); // yeni pid
	else{
		waitpid(id,0,0);
		cout<<"Bitis"<<endl; // annede
	}

}

#include<iostream>

#include<unistd.h>

#include<sys/wait.h>

using namespace std;

int main()

{

pid_t id;

cout<<"Basla::"<<getpid()<<endl;

id=fork();

if(id==0)

execl("merhaba","merhaba",NULL,NULL); // yeni pid

else{

waitpid(id,0,0);

cout<<"Bitis"<<endl; // annede

}

Etiketler: execl, pid_t, unistd, waitpid()

İşletim Sistemleri (Bahar-2016) Hafta-5/2

caglarPosted on 22 Mart 2017 C/C++, Ders Notları, İşletim Sistemleri, Yazılım kategorisine gönderildi No Comments

Thread ile asal sayılar:

#include<iostream>
#include<unistd.h>
#include<pthread.h>

using namespace std;

void * islem1(void *arg)
{
	cout<<"THREAD BASLADI!!::1"<<endl;

	for(int sayi=100;sayi<2000;sayi++)
	{
		int sayac=0;

		for(int i=2;i<(sayi/2);i++)
		{
			if(sayi%i==0)
			{
				sayac++;
				break;	
			}
		}
		
		if(sayac==0)
			cout<<"::1::"<<sayi<<" asaldir"<<endl;
	}

	pthread_exit(0);
}


void * islem2(void *arg)
{
	cout<<"THREAD BASLADI!!::2"<<endl;

	for(int sayi=3000;sayi<9000;sayi++)
	{
		int sayac=0;

		for(int i=2;i<(sayi/2);i++)
		{
			if(sayi%i==0)
			{
				sayac++;
				break;	
			}
		}
		
		if(sayac==0)
			cout<<"::2::"<<sayi<<" asaldir"<<endl;
	}

	pthread_exit(0);
}

int main()
{
	pthread_t iplik1,iplik2;
		
	cout<<"PROC ID:"<<getpid()<<endl;
	
	pthread_create(&iplik1,NULL,islem1,NULL);
	pthread_create(&iplik2,NULL,islem2,NULL);
	cout<<"THREAD BEKLE"<<endl;
	pthread_join(iplik1,NULL);
	pthread_join(iplik2,NULL);
	cout<<"ANA PROC SONLANDI"<<endl;
}

#include<iostream>

#include<unistd.h>

#include<pthread.h>

using namespace std;

void * islem1(void *arg)

{

cout<<"THREAD BASLADI!!::1"<<endl;

for(int sayi=100;sayi<2000;sayi++)

{

int sayac=0;

for(int i=2;i<(sayi/2);i++)

{

if(sayi%i==0)

{

sayac++;

break;

}

if(sayac==0)

cout<<"::1::"<<sayi<<" asaldir"<<endl;

}

pthread_exit(0);

}

void * islem2(void *arg)

{

cout<<"THREAD BASLADI!!::2"<<endl;

for(int sayi=3000;sayi<9000;sayi++)

{

int sayac=0;

for(int i=2;i<(sayi/2);i++)

{

if(sayi%i==0)

{

sayac++;

break;

}

if(sayac==0)

cout<<"::2::"<<sayi<<" asaldir"<<endl;

}

pthread_exit(0);

}

int main()

{

pthread_t iplik1,iplik2;

cout<<"PROC ID:"<<getpid()<<endl;

pthread_create(&iplik1,NULL,islem1,NULL);

pthread_create(&iplik2,NULL,islem2,NULL);

cout<<"THREAD BEKLE"<<endl;

pthread_join(iplik1,NULL);

pthread_join(iplik2,NULL);

cout<<"ANA PROC SONLANDI"<<endl;

}

Etiketler: asal sayi, c#, cpp, pthread, thead

İşletim Sistemleri (Bahar-2016) Hafta-5/1

caglarPosted on 22 Mart 2017 C/C++, Ders Notları, İşletim Sistemleri, Yazılım kategorisine gönderildi No Comments

Thread Örneği:

#include<iostream>
#include<unistd.h>
#include<pthread.h>

using namespace std;

void * islem(void *arg)
{
	cout<<"THREAD BASLADI!!"<<endl;
	sleep(10);
	pthread_exit(0);
}

int main()
{
	pthread_t iplik;
		
	cout<<"PROC ID:"<<getpid()<<endl;
	
	pthread_create(&iplik,NULL,islem,NULL);
	cout<<"THREAD BEKLE"<<endl;
	pthread_join(iplik,NULL);
	cout<<"ANA PROC SONLANDI"<<endl;
}

#include<iostream>

#include<unistd.h>

#include<pthread.h>

using namespace std;

void * islem(void *arg)

{

cout<<"THREAD BASLADI!!"<<endl;

sleep(10);

pthread_exit(0);

}

int main()

{

pthread_t iplik;

cout<<"PROC ID:"<<getpid()<<endl;

pthread_create(&iplik,NULL,islem,NULL);

cout<<"THREAD BEKLE"<<endl;

pthread_join(iplik,NULL);

cout<<"ANA PROC SONLANDI"<<endl;

}

Etiketler: pthread_create, pthread_exit, pthread_join, thread

Nesne Tabanlı Programlama-2 (Bahar-2016) Hafta-7/2

caglarPosted on 22 Mart 2017 Ders Notları, JAVA, Nesne Tabanlı Programlama-2, Yazılım kategorisine gönderildi No Comments

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.sql.*;


public class otomasyon extends JFrame implements ActionListener, ListSelectionListener {

	JList<String>[] jlist;
	DefaultListModel<String>[] dlm;
	JTextField[] jtf;
	
	Connection conn = null;
	
	public otomasyon()
	{
		this.setTitle("Ogrenci Otomasyonu");
		this.setSize(500,400);
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		this.setLayout(new FlowLayout());
		
		JPanel jpn_main = new JPanel();
		jpn_main.setPreferredSize(new Dimension(490, 390));
		jpn_main.setLayout(new GridLayout(1,5));
		
		String[] labels={"İsim","Vize","Final","Ortalama","Harf"};
		String[] buttons={"Ekle","Sil","Güncel."};
		String[] buttons_action={"ekle","sil","guncelle"};
		
		jlist = new JList[5];
		dlm = new DefaultListModel[6]; // id icin 1 adet fazla yazdik
		jtf = new JTextField[3];
		
		dlm[5] = new DefaultListModel<String>(); // id icin
		
		for(int i=0;i<labels.length;i++)
		{
			JPanel jpn = new JPanel();
			jpn_main.add(jpn);
			JLabel jlab = new JLabel(labels[i]);
			jpn.add(jlab);
			
			dlm[i]= new DefaultListModel<String>();
			jlist[i] = new JList<String>(dlm[i]);
			JScrollPane jscp = new JScrollPane(jlist[i]);
			jscp.setPreferredSize(new Dimension(90, 290));
			
			jpn.add(jscp);
			
			jlist[i].addListSelectionListener(this);
			
			if(i<3)
			{
				jtf[i] = new JTextField();
				jtf[i].setPreferredSize(new Dimension(90, 30));
				
				JButton jbtn = new JButton(buttons[i]);
				jbtn.setPreferredSize(new Dimension(90, 30));
				jbtn.addActionListener(this);
				jbtn.setActionCommand(buttons_action[i]);
				jpn.add(jtf[i]);
				jpn.add(jbtn);
				
			}
			
		}
		this.add(jpn_main);
		
		baglan();
		verigetir();
		
		this.setVisible(true);
	}
	
	
	public void verigetir()
	{
		if(conn==null)
			return;
		
		try{
			
			for(int i=0;i<dlm.length;i++)
				dlm[i].clear();
			
			String sql = "select id,isim,vize,final from ogrenciler order by isim;";
			Statement st = conn.createStatement();
			ResultSet rs =st.executeQuery(sql);
			
			while(rs.next())
			{
				dlm[0].addElement(rs.getString("isim"));
				dlm[1].addElement(rs.getString("vize"));
				dlm[2].addElement(rs.getString("final"));
				dlm[5].addElement(rs.getString("id"));
				int vizenot = rs.getInt("vize");
				int finalnot = rs.getInt("final");
				int ortalama =(int) Math.round(vizenot*0.4+finalnot*0.6);

				dlm[3].addElement(ortalama+"");
				if(finalnot<30)
					dlm[4].addElement("FF");
				else
					dlm[4].addElement(harf(ortalama));
			}
				
		}catch(Exception ex){
			
		}
		
	}
	public String harf(int ortalama)
	{
		String[] harfler={"AA","BA","BB","CB","CC","DC","DD","FD"};
		int[] harf_sinir={90,80,70,60,50,40,35,30};
		
		for(int i =0;i<harfler.length;i++)
			if(ortalama>=harf_sinir[i])
				return harfler[i];
		
		return "FF";
	}

	public void baglan()
	{
		
		try{
			
			Class.forName("org.sqlite.JDBC");
			conn=DriverManager.getConnection("jdbc:sqlite:orgun2h7_2.db"); 
		}
		catch(Exception ex)
		{
			JOptionPane.showMessageDialog(this, "Driver dosyası bulunamadı!");		
		}
	}
	
	@Override
	public void actionPerformed(ActionEvent arg0) {
		
		switch (arg0.getActionCommand()) {
			case "ekle": veriekle(); break;
			case "sil": verisil(); break;
			case "guncelle": veriguncelle(); break;

		}
		
		verigetir();
	}
	
	
	public void veriguncelle() {
		if(conn==null || !kontrolet())
			return;
		
		try{
			
			int secilen = jlist[0].getSelectedIndex();
			
			if(secilen>-1)
			{
				String id = dlm[5].get(secilen);
				
				String sql ="update ogrenciler set isim=?, vize=?, final=? where id=?;";
				PreparedStatement ps = conn.prepareStatement(sql);
				ps.setString(1, jtf[0].getText());
				ps.setString(2, jtf[1].getText());
				ps.setString(3, jtf[2].getText());
				ps.setString(4, id);
				ps.executeUpdate();
			}
			
		}
		catch(Exception ex)
		{
			
		}
		
	}

	public void verisil() {
		
		if(conn==null)
			return;
		
		try{
			
			int secilen = jlist[0].getSelectedIndex();
			
			if(secilen>-1)
			{
				String id= dlm[5].get(secilen);
				String sql = "delete from ogrenciler where id=?;";
				PreparedStatement ps = conn.prepareStatement(sql);
				ps.setString(1,id);
				ps.executeUpdate();
			}	
			
		}catch(Exception ex)
		{}
	}

	public void veriekle()
	{
		if(conn==null || !kontrolet())
			return;
		
		try{
			
			String sql = "insert into ogrenciler(isim,vize,final) values(?,?,?);";
			
			PreparedStatement ps = conn.prepareStatement(sql);
			ps.setString(1, jtf[0].getText());
			ps.setString(2, jtf[1].getText());
			ps.setString(3, jtf[2].getText());
			ps.executeUpdate();
			
			jtf[0].setText("");
			jtf[1].setText("");
			jtf[2].setText("");
			
		}catch(Exception ex)
		{
			
		}
		
	}
	
	public boolean kontrolet()
	{
		if(!(jtf[0].getText().length()>0 && jtf[1].getText().length()>0 && jtf[2].getText().length()>0))
			return false;
		
		try {
			
			int vizenot = Integer.parseInt(jtf[1].getText());
			int finalnot = Integer.parseInt(jtf[2].getText());
			
			if(vizenot>=0 && vizenot<=100 && finalnot>=0 && finalnot<=100)
				return true;
		
		}
		catch(Exception ex)
		{}
		
		
		return false;
	}
	
	@Override
	public void valueChanged(ListSelectionEvent e) {
		
		JList jl= (JList) e.getSource();
		
		int secilen = jl.getSelectedIndex();
		
		for(int i=0;i<jlist.length;i++)
			jlist[i].setSelectedIndex(secilen);
		
	}
	

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		new otomasyon();

	}
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import javax.swing.event.*;

import java.sql.*;

public class otomasyon extends JFrame implements ActionListener, ListSelectionListener {

JList<String>[] jlist;

DefaultListModel<String>[] dlm;

JTextField[] jtf;

Connection conn = null;

public otomasyon()

{

this.setTitle("Ogrenci Otomasyonu");

this.setSize(500,400);

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setLayout(new FlowLayout());

JPanel jpn_main = new JPanel();

jpn_main.setPreferredSize(new Dimension(490, 390));

jpn_main.setLayout(new GridLayout(1,5));

String[] labels={"İsim","Vize","Final","Ortalama","Harf"};

String[] buttons={"Ekle","Sil","Güncel."};

String[] buttons_action={"ekle","sil","guncelle"};

jlist = new JList[5];

dlm = new DefaultListModel[6]; // id icin 1 adet fazla yazdik

jtf = new JTextField[3];

dlm[5] = new DefaultListModel<String>(); // id icin

for(int i=0;i<labels.length;i++)

{

JPanel jpn = new JPanel();

jpn_main.add(jpn);

JLabel jlab = new JLabel(labels[i]);

jpn.add(jlab);

dlm[i]= new DefaultListModel<String>();

jlist[i] = new JList<String>(dlm[i]);

JScrollPane jscp = new JScrollPane(jlist[i]);

jscp.setPreferredSize(new Dimension(90, 290));

jpn.add(jscp);

jlist[i].addListSelectionListener(this);

if(i<3)

{

jtf[i] = new JTextField();

jtf[i].setPreferredSize(new Dimension(90, 30));

JButton jbtn = new JButton(buttons[i]);

jbtn.setPreferredSize(new Dimension(90, 30));

jbtn.addActionListener(this);

jbtn.setActionCommand(buttons_action[i]);

jpn.add(jtf[i]);

jpn.add(jbtn);

}

this.add(jpn_main);

baglan();

verigetir();

this.setVisible(true);

}

public void verigetir()

{

if(conn==null)

return;

try{

for(int i=0;i<dlm.length;i++)

dlm[i].clear();

String sql = "select id,isim,vize,final from ogrenciler order by isim;";

Statement st = conn.createStatement();

ResultSet rs =st.executeQuery(sql);

while(rs.next())

{

dlm[0].addElement(rs.getString("isim"));

dlm[1].addElement(rs.getString("vize"));

dlm[2].addElement(rs.getString("final"));

dlm[5].addElement(rs.getString("id"));

int vizenot = rs.getInt("vize");

int finalnot = rs.getInt("final");

int ortalama =(int) Math.round(vizenot*0.4+finalnot*0.6);

dlm[3].addElement(ortalama+"");

if(finalnot<30)

dlm[4].addElement("FF");

else

dlm[4].addElement(harf(ortalama));

}

}catch(Exception ex){

}

public String harf(int ortalama)

{

String[] harfler={"AA","BA","BB","CB","CC","DC","DD","FD"};

int[] harf_sinir={90,80,70,60,50,40,35,30};

for(int i =0;i<harfler.length;i++)

if(ortalama>=harf_sinir[i])

return harfler[i];

return "FF";

}

public void baglan()

{

try{

Class.forName("org.sqlite.JDBC");

conn=DriverManager.getConnection("jdbc:sqlite:orgun2h7_2.db");

}

catch(Exception ex)

{

JOptionPane.showMessageDialog(this, "Driver dosyası bulunamadı!");

}

@Override

public void actionPerformed(ActionEvent arg0) {

switch (arg0.getActionCommand()) {

case "ekle": veriekle(); break;

case "sil": verisil(); break;

case "guncelle": veriguncelle(); break;

}

verigetir();

}

public void veriguncelle() {

if(conn==null || !kontrolet())

return;

try{

int secilen = jlist[0].getSelectedIndex();

if(secilen>-1)

{

String id = dlm[5].get(secilen);

String sql ="update ogrenciler set isim=?, vize=?, final=? where id=?;";

PreparedStatement ps = conn.prepareStatement(sql);

ps.setString(1, jtf[0].getText());

ps.setString(2, jtf[1].getText());

ps.setString(3, jtf[2].getText());

ps.setString(4, id);

ps.executeUpdate();

}

catch(Exception ex)

{

}

public void verisil() {

if(conn==null)

return;

try{

int secilen = jlist[0].getSelectedIndex();

if(secilen>-1)

{

String id= dlm[5].get(secilen);

String sql = "delete from ogrenciler where id=?;";

PreparedStatement ps = conn.prepareStatement(sql);

ps.setString(1,id);

ps.executeUpdate();

}

}catch(Exception ex)

{}

}

public void veriekle()

{

if(conn==null || !kontrolet())

return;

try{

String sql = "insert into ogrenciler(isim,vize,final) values(?,?,?);";

PreparedStatement ps = conn.prepareStatement(sql);

ps.setString(1, jtf[0].getText());

ps.setString(2, jtf[1].getText());

ps.setString(3, jtf[2].getText());

ps.executeUpdate();

jtf[0].setText("");

jtf[1].setText("");

jtf[2].setText("");

}catch(Exception ex)

{

}

public boolean kontrolet()

{

if(!(jtf[0].getText().length()>0 && jtf[1].getText().length()>0 && jtf[2].getText().length()>0))

return false;

try {

int vizenot = Integer.parseInt(jtf[1].getText());

int finalnot = Integer.parseInt(jtf[2].getText());

if(vizenot>=0 && vizenot<=100 && finalnot>=0 && finalnot<=100)

return true;

}

catch(Exception ex)

{}

return false;

}

@Override

public void valueChanged(ListSelectionEvent e) {

JList jl= (JList) e.getSource();

int secilen = jl.getSelectedIndex();

for(int i=0;i<jlist.length;i++)

jlist[i].setSelectedIndex(secilen);

}

/**

* @param args

public static void main(String[] args) {

new otomasyon();

}

NTP2 (Bahar-2016) Hafta-7/2 sqlite-jdbc

Etiketler: createStatement, executeQuery, getConnection, jdbc:sqlite, JOptionPane, ListSelectionEvent, ListSelectionListener, org.sqlite.JDBC, ResultSet, sqlite, Statement, swing, valueChanged

Nesne Tabanlı Programlama-2 (Bahar-2016) Hafta-7/1

caglarPosted on 22 Mart 2017 Ders Notları, JAVA, Nesne Tabanlı Programlama-2, Yazılım kategorisine gönderildi No Comments

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class veritabani extends JFrame implements ActionListener {
	
	DefaultListModel<String>[] dlm;
	JList<String>[] jlist;
	
	JTextField jtf1,jtf2;
	
	public veritabani()
	{
		this.setTitle("Telefon Rehberi");
		this.setSize(200,400);
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		this.setLayout(new FlowLayout());
		
		JPanel jpn_main= new JPanel();
		jpn_main.setLayout(new GridLayout(1,2));
		jpn_main.setPreferredSize(new Dimension(190, 390));
	
		JLabel jlab1= new JLabel("İsim");
		JLabel jlab2= new JLabel("Telefon No");
		JPanel jpn1= new JPanel();		
		JPanel jpn2= new JPanel();
		
		jpn1.add(jlab1);
		jpn2.add(jlab2);
		
		dlm= new DefaultListModel[3];
		jlist = new JList[2];
		
		dlm[2] = new DefaultListModel<String>(); // id listesi
		
		for(int i=0;i<2;i++)
		{
			dlm[i] = new DefaultListModel<String>();
			jlist[i]= new JList<String>(dlm[i]);
			
			JScrollPane jscp = new JScrollPane(jlist[i]);
			jscp.setPreferredSize(new Dimension(90, 290));
			
			if(i%2==0)
				jpn1.add(jscp);
			else
				jpn2.add(jscp);
		}
		
		jtf1 = new JTextField();
		jtf2 = new JTextField();
		JButton jbtn1 = new JButton("Ekle");
		JButton jbtn2 = new JButton("Sil");		
		jtf1.setPreferredSize(new Dimension(90, 30));
		jtf2.setPreferredSize(new Dimension(90, 30));	
		jbtn1.setPreferredSize(new Dimension(90, 30));
		jbtn2.setPreferredSize(new Dimension(90, 30));
			
		jpn1.add(jtf1);
		jpn1.add(jbtn1);
		jpn2.add(jtf2);
		jpn2.add(jbtn2);
		
		jpn_main.add(jpn1);
		jpn_main.add(jpn2);
		
		jbtn1.setActionCommand("ekle");
		jbtn1.addActionListener(this);
		jbtn2.addActionListener(this);
		this.add(jpn_main);
	
		Connection conn = baglan();
		verigetir(conn);
		
		this.setVisible(true);
		
		
	}

	public void verigetir(Connection conn)
	{
		if(conn==null)
			return;
		
		try{
			dlm[0].clear();
			dlm[1].clear();
			dlm[2].clear(); // id ler silindi
			
			String sql = "select id,isim,telno from kullanicilar order by isim";
			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(sql);
			
			while(rs.next())
			{
				dlm[0].addElement(rs.getString("isim"));
				dlm[1].addElement(rs.getString("telno"));
				dlm[2].addElement(rs.getString("id")); // id ler listeye yukleniyor
			}
			
						
		}
		catch(Exception ex)
		{
			JOptionPane.showMessageDialog(this, "Sorgu Hatasi!");
		}
		
	}
	
	@Override
	public void actionPerformed(ActionEvent arg0) {
		
		Connection conn = baglan();
		if(conn==null)
			return;
		try{		
			if(arg0.getActionCommand().equals("ekle"))
			{
				String sql="insert into kullanicilar (isim,telno) values(?,?)";
					
				if(jtf1.getText().length()>0 && jtf2.getText().length()>0)
				{
					PreparedStatement ps = conn.prepareStatement(sql);
					ps.setString(1, jtf1.getText());
					ps.setString(2, jtf2.getText());
					ps.executeUpdate();
					jtf1.setText("");
					jtf2.setText("");
				}
			}
			else
			{
				int secilen = jlist[0].getSelectedIndex();
				
				if(secilen>-1)
				{
					String id = dlm[2].get(secilen);
					String sql = "delete from kullanicilar where id=?;";
	
					PreparedStatement ps = conn.prepareStatement(sql);
					ps.setString(1, id);
					int say = ps.executeUpdate();
					//JOptionPane.showMessageDialog(this, "Silinen kayit:"+say);
				}
				
			}
		}catch(Exception ex)
		{
			JOptionPane.showMessageDialog(this, "Hata: "+ex.getMessage());
		}
		
		verigetir(conn);
		
	}
	
	public Connection baglan()
	{
		Connection conn = null;
		try{
			
			Class.forName("org.sqlite.JDBC");
			conn=DriverManager.getConnection("jdbc:sqlite:orgun1h7_1.db");
			
		}catch(Exception ex)
		{
			JOptionPane.showMessageDialog(this, "Baglanti Hatasi!");
		}
		return conn;
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		new veritabani();

	}

}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class veritabani extends JFrame implements ActionListener {

DefaultListModel<String>[] dlm;

JList<String>[] jlist;

JTextField jtf1,jtf2;

public veritabani()

{

this.setTitle("Telefon Rehberi");

this.setSize(200,400);

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setLayout(new FlowLayout());

JPanel jpn_main= new JPanel();

jpn_main.setLayout(new GridLayout(1,2));

jpn_main.setPreferredSize(new Dimension(190, 390));

JLabel jlab1= new JLabel("İsim");

JLabel jlab2= new JLabel("Telefon No");

JPanel jpn1= new JPanel();

JPanel jpn2= new JPanel();

jpn1.add(jlab1);

jpn2.add(jlab2);

dlm= new DefaultListModel[3];

jlist = new JList[2];

dlm[2] = new DefaultListModel<String>(); // id listesi

for(int i=0;i<2;i++)

{

dlm[i] = new DefaultListModel<String>();

jlist[i]= new JList<String>(dlm[i]);

JScrollPane jscp = new JScrollPane(jlist[i]);

jscp.setPreferredSize(new Dimension(90, 290));

if(i%2==0)

jpn1.add(jscp);

else

jpn2.add(jscp);

}

jtf1 = new JTextField();

jtf2 = new JTextField();

JButton jbtn1 = new JButton("Ekle");

JButton jbtn2 = new JButton("Sil");

jtf1.setPreferredSize(new Dimension(90, 30));

jtf2.setPreferredSize(new Dimension(90, 30));

jbtn1.setPreferredSize(new Dimension(90, 30));

jbtn2.setPreferredSize(new Dimension(90, 30));

jpn1.add(jtf1);

jpn1.add(jbtn1);

jpn2.add(jtf2);

jpn2.add(jbtn2);

jpn_main.add(jpn1);

jpn_main.add(jpn2);

jbtn1.setActionCommand("ekle");

jbtn1.addActionListener(this);

jbtn2.addActionListener(this);

this.add(jpn_main);

Connection conn = baglan();

verigetir(conn);

this.setVisible(true);

}

public void verigetir(Connection conn)

{

if(conn==null)

return;

try{

dlm[0].clear();

dlm[1].clear();

dlm[2].clear(); // id ler silindi

String sql = "select id,isim,telno from kullanicilar order by isim";

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery(sql);

while(rs.next())

{

dlm[0].addElement(rs.getString("isim"));

dlm[1].addElement(rs.getString("telno"));

dlm[2].addElement(rs.getString("id")); // id ler listeye yukleniyor

}

catch(Exception ex)

{

JOptionPane.showMessageDialog(this, "Sorgu Hatasi!");

}

@Override

public void actionPerformed(ActionEvent arg0) {

Connection conn = baglan();

if(conn==null)

return;

try{

if(arg0.getActionCommand().equals("ekle"))

{

String sql="insert into kullanicilar (isim,telno) values(?,?)";

if(jtf1.getText().length()>0 && jtf2.getText().length()>0)

{

PreparedStatement ps = conn.prepareStatement(sql);

ps.setString(1, jtf1.getText());

ps.setString(2, jtf2.getText());

ps.executeUpdate();

jtf1.setText("");

jtf2.setText("");

}

else

{

int secilen = jlist[0].getSelectedIndex();

if(secilen>-1)

{

String id = dlm[2].get(secilen);

String sql = "delete from kullanicilar where id=?;";

PreparedStatement ps = conn.prepareStatement(sql);

ps.setString(1, id);

int say = ps.executeUpdate();

//JOptionPane.showMessageDialog(this, "Silinen kayit:"+say);

}

}catch(Exception ex)

{

JOptionPane.showMessageDialog(this, "Hata: "+ex.getMessage());

}

verigetir(conn);

}

public Connection baglan()

{

Connection conn = null;

try{

Class.forName("org.sqlite.JDBC");

conn=DriverManager.getConnection("jdbc:sqlite:orgun1h7_1.db");

}catch(Exception ex)

{

JOptionPane.showMessageDialog(this, "Baglanti Hatasi!");

}

return conn;

}

/**

* @param args

public static void main(String[] args) {

new veritabani();

}

NTP2 (Bahar-2016) Hafta-7/1 sqlite-jdbc

Etiketler: createStatement, delete, executeQuery, getSelectedIndex, jdbc:sqlite, JOptionPane, org.sqlite.JDBC, PreparedStatement, ResultSet, sqlite, Statement, swing

Nesne Tabanlı Programlama-2 (Bahar-2016) Hafta-6/1

caglarPosted on 22 Mart 2017 Ders Notları, JAVA, Nesne Tabanlı Programlama-2, Yazılım kategorisine gönderildi No Comments

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;


public class veritabani extends JFrame implements ActionListener {
	
	DefaultListModel<String> dlm;
	public veritabani()
	{
		this.setTitle("Veritabanina Giris:Sqlite");
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		this.setSize(150,300);
		this.setLayout(new FlowLayout());
		
		JPanel jpn_main= new JPanel();
		jpn_main.setPreferredSize(new Dimension(140, 290));
		
		dlm = new DefaultListModel<String>();
		JList<String> jl = new JList<String>(dlm);
		JScrollPane jscp = new JScrollPane(jl);
		jscp.setPreferredSize(new Dimension(130, 250));
		
		JButton jbtn = new JButton("Göster");
		jbtn.setPreferredSize(new Dimension(130, 30));
		jbtn.addActionListener(this);
		
		jpn_main.add(jscp);
		jpn_main.add(jbtn);
		
		this.add(jpn_main);
		this.setVisible(true);
		
	}
	
	@Override
	public void actionPerformed(ActionEvent arg0) {
		
		Connection conn = baglan();
		if(conn!=null)
		{
			dlm.clear();
			
			try{
				
				String sql = "select isim from kisiler;";
				Statement st = conn.createStatement();
				ResultSet rs = st.executeQuery(sql);
				
				while(rs.next())
				{
					dlm.addElement(rs.getString("isim"));
				}
				
			}catch(Exception ex)
			{
				JOptionPane.showMessageDialog(this, ex.getMessage());
			}			
		}	
	}
	
	public Connection baglan()
	{
		Connection conn=null;
		try{
			
			Class.forName("org.sqlite.JDBC");
			conn=DriverManager.getConnection("jdbc:sqlite:orgun1hafta6.db");
			
		}catch(Exception ex)
		{
			JOptionPane.showMessageDialog(this, "Baglanti Hatasi!");
		}
		
		return conn;
		
	}
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		new veritabani();

	}
}

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class veritabani extends JFrame implements ActionListener {

DefaultListModel<String> dlm;

public veritabani()

{

this.setTitle("Veritabanina Giris:Sqlite");

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setSize(150,300);

this.setLayout(new FlowLayout());

JPanel jpn_main= new JPanel();

jpn_main.setPreferredSize(new Dimension(140, 290));

dlm = new DefaultListModel<String>();

JList<String> jl = new JList<String>(dlm);

JScrollPane jscp = new JScrollPane(jl);

jscp.setPreferredSize(new Dimension(130, 250));

JButton jbtn = new JButton("Göster");

jbtn.setPreferredSize(new Dimension(130, 30));

jbtn.addActionListener(this);

jpn_main.add(jscp);

jpn_main.add(jbtn);

this.add(jpn_main);

this.setVisible(true);

}

@Override

public void actionPerformed(ActionEvent arg0) {

Connection conn = baglan();

if(conn!=null)

{

dlm.clear();

try{

String sql = "select isim from kisiler;";

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery(sql);

while(rs.next())

{

dlm.addElement(rs.getString("isim"));

}

}catch(Exception ex)

{

JOptionPane.showMessageDialog(this, ex.getMessage());

}

public Connection baglan()

{

Connection conn=null;

try{

Class.forName("org.sqlite.JDBC");

conn=DriverManager.getConnection("jdbc:sqlite:orgun1hafta6.db");

}catch(Exception ex)

{

JOptionPane.showMessageDialog(this, "Baglanti Hatasi!");

}

return conn;

}

/**

* @param args

public static void main(String[] args) {

new veritabani();

}

NTP2 (Bahar-2016) Hafta-6/1 sqlite-jdbc

Etiketler: createStatement, executeQuery, jdbc:sqlite, JOptionPane, org.sqlite.JDBC, ResultSet, sqlite, Statement, swing