Mayıs 2016 – oflazoglu.org

Aylar: Mayıs 2016

NYP-2 2016 11. Hafta Uygulamaları

Posted on 13 Mayıs 2016 by

caglar C#, Ders Notları, Nesneye Yönelik Programlama-II, Yazılım kategorisine gönderildi — 2 Yorum ↓

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace recel
{
    public partial class Form1 : Form
    {
        MySqlDataAdapter da_kalite, da_urun;
        DataTable dt_kalite;

        public Form1()
        {
            InitializeComponent();

            MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();
            bag.Server = "localhost";
            bag.UserID = "root";
            bag.Password = "123456";
            bag.Database = "hafta11_16_2";

            MySqlConnection conn = new MySqlConnection(bag.ToString());

            MySqlCommand cmd_urun_sel = 
                new MySqlCommand("select id,kaliteid,miktar from urun;", conn);
            MySqlCommand cmd_urun_ins = 
                new MySqlCommand("insert into urun(kaliteid,miktar) values(@kaliteid,@miktar);", conn);
            cmd_urun_ins.Parameters.Add("@kaliteid", MySqlDbType.Int32, 11, "kaliteid");
            cmd_urun_ins.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");

            da_urun = new MySqlDataAdapter();
            da_urun.SelectCommand = cmd_urun_sel;
            da_urun.InsertCommand = cmd_urun_ins;

            MySqlCommand cmd_kalite_sel = 
                new MySqlCommand("select id,ad,oran1,oran2,oran3 from kalite;", conn);
            MySqlCommand cmd_kalite_ins =
                new MySqlCommand("insert into kalite(ad,oran1,oran2,oran3) values(@ad,@oran1,@oran2,@oran3);", conn);
            cmd_kalite_ins.Parameters.Add("@ad",MySqlDbType.VarChar,45,"ad");
            cmd_kalite_ins.Parameters.Add("@oran1", MySqlDbType.Double, 11, "oran1");
            cmd_kalite_ins.Parameters.Add("@oran2", MySqlDbType.Double, 11, "oran2");
            cmd_kalite_ins.Parameters.Add("@oran3", MySqlDbType.Double, 11, "oran3");

            MySqlCommand cmd_kalite_upd = 
                new MySqlCommand("update kalite set ad=@ad,oran1=@oran1,oran2=@oran2,oran3=@oran3 where id=@id;", conn);
            cmd_kalite_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");
            cmd_kalite_upd.Parameters.Add("@ad", MySqlDbType.VarChar, 45, "ad");
            cmd_kalite_upd.Parameters.Add("@oran1", MySqlDbType.Double, 11, "oran1");
            cmd_kalite_upd.Parameters.Add("@oran2", MySqlDbType.Double, 11, "oran2");
            cmd_kalite_upd.Parameters.Add("@oran3", MySqlDbType.Double, 11, "oran3");

            da_kalite = new MySqlDataAdapter();
            da_kalite.SelectCommand = cmd_kalite_sel;
            da_kalite.InsertCommand = cmd_kalite_ins;
            da_kalite.UpdateCommand = cmd_kalite_upd;


            comboboxdoldur();

        }

        private void comboboxdoldur()
        {
            try
            {
                ckalite.Items.Clear();

                dt_kalite = new DataTable();
                da_kalite.Fill(dt_kalite);

                int say = dt_kalite.Rows.Count;
                for (int i = 0; i < say; i++)
                {
                    ckalite.Items.Add(dt_kalite.Rows[i]["ad"]);
                }
                ckalite.Text = "Seçiniz";

            }
            catch { 
            }

            listboxdoldur();
        }
        private void listboxdoldur()
        {
            lkalite.Items.Clear();
            lmiktar.Items.Clear();
            loran1.Items.Clear();
            loran2.Items.Clear();
            loran3.Items.Clear();

            try
            {
                DataTable dt_urun = new DataTable();
                da_urun.Fill(dt_urun);

                int say = dt_urun.Rows.Count;

                for (int i = 0; i < say; i++)
                {
                    int kaliteid = (int)dt_urun.Rows[i]["kaliteid"];
                    int miktar = (int)dt_urun.Rows[i]["miktar"];

                    DataRow dr = kalitegetir(kaliteid);

                    if (dr != null)
                    {
                        lkalite.Items.Add(dr["ad"]);
                        lmiktar.Items.Add(miktar);
                        loran1.Items.Add(miktar*(double)dr["oran1"]);
                        loran2.Items.Add(miktar * (double)dr["oran2"]);
                        loran3.Items.Add(miktar * (double)dr["oran3"]);

                    }


                }


            }
            catch
            {

            }
        }

        private DataRow kalitegetir(int id)
        {
            DataRow[] dr = dt_kalite.Select("id=" + id);
            if (dr.Length > 0)
                return dr[0];
            return null;
        }

        private void bkalite_Click(object sender, EventArgs e)
        {
            fkalite frm = new fkalite(da_kalite);
            frm.ShowDialog();
            comboboxdoldur();
        }

        private void bekle_Click(object sender, EventArgs e)
        {
            int secilen = ckalite.SelectedIndex;
            int miktar;
            bool k = Int32.TryParse(tmiktar.Text,out miktar);

            if (k && secilen > -1)
            {
                try
                {
                    DataTable dt_urun = new DataTable();
                    da_urun.Fill(dt_urun);

                    DataRow dr = dt_urun.NewRow();

                    dr["kaliteid"] = dt_kalite.Rows[secilen]["id"];
                    dr["miktar"] = miktar;
                    dt_urun.Rows.Add(dr);
                    da_urun.Update(dt_urun);

                    ckalite.Text = "Seçiniz";
                    tmiktar.Clear();
                }
                catch { 
                }
            }
            listboxdoldur();

        }
    }
}

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

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace recel

