setQueryTimeout – oflazoglu.org

Etiket: setQueryTimeout

Java-2(2015) 7. Hafta Swing Uygulamaları

caglarPosted on 20 Mart 2015 Genel, JAVA, JAVA-II, Yazılım kategorisine gönderildi No Comments

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

public class ornek1 implements ActionListener{
DefaultListModel lad,lmiktar,lfiyat,lid;
JTextField jtfad,jtfmiktar,jtffiyat;
JList jl1;

ornek1(){
JFrame jfrm = new JFrame("Alışveriş Sepeti");
jfrm.setSize(400,320);
jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jfrm.setLayout(new GridLayout(1,3));

lad= new DefaultListModel();
lmiktar= new DefaultListModel();
lfiyat= new DefaultListModel();

JPanel jpn1= new JPanel();
jl1 = new JList(lad);
JScrollPane jsp1 = new JScrollPane(jl1);
jsp1.setPreferredSize(new Dimension(100,200));
jpn1.add(jsp1);
jtfad= new JTextField();
jtfad.setPreferredSize(new Dimension(100,20));
jpn1.add(jtfad);
JButton jbtn1 = new JButton("Ekle");
jbtn1.setActionCommand("ekle");
jbtn1.addActionListener(this);
jpn1.add(jbtn1);

JPanel jpn2= new JPanel();
JList jl2 = new JList(lmiktar);
JScrollPane jsp2 = new JScrollPane(jl2);
jsp2.setPreferredSize(new Dimension(100,200));
jpn2.add(jsp2);
jtfmiktar= new JTextField();
jtfmiktar.setPreferredSize(new Dimension(100,20));
jpn2.add(jtfmiktar);
JButton jbtn2 = new JButton("Sil");
jbtn2.setActionCommand("sil");
jbtn2.addActionListener(this);
jpn2.add(jbtn2);

JPanel jpn3= new JPanel();
JList jl3 = new JList(lfiyat);
JScrollPane jsp3 = new JScrollPane(jl3);
jsp3.setPreferredSize(new Dimension(100,200));
jpn3.add(jsp3);
jtffiyat= new JTextField();
jtffiyat.setPreferredSize(new Dimension(100,20));
jpn3.add(jtffiyat);
JButton jbtn3 = new JButton("Güncelle");
jbtn3.setActionCommand("guncelle");
jbtn3.addActionListener(this);
jpn3.add(jbtn3);
jfrm.add(jpn1);
jfrm.add(jpn2);
jfrm.add(jpn3);
verigetir();
jfrm.setVisible(true);
}
public Connection baglan()
{
Connection conn=null;

try{
Class.forName("org.sqlite.JDBC");
conn=DriverManager.getConnection("jdbc:sqlite:hafta7.db");
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null,"Bağlantı yapılamadı!","Hata",0);
}
return conn;
}

public void verigetir()
{
Connection conn=null;
try{
conn = baglan();

lid = new DefaultListModel();

String sql = "select id,ad,miktar,fiyat from sepet;";

Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);

lad.clear();
lmiktar.clear();
lfiyat.clear();

while(rs.next())
{
lid.addElement(rs.getInt("id"));
lad.addElement(rs.getString("ad"));
lmiktar.addElement(rs.getString("miktar"));
lfiyat.addElement(rs.getString("fiyat"));
}

}
catch(Exception ex) {}

}

public int alankontrol()
{

if(jtfad.getText().length()>0 && jtfmiktar.getText().length()>0 && jtffiyat.getText().length()>0){

int deger=-1;
try{
deger=Integer.parseInt(jtffiyat.getText());
}catch(Exception ex){
JOptionPane.showMessageDialog(null,"Fiyat numerik olmalı!","Hata",0);
}

return deger;

}

return -1;
}

public void actionPerformed(ActionEvent ae)
{

Connection conn = baglan();

if(ae.getActionCommand().equals("ekle"))
{

try{
int fiyat=alankontrol();
if(fiyat>-1)
{
String sql="insert into sepet(ad,miktar,fiyat) values(?,?,?);";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,jtfad.getText());
ps.setString(2,jtfmiktar.getText());
ps.setInt(3,fiyat);
ps.executeUpdate();

jtfad.setText("");
jtfmiktar.setText("");
jtffiyat.setText("");

}
}
catch(Exception ex){}

} else
if(ae.getActionCommand().equals("sil"))
{

try{
int selected=jl1.getSelectedIndex();

if(selected>-1)
{
int index=(int)lid.get(selected);

String sql="delete from sepet where id=?;";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1,index);
ps.executeUpdate();
}
}