{

public partial class Form1 : Form

{

MySqlDataAdapter da_kalite, da_urun;

DataTable dt_kalite;

public Form1()

{

InitializeComponent();

MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();

bag.Server = "localhost";

bag.UserID = "root";

bag.Password = "123456";

bag.Database = "hafta11_16_2";

MySqlConnection conn = new MySqlConnection(bag.ToString());

MySqlCommand cmd_urun_sel =

new MySqlCommand("select id,kaliteid,miktar from urun;", conn);

MySqlCommand cmd_urun_ins =

new MySqlCommand("insert into urun(kaliteid,miktar) values(@kaliteid,@miktar);", conn);

cmd_urun_ins.Parameters.Add("@kaliteid", MySqlDbType.Int32, 11, "kaliteid");

cmd_urun_ins.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");

da_urun = new MySqlDataAdapter();

da_urun.SelectCommand = cmd_urun_sel;

da_urun.InsertCommand = cmd_urun_ins;

MySqlCommand cmd_kalite_sel =

new MySqlCommand("select id,ad,oran1,oran2,oran3 from kalite;", conn);

MySqlCommand cmd_kalite_ins =

new MySqlCommand("insert into kalite(ad,oran1,oran2,oran3) values(@ad,@oran1,@oran2,@oran3);", conn);

cmd_kalite_ins.Parameters.Add("@ad",MySqlDbType.VarChar,45,"ad");

cmd_kalite_ins.Parameters.Add("@oran1", MySqlDbType.Double, 11, "oran1");

cmd_kalite_ins.Parameters.Add("@oran2", MySqlDbType.Double, 11, "oran2");

cmd_kalite_ins.Parameters.Add("@oran3", MySqlDbType.Double, 11, "oran3");

MySqlCommand cmd_kalite_upd =

new MySqlCommand("update kalite set ad=@ad,oran1=@oran1,oran2=@oran2,oran3=@oran3 where id=@id;", conn);

cmd_kalite_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

cmd_kalite_upd.Parameters.Add("@ad", MySqlDbType.VarChar, 45, "ad");

cmd_kalite_upd.Parameters.Add("@oran1", MySqlDbType.Double, 11, "oran1");

cmd_kalite_upd.Parameters.Add("@oran2", MySqlDbType.Double, 11, "oran2");

cmd_kalite_upd.Parameters.Add("@oran3", MySqlDbType.Double, 11, "oran3");

da_kalite = new MySqlDataAdapter();

da_kalite.SelectCommand = cmd_kalite_sel;

da_kalite.InsertCommand = cmd_kalite_ins;

da_kalite.UpdateCommand = cmd_kalite_upd;

comboboxdoldur();

}

private void comboboxdoldur()

{

try

{

ckalite.Items.Clear();

dt_kalite = new DataTable();

da_kalite.Fill(dt_kalite);

int say = dt_kalite.Rows.Count;

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

{

ckalite.Items.Add(dt_kalite.Rows[i]["ad"]);

}

ckalite.Text = "Seçiniz";

}

catch {

}

listboxdoldur();

}

private void listboxdoldur()

{

lkalite.Items.Clear();

lmiktar.Items.Clear();

loran1.Items.Clear();

loran2.Items.Clear();

loran3.Items.Clear();

try

{

DataTable dt_urun = new DataTable();

da_urun.Fill(dt_urun);

int say = dt_urun.Rows.Count;

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

{

int kaliteid = (int)dt_urun.Rows[i]["kaliteid"];

int miktar = (int)dt_urun.Rows[i]["miktar"];

DataRow dr = kalitegetir(kaliteid);

if (dr != null)

{

lkalite.Items.Add(dr["ad"]);

lmiktar.Items.Add(miktar);

loran1.Items.Add(miktar*(double)dr["oran1"]);

loran2.Items.Add(miktar * (double)dr["oran2"]);

loran3.Items.Add(miktar * (double)dr["oran3"]);

}

catch

{

}

private DataRow kalitegetir(int id)

{

DataRow[] dr = dt_kalite.Select("id=" + id);

if (dr.Length > 0)

return dr[0];

return null;

}

private void bkalite_Click(object sender, EventArgs e)

{

fkalite frm = new fkalite(da_kalite);

frm.ShowDialog();

comboboxdoldur();

}

private void bekle_Click(object sender, EventArgs e)

{

int secilen = ckalite.SelectedIndex;

int miktar;

bool k = Int32.TryParse(tmiktar.Text,out miktar);

if (k && secilen > -1)

{

try

{

DataTable dt_urun = new DataTable();

da_urun.Fill(dt_urun);

DataRow dr = dt_urun.NewRow();

dr["kaliteid"] = dt_kalite.Rows[secilen]["id"];

dr["miktar"] = miktar;

dt_urun.Rows.Add(dr);

da_urun.Update(dt_urun);

ckalite.Text = "Seçiniz";

tmiktar.Clear();

}

catch {

}

listboxdoldur();

}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;


namespace recel
{
    public partial class fkalite : Form
    {
        MySqlDataAdapter da;
        DataTable dt;
        public fkalite(MySqlDataAdapter _da)
        {
            InitializeComponent();
            da = _da;
            datagrid();
        }

        private void datagrid()
        {
            try
            {
                dt = new DataTable();
                da.Fill(dt);
                dataGridView1.DataSource = dt;
                dataGridView1.AllowUserToDeleteRows = false; // silme islemi iptal
                dataGridView1.Columns["id"].Visible = false;
                dataGridView1.Columns["ad"].HeaderText = "Kalite Adı";
                dataGridView1.Columns["oran1"].HeaderText = "Meyve O.";
                dataGridView1.Columns["oran2"].HeaderText = "Şeker O.";
                dataGridView1.Columns["oran3"].HeaderText = "Su O.";

            }
            catch { 
            }
        }

        private void bkapat_Click(object sender, EventArgs e)
        {
            try
            {
                // dt ayrica (DataTable)dataGridView1.DataSource esittir 
                //da.Update((DataTable)dataGridView1.DataSource);

                da.Update(dt);
                this.Close();
            }
            catch { 
            }


        }
    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace recel

{

public partial class fkalite : Form

{

MySqlDataAdapter da;

DataTable dt;

public fkalite(MySqlDataAdapter _da)

{

InitializeComponent();

da = _da;

datagrid();

}

private void datagrid()

{

try

{

dt = new DataTable();

da.Fill(dt);

dataGridView1.DataSource = dt;

dataGridView1.AllowUserToDeleteRows = false; // silme islemi iptal

dataGridView1.Columns["id"].Visible = false;

dataGridView1.Columns["ad"].HeaderText = "Kalite Adı";

dataGridView1.Columns["oran1"].HeaderText = "Meyve O.";

dataGridView1.Columns["oran2"].HeaderText = "Şeker O.";

dataGridView1.Columns["oran3"].HeaderText = "Su O.";

}

catch {

}

private void bkapat_Click(object sender, EventArgs e)

{

try

{

// dt ayrica (DataTable)dataGridView1.DataSource esittir

//da.Update((DataTable)dataGridView1.DataSource);

da.Update(dt);

this.Close();

}

catch {

}

NYP-2 2016 Hafta-11 Uygulamaları

Java-2 2016 Hafta-11

Posted on 12 Mayıs 2016 by

caglar Ders Notları, JAVA, JAVA-II, Yazılım kategorisine gönderildi — Henüz Yorum Yapılmadı ↓

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


public class market implements ActionListener {

	JList[] jlist;
	DefaultListModel[] dlm;
	JComboBox jcb;
	JTextField jtf;
	JLabel jlab;
	
	public market() {
		
		JFrame jfrm = new JFrame("Market");
		jfrm.setSize(250,275);
		jfrm.setLayout(new FlowLayout());
		jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		
		JPanel jpn_main = new JPanel();
		jpn_main.setLayout(new GridLayout(1,3));
		jpn_main.setPreferredSize(new Dimension(250,275));
		
		JPanel[] jpn = new JPanel[3];
		jlist = new JList[3];
		dlm= new DefaultListModel[5]; // 3 tanesi jlist , +2 tanesi id ler icin (urunlerin id bilgisi, sepetin id bilgisi)
		
		for(int i =0;i<jlist.length;i++)
		{
			jpn[i]= new JPanel();
			dlm[i]= new DefaultListModel();
			jlist[i]=new JList(dlm[i]);
			JScrollPane jscp = new JScrollPane(jlist[i]);
			jscp.setPreferredSize(new Dimension(80,200));
			jpn[i].add(jscp);
			jpn_main.add(jpn[i]);
			
		}
		
		jcb = new JComboBox();
		jcb.setPreferredSize(new Dimension(80,25));
		jtf= new JTextField();
		jtf.setPreferredSize(new Dimension(80,25));
		jlab = new JLabel("Tutar: 0");
		jlab.setPreferredSize(new Dimension(80,25));
		
		jpn[0].add(jcb);
		jpn[1].add(jtf);
		jpn[2].add(jlab);
		
		JButton jbtn_ekle = new JButton("Ekle");
		jbtn_ekle.addActionListener(this);
		jbtn_ekle.setActionCommand("ekle");
		jbtn_ekle.setPreferredSize(new Dimension(80,25));
		JButton jbtn_sil = new JButton("Sil");
		jbtn_sil.addActionListener(this);
		jbtn_sil.setPreferredSize(new Dimension(80,25));

		jpn[0].add(jbtn_ekle);
		jpn[1].add(jbtn_sil);
	
		jfrm.add(jpn_main);
		combodoldur();
		listedoldur();
		jfrm.setVisible(true);
		
	}

	@Override
	public void actionPerformed(ActionEvent ae) {
		
		if(ae.getActionCommand().equals("ekle"))
		{
			// ekle
			
			Connection conn =baglan();
			try {
				
				String sql = "insert into sepet(urunid,miktar) values(?,?);";
				
				int secilen = jcb.getSelectedIndex();
				int miktar = Integer.parseInt(jtf.getText());
				
				
				if(secilen>0)
				{
					int urunid = (int) dlm[3].get(secilen-1); // urunler icin id listesi;
					PreparedStatement ps = conn.prepareStatement(sql);
					ps.setInt(1,urunid);
					ps.setInt(2,miktar);
					ps.executeUpdate();
					
					jcb.setSelectedIndex(0);
					jtf.setText("");
				
					listedoldur();
					
				}
				
			}
			catch(Exception ex)
			{
				System.out.println(ex);
			}
			
			
			
		}
		else
		{
			Connection conn =baglan();
			try {
				String sql = "delete from sepet where id=?;";
				int secilen = jlist[0].getSelectedIndex();
				if(secilen>-1)
				{
					int secilen_id = (int) dlm[4].get(secilen); // urunler icin id listesi;
					PreparedStatement ps = conn.prepareStatement(sql);
					ps.setInt(1,secilen_id);
					ps.executeUpdate();
					listedoldur();
					
				}
			}
			catch(Exception ex)
			{
				System.out.println(ex);
			}
			
		}


	}

	
	public void combodoldur()
	{
		
		try{
			
			Connection conn = baglan();
			if(conn!=null)
			{
				
				String sql = "select id,ad,fiyat from urunler";
				Statement st = conn.createStatement();
				ResultSet rs =st.executeQuery(sql);
				
				dlm[3] = new DefaultListModel(); // urunler tablosunun id bilgisini tutacak olan degisken
				
				jcb.addItem("Seçiniz");
				
				while(rs.next())
				{
					dlm[3].addElement(rs.getInt("id"));
					jcb.addItem(rs.getString("ad"));
					
				}
			}
		}
		catch(Exception ex)
		{
			System.out.println(ex);
		}
		
		
		
	}
	
	public void listedoldur()
	{
		try{
			
			Connection conn = baglan();
			if(conn!=null)
			{
				
				String sql = "select u.ad,u.fiyat*s.miktar as tutar,s.id," +
						"s.miktar from urunler u inner join sepet s on " +
						"s.urunid=u.id";
				Statement st = conn.createStatement();
				ResultSet rs =st.executeQuery(sql);
				
				dlm[0].clear();
				dlm[1].clear();
				dlm[2].clear();
				dlm[4] = new DefaultListModel(); // sepet id bilgisi tutan degisken silme isleminde kullanilacak
				
				int tutar=0;
				
				
				while(rs.next())
				{
					dlm[0].addElement(rs.getString("ad"));
					dlm[1].addElement(rs.getInt("miktar"));
					dlm[2].addElement(rs.getInt("tutar"));
					dlm[4].addElement(rs.getInt("id")); // s.id bilgisi
					
					tutar+=(int)rs.getInt("tutar");
					
				}
				
				jlab.setText("Tutar: "+tutar);
				
			}
		}
		catch(Exception ex)
		{
			System.out.println(ex);
		}
		
	}
	
	
	
	public Connection baglan()
	{
		Connection conn=null;
		try{
			Class.forName("org.sqlite.JDBC");
			conn=DriverManager.getConnection("jdbc:sqlite:market.db"); 
		}
		catch(Exception ex)
		{
			JOptionPane.showMessageDialog(null,"Bağlantı yapılamadı!","Hata",0);
		}
		return conn;	
	}
	
	
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		new market();

	}

}

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

import java.awt.*;

import java.sql.*;

import java.awt.event.*;

import javax.swing.*;

public class market implements ActionListener {

JList[] jlist;

DefaultListModel[] dlm;

JComboBox jcb;

JTextField jtf;

JLabel jlab;

public market() {

JFrame jfrm = new JFrame("Market");

jfrm.setSize(250,275);

jfrm.setLayout(new FlowLayout());

jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

JPanel jpn_main = new JPanel();

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

jpn_main.setPreferredSize(new Dimension(250,275));

JPanel[] jpn = new JPanel[3];

jlist = new JList[3];

dlm= new DefaultListModel[5]; // 3 tanesi jlist , +2 tanesi id ler icin (urunlerin id bilgisi, sepetin id bilgisi)

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

{

jpn[i]= new JPanel();

dlm[i]= new DefaultListModel();

jlist[i]=new JList(dlm[i]);

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

jscp.setPreferredSize(new Dimension(80,200));

jpn[i].add(jscp);

jpn_main.add(jpn[i]);

}

jcb = new JComboBox();

jcb.setPreferredSize(new Dimension(80,25));

jtf= new JTextField();

jtf.setPreferredSize(new Dimension(80,25));

jlab = new JLabel("Tutar: 0");

jlab.setPreferredSize(new Dimension(80,25));

jpn[0].add(jcb);

jpn[1].add(jtf);

jpn[2].add(jlab);

JButton jbtn_ekle = new JButton("Ekle");

jbtn_ekle.addActionListener(this);

jbtn_ekle.setActionCommand("ekle");

jbtn_ekle.setPreferredSize(new Dimension(80,25));

JButton jbtn_sil = new JButton("Sil");

jbtn_sil.addActionListener(this);

jbtn_sil.setPreferredSize(new Dimension(80,25));

jpn[0].add(jbtn_ekle);

jpn[1].add(jbtn_sil);

jfrm.add(jpn_main);

combodoldur();

listedoldur();

jfrm.setVisible(true);

}

@Override

public void actionPerformed(ActionEvent ae) {

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

{

// ekle

Connection conn =baglan();

try {

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

int secilen = jcb.getSelectedIndex();

int miktar = Integer.parseInt(jtf.getText());

if(secilen>0)

{

int urunid = (int) dlm[3].get(secilen-1); // urunler icin id listesi;

PreparedStatement ps = conn.prepareStatement(sql);

ps.setInt(1,urunid);

ps.setInt(2,miktar);

ps.executeUpdate();

jcb.setSelectedIndex(0);

jtf.setText("");

listedoldur();

}

catch(Exception ex)

{

System.out.println(ex);

}

else

{

Connection conn =baglan();

try {

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

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

if(secilen>-1)

{

int secilen_id = (int) dlm[4].get(secilen); // urunler icin id listesi;

PreparedStatement ps = conn.prepareStatement(sql);

ps.setInt(1,secilen_id);

ps.executeUpdate();

listedoldur();

}

catch(Exception ex)

{

System.out.println(ex);

}

public void combodoldur()

{

try{

Connection conn = baglan();

if(conn!=null)

{

String sql = "select id,ad,fiyat from urunler";

Statement st = conn.createStatement();

ResultSet rs =st.executeQuery(sql);

dlm[3] = new DefaultListModel(); // urunler tablosunun id bilgisini tutacak olan degisken

jcb.addItem("Seçiniz");

while(rs.next())

{

dlm[3].addElement(rs.getInt("id"));

jcb.addItem(rs.getString("ad"));

}

catch(Exception ex)

{

System.out.println(ex);

}

public void listedoldur()

{

try{

Connection conn = baglan();

if(conn!=null)

{

String sql = "select u.ad,u.fiyat*s.miktar as tutar,s.id," +

"s.miktar from urunler u inner join sepet s on " +

"s.urunid=u.id";

Statement st = conn.createStatement();

ResultSet rs =st.executeQuery(sql);

dlm[0].clear();

dlm[1].clear();

dlm[2].clear();

dlm[4] = new DefaultListModel(); // sepet id bilgisi tutan degisken silme isleminde kullanilacak

int tutar=0;

while(rs.next())

{

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

dlm[1].addElement(rs.getInt("miktar"));

dlm[2].addElement(rs.getInt("tutar"));

dlm[4].addElement(rs.getInt("id")); // s.id bilgisi

tutar+=(int)rs.getInt("tutar");

}

jlab.setText("Tutar: "+tutar);

}

catch(Exception ex)

{

System.out.println(ex);

}

public Connection baglan()

{

Connection conn=null;

try{

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

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

}

catch(Exception ex)

{

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

}

return conn;

}

/**

* @param args

public static void main(String[] args) {

new market();

}

Java-2 2016 Hafta-11 Uygulamaları

Etiketler: java, java2, sqlite, sqlite-jdbc.jar, swing

Bilgisayar Grafikleri(2016) – OpenGL Hafta-10

Posted on 12 Mayıs 2016 by

caglar Bilgisayar Grafikleri, Ders Notları, OpenGL, Yazılım kategorisine gönderildi — Henüz Yorum Yapılmadı ↓

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.media.opengl.*;
import javax.media.opengl.awt.GLCanvas;
import javax.media.opengl.glu.GLU;
import com.jogamp.opengl.util.FPSAnimator;
import static javax.media.opengl.GL.*;  // GL sabitlerini import et
import static javax.media.opengl.GL2.*; //

//sudo apt-get install libjogl2-java
//.bashrc classpath tanimlamasi
//export CLASSPATH=/usr/share/java/jogl2.jar:/usr/share/java/gluegen2-rt.jar:$CLASSPATH


class vertex{
	float x,y,z;
	vertex(float x,float y, float z)
	{
		this.x=x;
		this.y=y;
		this.z=z;
	}
	void olustur(GL2 gl)
	{
		 gl.glVertex3f(x, y, z);
	}


}


public class taslak extends GLCanvas implements GLEventListener {

   private static String BASLIK = "başlık";
   private static int CIZIMALANI_GENISLIK = 320; 
   private static int CIZIMALANI_YUKSEKLIK = 240;
   private static int FPS = 60; 
   
   private GLU glu;

   public taslak() { //yapilandirici
      this.addGLEventListener(this);
   }	

   public static void main(String[] args) {
      SwingUtilities.invokeLater(new Runnable() {
         public void run() {
            GLCanvas canvas = new taslak(); // upcasting, sınıftan nesne
            canvas.setPreferredSize(new Dimension(CIZIMALANI_GENISLIK, CIZIMALANI_YUKSEKLIK)); // cizim alani boyut tanimlamasi
            final FPSAnimator animator = new FPSAnimator(canvas, FPS, true); // cizim alani 
            JFrame frame = new JFrame(BASLIK); // pencere nesnesi
            frame.getContentPane().add(canvas); // cizim alaninin pencereye eklenmesi
            frame.addWindowListener(new WindowAdapter() {
               public void windowClosing(WindowEvent e) { // program sonlandildiginda
                  new Thread() { 
                     public void run() {
                        if (animator.isStarted()) animator.stop(); // calisiyorsa durdur
                        System.exit(0);
                     }
                  }.start();
               }
            });
            frame.pack(); // pencere boyutunu icerige gore ayarla
            frame.setVisible(true); // pencereyi gorunur yap
            animator.start(); // cizimi baslat
         }
      });
   }
   
   public void dispose(GLAutoDrawable drawable) { }	// kaynaklari serbest birakma 

   // baslangic durumlari

   vertex[] noktalar;		
   public void init(GLAutoDrawable drawable) {
      GL2 gl = drawable.getGL().getGL2();      
      glu = new GLU();                         
      gl.glClearColor(0.0f, 0.0f, 0.0f, 0.0f); // arka plan rengi
      gl.glEnable(GL_DEPTH_TEST);

      noktalar= new vertex[8];
      noktalar[0]=new vertex(1f,1f,1f); // A
      noktalar[1]=new vertex(1f,-1f,1f); // B
      noktalar[2]=new vertex(-1f,-1f,1f); // C
      noktalar[3]=new vertex(-1f,1f,1f); // D

      noktalar[4]=new vertex(1f,1f,-1f); // A'
      noktalar[5]=new vertex(1f,-1f,-1f); // B'
      noktalar[6]=new vertex(-1f,-1f,-1f); // C'
      noktalar[7]=new vertex(-1f,1f,-1f); // D'


   }

   public void cizdir(GL2 gl, int[] index)
   {
      gl.glBegin(GL_QUADS); 
        for(int i=0;i<index.length;i++)
		noktalar[index[i]].olustur(gl);
      gl.glEnd();
 
   } 		


   // cizim alani degisince cizimi olcekle
   public void reshape(GLAutoDrawable drawable, int x, int y, int width, int height) {
      GL2 gl = drawable.getGL().getGL2();  

      float aspect=(float)1.2; // olcek
      gl.glViewport(0, 0, 320, 240); // gorunecek sahnenin pencere uzerindeki koordinatlari ve boyutu (gorus alani) 
      gl.glMatrixMode(GL_PROJECTION);  //izdusum matrisini sec
      gl.glLoadIdentity();  // matrisi baslangic durumuna getir           
      glu.gluPerspective(45.0, aspect, 0.1, 100.0); // persipektif goruntu kameranin bulundugu noktan cikan isinlara ait aci, yeni cercevenin en/boy orani, yeni cercevenin bakis noktasina olan yakinlik ve uzakligi  
      gl.glMatrixMode(GL_MODELVIEW); // model matrisini sec
      gl.glLoadIdentity(); // matrisi baslangic durumuna getir
   }

   // cizim
   float aci1=0f, aci2=0f, aci3=0f;	
   public void display(GLAutoDrawable drawable) {
      GL2 gl = drawable.getGL().getGL2();  
      gl.glClear(GL_COLOR_BUFFER_BIT | GL_DEPTH_BUFFER_BIT); //yeniden cizim icin tampon bellek temizligi
      gl.glLoadIdentity(); // matrisleri sifirla

      //gl.glRotatef(aci, 0f, 1f, 0f);	
      gl.glTranslatef(0f, 0.0f, -10.0f);
      gl.glRotatef(aci1, 0f, 1f, 0f);	
      gl.glColor3f(0.0f, 0.0f, 1.0f); 
      cizdir(gl,new int[]{0,1,2,3}); // on	
      cizdir(gl,new int[]{0,1,5,4}); // sag yan
      cizdir(gl,new int[]{4,5,6,7}); // arka
      cizdir(gl,new int[]{4,0,3,7}); // ust
      cizdir(gl,new int[]{3,7,6,2}); // sol
      cizdir(gl,new int[]{1,5,6,2}); // alt
      aci1+=0.5f;

      gl.glRotatef(aci2, 0f, 1f, 0f); // kirmizinin mavi etrafindaki konumu
      gl.glTranslatef(3f, 0.0f, 0f);
      gl.glRotatef(aci3, 0f, 1f, 0f); // kirmizinin kendi ekseni etrafindaki konumu	
      gl.glColor3f(1.0f, 0.0f, 0.0f); 
      cizdir(gl,new int[]{0,1,2,3}); // on	
      cizdir(gl,new int[]{0,1,5,4}); // sag yan
      cizdir(gl,new int[]{4,5,6,7}); // arka
      cizdir(gl,new int[]{4,0,3,7}); // ust
      cizdir(gl,new int[]{3,7,6,2}); // sol
      cizdir(gl,new int[]{1,5,6,2}); // alt
      aci2-=0.8f;
      aci3+=2f;	


   }
}

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

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import javax.media.opengl.*;

import javax.media.opengl.awt.GLCanvas;

import javax.media.opengl.glu.GLU;

import com.jogamp.opengl.util.FPSAnimator;

import static javax.media.opengl.GL.*; // GL sabitlerini import et

import static javax.media.opengl.GL2.*; //

//sudo apt-get install libjogl2-java

//.bashrc classpath tanimlamasi

//export CLASSPATH=/usr/share/java/jogl2.jar:/usr/share/java/gluegen2-rt.jar:$CLASSPATH

class vertex{

float x,y,z;

vertex(float x,float y, float z)

{

this.x=x;

this.y=y;

this.z=z;

}

void olustur(GL2 gl)

{

gl.glVertex3f(x, y, z);

}

public class taslak extends GLCanvas implements GLEventListener {

private static String BASLIK = "başlık";

private static int CIZIMALANI_GENISLIK = 320;

private static int CIZIMALANI_YUKSEKLIK = 240;

private static int FPS = 60;

private GLU glu;

public taslak() { //yapilandirici

this.addGLEventListener(this);

}

public static void main(String[] args) {

SwingUtilities.invokeLater(new Runnable() {

public void run() {

GLCanvas canvas = new taslak(); // upcasting, sınıftan nesne

canvas.setPreferredSize(new Dimension(CIZIMALANI_GENISLIK, CIZIMALANI_YUKSEKLIK)); // cizim alani boyut tanimlamasi

final FPSAnimator animator = new FPSAnimator(canvas, FPS, true); // cizim alani

JFrame frame = new JFrame(BASLIK); // pencere nesnesi

frame.getContentPane().add(canvas); // cizim alaninin pencereye eklenmesi

frame.addWindowListener(new WindowAdapter() {

public void windowClosing(WindowEvent e) { // program sonlandildiginda

new Thread() {

public void run() {

if (animator.isStarted()) animator.stop(); // calisiyorsa durdur

System.exit(0);

}

}.start();

}

});

frame.pack(); // pencere boyutunu icerige gore ayarla

frame.setVisible(true); // pencereyi gorunur yap

animator.start(); // cizimi baslat

}

});

}

public void dispose(GLAutoDrawable drawable) { } // kaynaklari serbest birakma

// baslangic durumlari

vertex[] noktalar;

public void init(GLAutoDrawable drawable) {

GL2 gl = drawable.getGL().getGL2();

glu = new GLU();

gl.glClearColor(0.0f, 0.0f, 0.0f, 0.0f); // arka plan rengi

gl.glEnable(GL_DEPTH_TEST);

noktalar= new vertex[8];

noktalar[0]=new vertex(1f,1f,1f); // A

noktalar[1]=new vertex(1f,-1f,1f); // B

noktalar[2]=new vertex(-1f,-1f,1f); // C

noktalar[3]=new vertex(-1f,1f,1f); // D

noktalar[4]=new vertex(1f,1f,-1f); // A'

noktalar[5]=new vertex(1f,-1f,-1f); // B'

noktalar[6]=new vertex(-1f,-1f,-1f); // C'

noktalar[7]=new vertex(-1f,1f,-1f); // D'

}

public void cizdir(GL2 gl, int[] index)

{

gl.glBegin(GL_QUADS);

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

noktalar[index[i]].olustur(gl);

gl.glEnd();

}

// cizim alani degisince cizimi olcekle

public void reshape(GLAutoDrawable drawable, int x, int y, int width, int height) {

GL2 gl = drawable.getGL().getGL2();

float aspect=(float)1.2; // olcek

gl.glViewport(0, 0, 320, 240); // gorunecek sahnenin pencere uzerindeki koordinatlari ve boyutu (gorus alani)

gl.glMatrixMode(GL_PROJECTION); //izdusum matrisini sec

gl.glLoadIdentity(); // matrisi baslangic durumuna getir

glu.gluPerspective(45.0, aspect, 0.1, 100.0); // persipektif goruntu kameranin bulundugu noktan cikan isinlara ait aci, yeni cercevenin en/boy orani, yeni cercevenin bakis noktasina olan yakinlik ve uzakligi

gl.glMatrixMode(GL_MODELVIEW); // model matrisini sec

gl.glLoadIdentity(); // matrisi baslangic durumuna getir

}

// cizim

float aci1=0f, aci2=0f, aci3=0f;

public void display(GLAutoDrawable drawable) {

GL2 gl = drawable.getGL().getGL2();

gl.glClear(GL_COLOR_BUFFER_BIT | GL_DEPTH_BUFFER_BIT); //yeniden cizim icin tampon bellek temizligi

gl.glLoadIdentity(); // matrisleri sifirla

//gl.glRotatef(aci, 0f, 1f, 0f);

gl.glTranslatef(0f, 0.0f, -10.0f);

gl.glRotatef(aci1, 0f, 1f, 0f);

gl.glColor3f(0.0f, 0.0f, 1.0f);

cizdir(gl,new int[]{0,1,2,3}); // on

cizdir(gl,new int[]{0,1,5,4}); // sag yan

cizdir(gl,new int[]{4,5,6,7}); // arka

cizdir(gl,new int[]{4,0,3,7}); // ust

cizdir(gl,new int[]{3,7,6,2}); // sol

cizdir(gl,new int[]{1,5,6,2}); // alt

aci1+=0.5f;

gl.glRotatef(aci2, 0f, 1f, 0f); // kirmizinin mavi etrafindaki konumu

gl.glTranslatef(3f, 0.0f, 0f);

gl.glRotatef(aci3, 0f, 1f, 0f); // kirmizinin kendi ekseni etrafindaki konumu

gl.glColor3f(1.0f, 0.0f, 0.0f);

cizdir(gl,new int[]{0,1,2,3}); // on

cizdir(gl,new int[]{0,1,5,4}); // sag yan

cizdir(gl,new int[]{4,5,6,7}); // arka

cizdir(gl,new int[]{4,0,3,7}); // ust

cizdir(gl,new int[]{3,7,6,2}); // sol

cizdir(gl,new int[]{1,5,6,2}); // alt

aci2-=0.8f;

aci3+=2f;

}

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.media.opengl.*;
import javax.media.opengl.awt.GLCanvas;
import javax.media.opengl.glu.*;
import com.jogamp.opengl.util.FPSAnimator;
import static javax.media.opengl.GL.*;  // GL sabitlerini import et
import static javax.media.opengl.GL2.*; //

//sudo apt-get install libjogl2-java
//.bashrc classpath tanimlamasi
//export CLASSPATH=/usr/share/java/jogl2.jar:/usr/share/java/gluegen2-rt.jar:$CLASSPATH


public class taslak extends GLCanvas implements GLEventListener {

   private static String BASLIK = "başlık";
   private static int CIZIMALANI_GENISLIK = 320; 
   private static int CIZIMALANI_YUKSEKLIK = 240;
   private static int FPS = 60; 
   
   private GLU glu;

   public taslak() { //yapilandirici
      this.addGLEventListener(this);
   }	

   public static void main(String[] args) {
      SwingUtilities.invokeLater(new Runnable() {
         public void run() {
            GLCanvas canvas = new taslak(); // upcasting, sınıftan nesne
            canvas.setPreferredSize(new Dimension(CIZIMALANI_GENISLIK, CIZIMALANI_YUKSEKLIK)); // cizim alani boyut tanimlamasi
            final FPSAnimator animator = new FPSAnimator(canvas, FPS, true); // cizim alani 
            JFrame frame = new JFrame(BASLIK); // pencere nesnesi
            frame.getContentPane().add(canvas); // cizim alaninin pencereye eklenmesi
            frame.addWindowListener(new WindowAdapter() {
               public void windowClosing(WindowEvent e) { // program sonlandildiginda
                  new Thread() { 
                     public void run() {
                        if (animator.isStarted()) animator.stop(); // calisiyorsa durdur
                        System.exit(0);
                     }
                  }.start();
               }
            });
            frame.pack(); // pencere boyutunu icerige gore ayarla
            frame.setVisible(true); // pencereyi gorunur yap
            animator.start(); // cizimi baslat
         }
      });
   }
   
   public void dispose(GLAutoDrawable drawable) { }	// kaynaklari serbest birakma 

   // baslangic durumlari	
   public void init(GLAutoDrawable drawable) {
      GL2 gl = drawable.getGL().getGL2();      
      glu = new GLU();                         
      gl.glClearColor(0.0f, 0.0f, 0.0f, 0.0f); // arka plan rengi
      gl.glEnable(GL_DEPTH_TEST);	
   }

   // cizim alani degisince cizimi olcekle
   public void reshape(GLAutoDrawable drawable, int x, int y, int width, int height) {
      GL2 gl = drawable.getGL().getGL2();  

      float aspect=(float)1.2; // olcek
      gl.glViewport(0, 0, 320, 240); // gorunecek sahnenin pencere uzerindeki koordinatlari ve boyutu (gorus alani) 
      gl.glMatrixMode(GL_PROJECTION);  //izdusum matrisini sec
      gl.glLoadIdentity();  // matrisi baslangic durumuna getir           
      glu.gluPerspective(45.0, aspect, 0.1, 100.0); // persipektif goruntu kameranin bulundugu noktan cikan isinlara ait aci, yeni cercevenin en/boy orani, yeni cercevenin bakis noktasina olan yakinlik ve uzakligi  
      gl.glMatrixMode(GL_MODELVIEW); // model matrisini sec
      gl.glLoadIdentity(); // matrisi baslangic durumuna getir
   }

   // cizim
   float aci1=0f,aci2=0f;		
   public void display(GLAutoDrawable drawable) {
      GL2 gl = drawable.getGL().getGL2();  
      gl.glClear(GL_COLOR_BUFFER_BIT | GL_DEPTH_BUFFER_BIT); //yeniden cizim icin tampon bellek temizligi
      gl.glLoadIdentity(); // matrisleri sifirla
 	

      gl.glTranslatef(0f, 0.0f, -30.0f);
      gl.glColor3f(1.0f, 1.0f, 0.0f);	// sarı
      GLUquadric gunes = glu.gluNewQuadric();
      glu.gluSphere(gunes,3f,15,15);
      glu.gluDeleteQuadric(gunes);

      gl.glRotatef(aci2,0.3f,1f,0f); // dunyanin gunes etrafindaki donusu icin
      gl.glTranslatef(10f, 0.0f, 0.0f);
      // gl.glRotatef(aci3,0f,1f,0f); // dunyanin kendi eksen donusu icin
      gl.glColor3f(0.0f, 0.0f, 1.0f);	// sarı
      GLUquadric dunya = glu.gluNewQuadric();
      glu.gluSphere(dunya,1f,15,15);
      glu.gluDeleteQuadric(dunya);	

      gl.glRotatef(aci1,0f,1f,0f);	
      gl.glTranslatef(2f, 0.0f, 0.0f);
      gl.glColor3f(1.0f, 1.0f, 1.0f);
      GLUquadric ay = glu.gluNewQuadric();
      glu.gluSphere(ay,0.1f,15,15);
      glu.gluDeleteQuadric(ay);


      aci1+=0.6f;
      aci2+=0.2f;	
   }
}

100

101

102

103

104

105

106

107

108

109

110

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import javax.media.opengl.*;

import javax.media.opengl.awt.GLCanvas;

import javax.media.opengl.glu.*;

import com.jogamp.opengl.util.FPSAnimator;

import static javax.media.opengl.GL.*; // GL sabitlerini import et

import static javax.media.opengl.GL2.*; //

//sudo apt-get install libjogl2-java

//.bashrc classpath tanimlamasi

//export CLASSPATH=/usr/share/java/jogl2.jar:/usr/share/java/gluegen2-rt.jar:$CLASSPATH

public class taslak extends GLCanvas implements GLEventListener {

private static String BASLIK = "başlık";

private static int CIZIMALANI_GENISLIK = 320;

private static int CIZIMALANI_YUKSEKLIK = 240;

private static int FPS = 60;

private GLU glu;

public taslak() { //yapilandirici

this.addGLEventListener(this);

}

public static void main(String[] args) {

SwingUtilities.invokeLater(new Runnable() {

public void run() {

GLCanvas canvas = new taslak(); // upcasting, sınıftan nesne

canvas.setPreferredSize(new Dimension(CIZIMALANI_GENISLIK, CIZIMALANI_YUKSEKLIK)); // cizim alani boyut tanimlamasi

final FPSAnimator animator = new FPSAnimator(canvas, FPS, true); // cizim alani

JFrame frame = new JFrame(BASLIK); // pencere nesnesi

frame.getContentPane().add(canvas); // cizim alaninin pencereye eklenmesi

frame.addWindowListener(new WindowAdapter() {

public void windowClosing(WindowEvent e) { // program sonlandildiginda

new Thread() {

public void run() {

if (animator.isStarted()) animator.stop(); // calisiyorsa durdur

System.exit(0);

}

}.start();

}

});

frame.pack(); // pencere boyutunu icerige gore ayarla

frame.setVisible(true); // pencereyi gorunur yap

animator.start(); // cizimi baslat

}

});

}

public void dispose(GLAutoDrawable drawable) { } // kaynaklari serbest birakma

// baslangic durumlari

public void init(GLAutoDrawable drawable) {

GL2 gl = drawable.getGL().getGL2();

glu = new GLU();

gl.glClearColor(0.0f, 0.0f, 0.0f, 0.0f); // arka plan rengi

gl.glEnable(GL_DEPTH_TEST);

}

// cizim alani degisince cizimi olcekle

public void reshape(GLAutoDrawable drawable, int x, int y, int width, int height) {

GL2 gl = drawable.getGL().getGL2();

float aspect=(float)1.2; // olcek

gl.glViewport(0, 0, 320, 240); // gorunecek sahnenin pencere uzerindeki koordinatlari ve boyutu (gorus alani)

gl.glMatrixMode(GL_PROJECTION); //izdusum matrisini sec

gl.glLoadIdentity(); // matrisi baslangic durumuna getir

gl.glMatrixMode(GL_MODELVIEW); // model matrisini sec

gl.glLoadIdentity(); // matrisi baslangic durumuna getir

}

// cizim

float aci1=0f,aci2=0f;

public void display(GLAutoDrawable drawable) {

GL2 gl = drawable.getGL().getGL2();

gl.glClear(GL_COLOR_BUFFER_BIT | GL_DEPTH_BUFFER_BIT); //yeniden cizim icin tampon bellek temizligi

gl.glLoadIdentity(); // matrisleri sifirla

gl.glTranslatef(0f, 0.0f, -30.0f);

gl.glColor3f(1.0f, 1.0f, 0.0f); // sarı

GLUquadric gunes = glu.gluNewQuadric();

glu.gluSphere(gunes,3f,15,15);

glu.gluDeleteQuadric(gunes);

gl.glRotatef(aci2,0.3f,1f,0f); // dunyanin gunes etrafindaki donusu icin

gl.glTranslatef(10f, 0.0f, 0.0f);

// gl.glRotatef(aci3,0f,1f,0f); // dunyanin kendi eksen donusu icin

gl.glColor3f(0.0f, 0.0f, 1.0f); // sarı

GLUquadric dunya = glu.gluNewQuadric();

glu.gluSphere(dunya,1f,15,15);

glu.gluDeleteQuadric(dunya);

gl.glRotatef(aci1,0f,1f,0f);

gl.glTranslatef(2f, 0.0f, 0.0f);

gl.glColor3f(1.0f, 1.0f, 1.0f);

GLUquadric ay = glu.gluNewQuadric();

glu.gluSphere(ay,0.1f,15,15);

glu.gluDeleteQuadric(ay);

aci1+=0.6f;

aci2+=0.2f;

}

Bilgisayar Grafikleri 2016 Hafta-10 Uygulamaları

Etiketler: glRotatef, glTranslatef, gluDeleteQuadric, GLUquadric, opengl

NYP-2 2016 10. Hafta Uygulamaları-2

Posted on 9 Mayıs 2016 by

caglar C#, Ders Notları, Nesneye Yönelik Programlama-II, Yazılım kategorisine gönderildi — Henüz Yorum Yapılmadı ↓

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace datagridw
{
    public partial class Form1 : Form
    {
        MySqlDataAdapter da;
        DataTable dt;
        public Form1()
        {
            InitializeComponent();

            MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();
            bag.Server = "localhost";
            bag.UserID = "root";
            bag.Password = "123456";
            bag.Database = "hafta8_16_1_1";

            MySqlConnection conn = new MySqlConnection(bag.ToString());

            MySqlCommand cmd_sel = new MySqlCommand("select id,isimler,telefon from liste;", conn);
            MySqlCommand cmd_ins = 
                new MySqlCommand("insert into liste(isimler,telefon) values(@isimler,@telefon);", conn);
            cmd_ins.Parameters.Add("@isimler", MySqlDbType.VarChar, 45, "isimler");
            cmd_ins.Parameters.Add("@telefon", MySqlDbType.VarChar, 45, "telefon");
            
            MySqlCommand cmd_del = 
                new MySqlCommand("delete from liste where id=@id;", conn);
            cmd_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");
           
            MySqlCommand cmd_upd = 
                new MySqlCommand("update liste set isimler=@isimler, telefon=@telefon where id=@id", conn);
            cmd_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");
            cmd_upd.Parameters.Add("@isimler", MySqlDbType.VarChar, 45, "isimler");
            cmd_upd.Parameters.Add("@telefon", MySqlDbType.VarChar, 45, "telefon");

            da = new MySqlDataAdapter();
            da.SelectCommand = cmd_sel;
            da.UpdateCommand = cmd_upd;
            da.DeleteCommand = cmd_del;
            da.InsertCommand = cmd_ins;

            verigetir();
            

        }

        private void verigetir()
        {
            try
            {
                dt = new DataTable();
                da.Fill(dt);
                dataGridView1.DataSource = dt;
                // dataGridView1.Columns[0].ReadOnly = true; // id kolonu sadece okunabilir olsun
                dataGridView1.Columns[0].Visible = false; // id kolonu gizle/goster
                dataGridView1.Columns[1].HeaderText = "Ad Soyad";
                dataGridView1.Columns[2].HeaderText = "Telefon No";

                //dataGridView1.AllowUserToAddRows = false; // yeni satir eklemeyi iptal et
                dataGridView1.AllowUserToDeleteRows = false; // satir silme aktif/pasif
            }
            catch { 
            }

        
        }

        private void byenile_Click(object sender, EventArgs e)
        {
            verigetir();
        }

        private void bkaydet_Click(object sender, EventArgs e)
        {
            try
            {
                da.Update(dt);
                verigetir();
            }
            catch { }


        }
    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace datagridw

{

public partial class Form1 : Form

{

MySqlDataAdapter da;

DataTable dt;

public Form1()

{

InitializeComponent();

MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();

bag.Server = "localhost";

bag.UserID = "root";

bag.Password = "123456";

bag.Database = "hafta8_16_1_1";

MySqlConnection conn = new MySqlConnection(bag.ToString());

MySqlCommand cmd_sel = new MySqlCommand("select id,isimler,telefon from liste;", conn);

MySqlCommand cmd_ins =

new MySqlCommand("insert into liste(isimler,telefon) values(@isimler,@telefon);", conn);

cmd_ins.Parameters.Add("@isimler", MySqlDbType.VarChar, 45, "isimler");

cmd_ins.Parameters.Add("@telefon", MySqlDbType.VarChar, 45, "telefon");

MySqlCommand cmd_del =

new MySqlCommand("delete from liste where id=@id;", conn);

cmd_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

MySqlCommand cmd_upd =

new MySqlCommand("update liste set isimler=@isimler, telefon=@telefon where id=@id", conn);

cmd_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

cmd_upd.Parameters.Add("@isimler", MySqlDbType.VarChar, 45, "isimler");

cmd_upd.Parameters.Add("@telefon", MySqlDbType.VarChar, 45, "telefon");

da = new MySqlDataAdapter();

da.SelectCommand = cmd_sel;

da.UpdateCommand = cmd_upd;

da.DeleteCommand = cmd_del;

da.InsertCommand = cmd_ins;

verigetir();

}

private void verigetir()

{

try

{

dt = new DataTable();

da.Fill(dt);

dataGridView1.DataSource = dt;

// dataGridView1.Columns[0].ReadOnly = true; // id kolonu sadece okunabilir olsun

dataGridView1.Columns[0].Visible = false; // id kolonu gizle/goster

dataGridView1.Columns[1].HeaderText = "Ad Soyad";

dataGridView1.Columns[2].HeaderText = "Telefon No";

//dataGridView1.AllowUserToAddRows = false; // yeni satir eklemeyi iptal et

dataGridView1.AllowUserToDeleteRows = false; // satir silme aktif/pasif

}

catch {

}

private void byenile_Click(object sender, EventArgs e)

{

verigetir();

}

private void bkaydet_Click(object sender, EventArgs e)

{

try

{

da.Update(dt);

verigetir();

}

catch { }

}

NYP-2 2016 Hafta-8 – 2