catch(Exception ex){}
} else
if(ae.getActionCommand().equals("guncelle"))
{

try{
int selected=jl1.getSelectedIndex();
int fiyat=alankontrol();

if(selected>-1 && fiyat>-1)
{
int index=(int)lid.get(selected);

String sql="update sepet set ad=?,miktar=?, fiyat=? where id=?;";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,jtfad.getText());
ps.setString(2,jtfmiktar.getText());
ps.setInt(3,fiyat);
ps.setInt(4,index);
ps.executeUpdate();

jtfad.setText("");
jtfmiktar.setText("");
jtffiyat.setText("");
}
}

catch(Exception ex){}

}

try
{
conn.close();
}
catch(Exception ex){}

verigetir();

}
public static void main(String[] asdasd)
{
new ornek1();
}
}

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

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class ornek1 implements ActionListener{

DefaultListModel lad,lmiktar,lfiyat,lid;

JTextField jtfad,jtfmiktar,jtffiyat;

JList jl1;

ornek1(){

JFrame jfrm = new JFrame("Alışveriş Sepeti");

jfrm.setSize(400,320);

jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

jfrm.setLayout(new GridLayout(1,3));

lad= new DefaultListModel();

lmiktar= new DefaultListModel();

lfiyat= new DefaultListModel();

JPanel jpn1= new JPanel();

jl1 = new JList(lad);

JScrollPane jsp1 = new JScrollPane(jl1);

jsp1.setPreferredSize(new Dimension(100,200));

jpn1.add(jsp1);

jtfad= new JTextField();

jtfad.setPreferredSize(new Dimension(100,20));

jpn1.add(jtfad);

JButton jbtn1 = new JButton("Ekle");

jbtn1.setActionCommand("ekle");

jbtn1.addActionListener(this);

jpn1.add(jbtn1);

JPanel jpn2= new JPanel();

JList jl2 = new JList(lmiktar);

JScrollPane jsp2 = new JScrollPane(jl2);

jsp2.setPreferredSize(new Dimension(100,200));

jpn2.add(jsp2);

jtfmiktar= new JTextField();

jtfmiktar.setPreferredSize(new Dimension(100,20));

jpn2.add(jtfmiktar);

JButton jbtn2 = new JButton("Sil");

jbtn2.setActionCommand("sil");

jbtn2.addActionListener(this);

jpn2.add(jbtn2);

JPanel jpn3= new JPanel();

JList jl3 = new JList(lfiyat);

JScrollPane jsp3 = new JScrollPane(jl3);

jsp3.setPreferredSize(new Dimension(100,200));

jpn3.add(jsp3);

jtffiyat= new JTextField();

jtffiyat.setPreferredSize(new Dimension(100,20));

jpn3.add(jtffiyat);

JButton jbtn3 = new JButton("Güncelle");

jbtn3.setActionCommand("guncelle");

jbtn3.addActionListener(this);

jpn3.add(jbtn3);

jfrm.add(jpn1);

jfrm.add(jpn2);

jfrm.add(jpn3);

verigetir();

jfrm.setVisible(true);

}

public Connection baglan()

{

Connection conn=null;

try{

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

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

}

catch(Exception ex)

{

JOptionPane.showMessageDialog(null,"Bağlantı yapılamadı!","Hata",0);

}

return conn;

}

public void verigetir()

{

Connection conn=null;

try{

conn = baglan();

lid = new DefaultListModel();

String sql = "select id,ad,miktar,fiyat from sepet;";

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery(sql);

lad.clear();

lmiktar.clear();

lfiyat.clear();

while(rs.next())

{

lid.addElement(rs.getInt("id"));

lad.addElement(rs.getString("ad"));

lmiktar.addElement(rs.getString("miktar"));

lfiyat.addElement(rs.getString("fiyat"));

}

catch(Exception ex) {}

}

public int alankontrol()

{

if(jtfad.getText().length()>0 && jtfmiktar.getText().length()>0 && jtffiyat.getText().length()>0){

int deger=-1;

try{

deger=Integer.parseInt(jtffiyat.getText());

}catch(Exception ex){

JOptionPane.showMessageDialog(null,"Fiyat numerik olmalı!","Hata",0);

}

return deger;

}

return -1;

}

public void actionPerformed(ActionEvent ae)

{

Connection conn = baglan();

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

{

try{

int fiyat=alankontrol();

if(fiyat>-1)

{

String sql="insert into sepet(ad,miktar,fiyat) values(?,?,?);";

PreparedStatement ps = conn.prepareStatement(sql);

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

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

ps.setInt(3,fiyat);

ps.executeUpdate();

jtfad.setText("");

jtfmiktar.setText("");

jtffiyat.setText("");

}

catch(Exception ex){}

} else

if(ae.getActionCommand().equals("sil"))

{

try{

int selected=jl1.getSelectedIndex();

if(selected>-1)

{

int index=(int)lid.get(selected);

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

PreparedStatement ps = conn.prepareStatement(sql);

ps.setInt(1,index);

ps.executeUpdate();

}

catch(Exception ex){}

} else

if(ae.getActionCommand().equals("guncelle"))

{

try{

int selected=jl1.getSelectedIndex();

int fiyat=alankontrol();

if(selected>-1 && fiyat>-1)

{

int index=(int)lid.get(selected);

String sql="update sepet set ad=?,miktar=?, fiyat=? where id=?;";

PreparedStatement ps = conn.prepareStatement(sql);

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

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

ps.setInt(3,fiyat);

ps.setInt(4,index);

ps.executeUpdate();

jtfad.setText("");

jtfmiktar.setText("");

jtffiyat.setText("");

}

catch(Exception ex){}

}

try

{

conn.close();

}

catch(Exception ex){}

verigetir();

}

public static void main(String[] asdasd)

{

new ornek1();

}

Java2 2015 Hafta-7 Eklentiler

Etiketler: addElement, Connection, createStatement, executeQuery, executeUpdate, getString, java, java2, JDBC, ResultSet, setQueryTimeout, showMessageDialog, sqlite, sqlite-jdbc.jar, Statement

Java-2(2015) 6. Hafta Swing Uygulamaları

caglarPosted on 6 Mart 2015 Ders Notları, JAVA, JAVA-II, Yazılım kategorisine gönderildi No Comments

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

public class ornek1 implements ActionListener
{
DefaultListModel lm;
ornek1()
{
JFrame jfrm = new JFrame("SQLite Veritabanı");
jfrm.setSize(150,290);
jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jfrm.setLayout(new FlowLayout());

lm= new DefaultListModel();
JList jls = new JList(lm);
JScrollPane jscp = new JScrollPane(jls);
jscp.setPreferredSize(new Dimension(115,190));

jfrm.add(jscp);

JButton jbtn = new JButton("Getir");
jbtn.addActionListener(this);
jfrm.add(jbtn);

jfrm.setVisible(true);
}

public void actionPerformed(ActionEvent ae)
{
	Connection conn=null;	
	try{

	Class.forName("org.sqlite.JDBC"); // veritabani sinifimiz
	conn=DriverManager.getConnection("jdbc:sqlite:hafta6.db"); // veritabanimiz
	Statement st = conn.createStatement();
	st.setQueryTimeout(30);

	ResultSet rs = st.executeQuery("select adsoyad from musteri;"); // executeUpdate(); 
	
	lm.clear();
	while(rs.next())
	{
		lm.addElement(rs.getString("adsoyad"));
	}

	}
	catch(Exception ex){
		JOptionPane.showMessageDialog(null,ex,"Hata!",0);
	}
	
	try{
		conn.close();
	}
	catch(Exception ex)
	{
	
	}	
}

public static void main(String[] asdasd)
{
new ornek1();
}

}

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class ornek1 implements ActionListener

{

DefaultListModel lm;

ornek1()

{

JFrame jfrm = new JFrame("SQLite Veritabanı");

jfrm.setSize(150,290);

jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

jfrm.setLayout(new FlowLayout());

lm= new DefaultListModel();

JList jls = new JList(lm);

JScrollPane jscp = new JScrollPane(jls);

jscp.setPreferredSize(new Dimension(115,190));

jfrm.add(jscp);

JButton jbtn = new JButton("Getir");

jbtn.addActionListener(this);

jfrm.add(jbtn);

jfrm.setVisible(true);

}

public void actionPerformed(ActionEvent ae)

{

Connection conn=null;

try{

Class.forName("org.sqlite.JDBC"); // veritabani sinifimiz

conn=DriverManager.getConnection("jdbc:sqlite:hafta6.db"); // veritabanimiz

Statement st = conn.createStatement();

st.setQueryTimeout(30);

ResultSet rs = st.executeQuery("select adsoyad from musteri;"); // executeUpdate();

lm.clear();

while(rs.next())

{

lm.addElement(rs.getString("adsoyad"));

}

catch(Exception ex){

JOptionPane.showMessageDialog(null,ex,"Hata!",0);

}

try{

conn.close();

}

catch(Exception ex)

{

}

public static void main(String[] asdasd)

{

new ornek1();

}

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

public class ornek2 implements ActionListener
{
DefaultListModel lmadsoyad,lmtelno,lmadres;
JTextField jtfadsoyad,jtftelno,jtfadres;

ornek2()
{
JFrame jfrm = new JFrame("SQLite Veritabanı-2");
jfrm.setSize(450,325);
jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jfrm.setLayout(new FlowLayout());

JPanel jpdis1 = new JPanel();
jpdis1.setLayout(new GridLayout(1,3)); // 1 satir 3 sutun
JPanel jpdis2 = new JPanel();

jfrm.add(jpdis1);
jfrm.add(jpdis2);

JPanel jp1 = new JPanel();
jp1.setPreferredSize(new Dimension(125,220));
JPanel jp2 = new JPanel();
jp2.setPreferredSize(new Dimension(125,220));
JPanel jp3 = new JPanel();
jp3.setPreferredSize(new Dimension(125,220));

jpdis1.add(jp1);
jpdis1.add(jp2);
jpdis1.add(jp3);

lmadsoyad= new DefaultListModel();
lmtelno= new DefaultListModel();
lmadres= new DefaultListModel();

JList jls1 = new JList(lmadsoyad);
JScrollPane jscp1 = new JScrollPane(jls1);
jscp1.setPreferredSize(new Dimension(115,190));
jtfadsoyad= new JTextField(10);
jp1.add(jscp1);
jp1.add(jtfadsoyad);


JList jls2 = new JList(lmtelno);
JScrollPane jscp2 = new JScrollPane(jls2);
jscp2.setPreferredSize(new Dimension(115,190));
jtftelno= new JTextField(10);
jp2.add(jscp2);
jp2.add(jtftelno);

JList jls3 = new JList(lmadres);
JScrollPane jscp3 = new JScrollPane(jls3);
jscp3.setPreferredSize(new Dimension(115,190));
jtfadres= new JTextField(10);
jp3.add(jscp3);
jp3.add(jtfadres);


JButton jbtn = new JButton("Ekle");
jbtn.addActionListener(this);
jpdis2.add(jbtn);

//jfrm.pack();
verigetir();
jfrm.setVisible(true);
}

public Connection baglan()
{
	Connection conn=null;
	try{
	Class.forName("org.sqlite.JDBC"); // veritabani sinifimiz
	conn=DriverManager.getConnection("jdbc:sqlite:hafta6.db"); // veritabanimiz
	}
	catch(Exception ex)
	{
		JOptionPane.showMessageDialog(null,ex,"Hata-1!",0);
	}	
	return conn;

}

public void verigetir()
{

Connection conn=null;	
	try{
	conn=baglan();
	Statement st = conn.createStatement();
	st.setQueryTimeout(30);

	ResultSet rs = st.executeQuery("select adsoyad,telno,adres from musteri;"); 
	
	lmadsoyad.clear();
	lmtelno.clear();
	lmadres.clear();	
	while(rs.next())
	{
		lmadsoyad.addElement(rs.getString("adsoyad"));
		lmtelno.addElement(rs.getString("telno"));
		lmadres.addElement(rs.getString("adres"));
	}

	}
	catch(Exception ex){
		JOptionPane.showMessageDialog(null,ex,"Hata!",0);
	}
	
	try{
		conn.close();
	}
	catch(Exception ex)
	{
	
	}	


}

public void actionPerformed(ActionEvent ae)
{
	Connection conn=null;	
	try{
	conn=baglan();
	Statement st = conn.createStatement();
	st.setQueryTimeout(30);

	if(jtfadsoyad.getText().length()>0 && jtftelno.getText().length()>0 && jtfadres.getText().length()>0)
	{
	st.executeUpdate("insert into musteri(adsoyad,telno,adres) values('"+jtfadsoyad.getText()+"','"+jtftelno.getText()+"','"+jtfadres.getText()+"');"); 
	
	jtfadsoyad.setText("");
	jtftelno.setText("");
	jtfadres.setText("");
	
	}
	
	}
	catch(Exception ex){
		JOptionPane.showMessageDialog(null,ex,"Hata!",0);
	}
	
	try{
		conn.close();
	}
	catch(Exception ex)
	{
	
	}
	verigetir();
}

public static void main(String[] asdasd)
{
new ornek2();
}

}

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

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class ornek2 implements ActionListener

{

DefaultListModel lmadsoyad,lmtelno,lmadres;

JTextField jtfadsoyad,jtftelno,jtfadres;

ornek2()

{

JFrame jfrm = new JFrame("SQLite Veritabanı-2");

jfrm.setSize(450,325);

jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

jfrm.setLayout(new FlowLayout());

JPanel jpdis1 = new JPanel();

jpdis1.setLayout(new GridLayout(1,3)); // 1 satir 3 sutun

JPanel jpdis2 = new JPanel();

jfrm.add(jpdis1);

jfrm.add(jpdis2);

JPanel jp1 = new JPanel();

jp1.setPreferredSize(new Dimension(125,220));

JPanel jp2 = new JPanel();

jp2.setPreferredSize(new Dimension(125,220));

JPanel jp3 = new JPanel();

jp3.setPreferredSize(new Dimension(125,220));

jpdis1.add(jp1);

jpdis1.add(jp2);

jpdis1.add(jp3);

lmadsoyad= new DefaultListModel();

lmtelno= new DefaultListModel();

lmadres= new DefaultListModel();

JList jls1 = new JList(lmadsoyad);

JScrollPane jscp1 = new JScrollPane(jls1);

jscp1.setPreferredSize(new Dimension(115,190));

jtfadsoyad= new JTextField(10);

jp1.add(jscp1);

jp1.add(jtfadsoyad);

JList jls2 = new JList(lmtelno);

JScrollPane jscp2 = new JScrollPane(jls2);

jscp2.setPreferredSize(new Dimension(115,190));

jtftelno= new JTextField(10);

jp2.add(jscp2);

jp2.add(jtftelno);

JList jls3 = new JList(lmadres);

JScrollPane jscp3 = new JScrollPane(jls3);

jscp3.setPreferredSize(new Dimension(115,190));

jtfadres= new JTextField(10);

jp3.add(jscp3);

jp3.add(jtfadres);

JButton jbtn = new JButton("Ekle");

jbtn.addActionListener(this);

jpdis2.add(jbtn);

//jfrm.pack();

verigetir();

jfrm.setVisible(true);

}

public Connection baglan()

{

Connection conn=null;

try{

Class.forName("org.sqlite.JDBC"); // veritabani sinifimiz

conn=DriverManager.getConnection("jdbc:sqlite:hafta6.db"); // veritabanimiz

}

catch(Exception ex)

{

JOptionPane.showMessageDialog(null,ex,"Hata-1!",0);

}

return conn;

}

public void verigetir()

{

Connection conn=null;

try{

conn=baglan();

Statement st = conn.createStatement();

st.setQueryTimeout(30);

ResultSet rs = st.executeQuery("select adsoyad,telno,adres from musteri;");

lmadsoyad.clear();

lmtelno.clear();

lmadres.clear();

while(rs.next())

{

lmadsoyad.addElement(rs.getString("adsoyad"));

lmtelno.addElement(rs.getString("telno"));

lmadres.addElement(rs.getString("adres"));

}

catch(Exception ex){

JOptionPane.showMessageDialog(null,ex,"Hata!",0);

}

try{

conn.close();

}

catch(Exception ex)

{

}

public void actionPerformed(ActionEvent ae)

{

Connection conn=null;

try{

conn=baglan();

Statement st = conn.createStatement();

st.setQueryTimeout(30);

if(jtfadsoyad.getText().length()>0 && jtftelno.getText().length()>0 && jtfadres.getText().length()>0)

{

st.executeUpdate("insert into musteri(adsoyad,telno,adres) values('"+jtfadsoyad.getText()+"','"+jtftelno.getText()+"','"+jtfadres.getText()+"');");

jtfadsoyad.setText("");

jtftelno.setText("");

jtfadres.setText("");

}

catch(Exception ex){

JOptionPane.showMessageDialog(null,ex,"Hata!",0);

}

try{

conn.close();

}

catch(Exception ex)

{

}

verigetir();

}

public static void main(String[] asdasd)

{

new ornek2();

}

Java2 2015 Hafta-6 Eklentiler

Etiketler: addElement, Connection, createStatement, executeQuery, executeUpdate, getString, java, java2, JDBC, ResultSet, setQueryTimeout, showMessageDialog, sqlite, sqlite-jdbc.jar, Statement