Mayıs 2016 – oflazoglu.org

Aylar: Mayıs 2016

NYP-2 2016 11. Hafta Uygulamaları

caglarPosted on 13 Mayıs 2016 C#, Ders Notları, Nesneye Yönelik Programlama-II, Yazılım kategorisine gönderildi 2 Comments

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

caglarPosted on 12 Mayıs 2016 Ders Notları, JAVA, JAVA-II, Yazılım kategorisine gönderildi No Comments

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

caglarPosted on 12 Mayıs 2016 Bilgisayar Grafikleri, Ders Notları, OpenGL, Yazılım kategorisine gönderildi No Comments

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

caglarPosted on 9 Mayıs 2016 C#, Ders Notları, Nesneye Yönelik Programlama-II, Yazılım kategorisine gönderildi No Comments

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

NYP-2 2016 10. Hafta Uygulamaları-1

caglarPosted on 9 Mayıs 2016 C#, Ders Notları, Nesneye Yönelik Programlama-II, Yazılım kategorisine gönderildi No Comments

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 notgirisi
{
    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 = "hafta10_16_2";

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

            MySqlCommand cmd_sel = 
                new MySqlCommand("select id,ogrno,adsoyad,vize,final from ogrenci;", conn);

            MySqlCommand cmd_ins =
                new MySqlCommand("insert into ogrenci(ogrno,adsoyad,vize,final) values(@ogrno,@adsoyad,@vize,@final)", conn);
            cmd_ins.Parameters.Add("@ogrno", MySqlDbType.VarChar, 15, "ogrno");
            cmd_ins.Parameters.Add("@adsoyad", MySqlDbType.VarChar, 45, "adsoyad");
            cmd_ins.Parameters.Add("@vize", MySqlDbType.Int32, 11, "vize");
            cmd_ins.Parameters.Add("@final", MySqlDbType.Int32, 11, "final");

            MySqlCommand cmd_del = 
                new MySqlCommand("delete from ogrenci where id=@id;",conn);
            cmd_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

            MySqlCommand cmd_upd = 
                new MySqlCommand("update ogrenci set ogrno=@ogrno, adsoyad=@adsoyad, vize=@vize, final=@final where id=@id;", conn);
            cmd_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");
            cmd_upd.Parameters.Add("@ogrno", MySqlDbType.VarChar, 15, "ogrno");
            cmd_upd.Parameters.Add("@adsoyad", MySqlDbType.VarChar, 45, "adsoyad");
            cmd_upd.Parameters.Add("@vize", MySqlDbType.Int32, 11, "vize");
            cmd_upd.Parameters.Add("@final", MySqlDbType.Int32, 11, "final");

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

            listedoldur();

        }

        private void listedoldur()
        {
            try
            {
                dt = new DataTable();
                da.Fill(dt);

                logrno.Items.Clear();
                ladsoyad.Items.Clear();
                lort.Items.Clear();
                lharf.Items.Clear();


                int satir = dt.Rows.Count;

                for (int ogr = 0; ogr < satir; ogr++)
                {
                    int ort = (int)Math.Round((int)dt.Rows[ogr]["vize"] * 0.4 + (int)dt.Rows[ogr]["final"] * 0.6);
                    logrno.Items.Add(dt.Rows[ogr]["ogrno"]);
                    ladsoyad.Items.Add(dt.Rows[ogr]["adsoyad"]);
                    lort.Items.Add(ort);
                    lharf.Items.Add(harfhesap(ort));

                }

            }
            catch
            { }
        

        
        }

        private string harfhesap(int ort)
        {
            String[] harf = { "AA", "BA", "BB", "CB", "CC", "DC", "DD", "FD" };
            int[] sinir = { 90, 80, 70, 60, 50, 40, 35, 30 };

            for (int i = 0; i < sinir.Length; i++)
            {
                if (ort >= sinir[i])
                    return harf[i];
            }

            return "FF";
        }

        private void bverigirisi_Click(object sender, EventArgs e)
        {
            fverigirisi frm = new fverigirisi(da);
            frm.ShowDialog();
            listedoldur();
        }
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

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 notgirisi

{

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 = "hafta10_16_2";

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

MySqlCommand cmd_sel =

new MySqlCommand("select id,ogrno,adsoyad,vize,final from ogrenci;", conn);

MySqlCommand cmd_ins =

new MySqlCommand("insert into ogrenci(ogrno,adsoyad,vize,final) values(@ogrno,@adsoyad,@vize,@final)", conn);

cmd_ins.Parameters.Add("@ogrno", MySqlDbType.VarChar, 15, "ogrno");

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

cmd_ins.Parameters.Add("@vize", MySqlDbType.Int32, 11, "vize");

cmd_ins.Parameters.Add("@final", MySqlDbType.Int32, 11, "final");

MySqlCommand cmd_del =

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

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

MySqlCommand cmd_upd =

new MySqlCommand("update ogrenci set ogrno=@ogrno, adsoyad=@adsoyad, vize=@vize, final=@final where id=@id;", conn);

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

cmd_upd.Parameters.Add("@ogrno", MySqlDbType.VarChar, 15, "ogrno");

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

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

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

da = new MySqlDataAdapter();

da.SelectCommand = cmd_sel;

da.InsertCommand = cmd_ins;

da.DeleteCommand = cmd_del;

da.UpdateCommand = cmd_upd;

listedoldur();

}

private void listedoldur()

{

try

{

dt = new DataTable();

da.Fill(dt);

logrno.Items.Clear();

ladsoyad.Items.Clear();

lort.Items.Clear();

lharf.Items.Clear();

int satir = dt.Rows.Count;

for (int ogr = 0; ogr < satir; ogr++)

{

int ort = (int)Math.Round((int)dt.Rows[ogr]["vize"] * 0.4 + (int)dt.Rows[ogr]["final"] * 0.6);

logrno.Items.Add(dt.Rows[ogr]["ogrno"]);

ladsoyad.Items.Add(dt.Rows[ogr]["adsoyad"]);

lort.Items.Add(ort);

lharf.Items.Add(harfhesap(ort));

}

catch

{ }

}

private string harfhesap(int ort)

{

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

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

for (int i = 0; i < sinir.Length; i++)

{

if (ort >= sinir[i])

return harf[i];

}

return "FF";

}

private void bverigirisi_Click(object sender, EventArgs e)

{

fverigirisi frm = new fverigirisi(da);

frm.ShowDialog();

listedoldur();

}

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 notgirisi
{
    public partial class fverigirisi : Form
    {
        MySqlDataAdapter da;
        DataTable dt;
        public fverigirisi(MySqlDataAdapter _da)
        {
            InitializeComponent();
            da = _da;
            verigetir();
        }

        private void verigetir()
        {
            try
            {
                dt = new DataTable();
                da.Fill(dt);
                dataGridView1.DataSource = dt;
                dataGridView1.Columns["id"].Visible = false;
                //dataGridView1.Columns[0].Visible = false;
                dataGridView1.Columns[1].HeaderText = "Öğrenci No";
                dataGridView1.Columns[2].HeaderText = "Ad Soyad";
                dataGridView1.Columns[3].HeaderText = "Vize";
                dataGridView1.Columns[4].HeaderText = "Final";

            }
            catch { }

        
        }

        private void bkapat_Click(object sender, EventArgs e)
        {
            try
            {
                da.Update(dt); // hata olusmasi durumunda kapatma
                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 notgirisi

{

public partial class fverigirisi : Form

{

MySqlDataAdapter da;

DataTable dt;

public fverigirisi(MySqlDataAdapter _da)

{

InitializeComponent();

da = _da;

verigetir();

}

private void verigetir()

{

try

{

dt = new DataTable();

da.Fill(dt);

dataGridView1.DataSource = dt;

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

//dataGridView1.Columns[0].Visible = false;

dataGridView1.Columns[1].HeaderText = "Öğrenci No";

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

dataGridView1.Columns[3].HeaderText = "Vize";

dataGridView1.Columns[4].HeaderText = "Final";

}

catch { }

}

private void bkapat_Click(object sender, EventArgs e)

{

try

{

da.Update(dt); // hata olusmasi durumunda kapatma

this.Close();

}

catch { }

}

NYP-2 2016 Hafta-8 – 1

NYP-2 2016 8. Hafta Uygulamaları

caglarPosted on 9 Mayıs 2016 C#, Ders Notları, Nesneye Yönelik Programlama-II, Yazılım kategorisine gönderildi No Comments

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 puanlama
{
    public partial class Form1 : Form
    {
        MySqlDataAdapter da_katsayilar, da_kisiler, da_puanlar;
        DataTable dt_katsayilar, dt_kisiler, dt_puanlar;
        public Form1()
        {
            InitializeComponent();
            MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();
            bag.Server = "localhost";
            bag.UserID = "root";
            bag.Password = "123456";
            bag.Database = "hafta8_16_2";

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

            MySqlCommand cmd_katsayilar_sel = 
                new MySqlCommand("select id,adi,puan from katsayilar;", conn);

            da_katsayilar = new MySqlDataAdapter();
            da_katsayilar.SelectCommand = cmd_katsayilar_sel;

            MySqlCommand cmd_kisiler_sel = 
                new MySqlCommand("select id,isimler from kisiler order by isimler;", conn);
            da_kisiler = new MySqlDataAdapter();
            da_kisiler.SelectCommand = cmd_kisiler_sel;

            MySqlCommand cmd_puanlar_sel = 
                new MySqlCommand("select id,kisiid,puanturu, miktar from puanlar;",conn);
            
            MySqlCommand cmd_puanlar_ins =
                new MySqlCommand("insert into puanlar(kisiid,puanturu,miktar) values(@kisiid,@puanturu,@miktar);", conn);
            cmd_puanlar_ins.Parameters.Add("@kisiid", MySqlDbType.Int32, 11, "kisiid");
            cmd_puanlar_ins.Parameters.Add("@puanturu", MySqlDbType.Int32, 11, "puanturu");
            cmd_puanlar_ins.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");

            MySqlCommand cmd_puanlar_del =
               new MySqlCommand("delete from puanlar where id=@id;", conn);
            cmd_puanlar_del.Parameters.Add("@id",MySqlDbType.Int32,11,"id");
          
            da_puanlar = new MySqlDataAdapter();
            da_puanlar.SelectCommand = cmd_puanlar_sel;
            da_puanlar.DeleteCommand = cmd_puanlar_del;
            da_puanlar.InsertCommand = cmd_puanlar_ins;
            listedoldur();
        }

        private void bpuanlama_Click(object sender, EventArgs e)
        {
            fpuanlama frm = new fpuanlama(da_katsayilar, da_kisiler, da_puanlar);
            frm.ShowDialog();
            listedoldur();
        }

        private void kisilerigetir()
        {
            try
            {
                dt_kisiler = new DataTable();
                da_kisiler.Fill(dt_kisiler);
            }
            catch
            { }
        }
        

        private void katsayilarigetir()
        {
            try
            {
                dt_katsayilar = new DataTable();
                da_katsayilar.Fill(dt_katsayilar);
            }
            catch
            { }
        }

        private void puanlarigetir()
        {
            try
            {
                dt_puanlar = new DataTable();
                da_puanlar.Fill(dt_puanlar);
            }
            catch
            { }
        }

        private void listedoldur()
        {
            kisilerigetir();
            katsayilarigetir();
            puanlarigetir();

            lisim.Items.Clear();
            lpuan.Items.Clear();
            lderece.Items.Clear();
            int say = dt_kisiler.Rows.Count;

            for (int i = 0; i < say; i++)
            {
                int kisi_id = (int)dt_kisiler.Rows[i]["id"];
                int puantoplami = puantoplamihesapla(kisi_id);
                if (puantoplami > 0)
                {
                    lisim.Items.Add(dt_kisiler.Rows[i]["isimler"]);
                    lpuan.Items.Add(puantoplami);
                    lderece.Items.Add(derecehesapla(puantoplami));
                }
            }        
        }

        private int puantoplamihesapla(int kisiid)
        {
            int toplam = 0;
            // puanlistesi
            DataRow[] dr = dt_puanlar.Select("kisiid=" + kisiid);

            for (int i = 0; i < dr.Length; i++)
            {
                int miktar = (int)dr[i]["miktar"];
                int puanturu_id = (int)dr[i]["puanturu"];
                // puan katsayilari
                int katsayi = katsayibul(puanturu_id);
                toplam += miktar * katsayi;
            }
            return toplam;
        }

        private int katsayibul(int katsayi_id)
        {
            DataRow[] dr = dt_katsayilar.Select("id=" + katsayi_id);
            if (dr.Length > 0)
                return (int)dr[0]["puan"];
            return 0;
        }

        private string derecehesapla(int toplampuan)
        { 
            // hesaplama alg. yazilacak
            // her 50 puan icin bir yildiz
            return "*";
        }
    }
}

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

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 puanlama

{

public partial class Form1 : Form

{

MySqlDataAdapter da_katsayilar, da_kisiler, da_puanlar;

DataTable dt_katsayilar, dt_kisiler, dt_puanlar;

public Form1()

{

InitializeComponent();

MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();

bag.Server = "localhost";

bag.UserID = "root";

bag.Password = "123456";

bag.Database = "hafta8_16_2";

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

MySqlCommand cmd_katsayilar_sel =

new MySqlCommand("select id,adi,puan from katsayilar;", conn);

da_katsayilar = new MySqlDataAdapter();

da_katsayilar.SelectCommand = cmd_katsayilar_sel;

MySqlCommand cmd_kisiler_sel =

new MySqlCommand("select id,isimler from kisiler order by isimler;", conn);

da_kisiler = new MySqlDataAdapter();

da_kisiler.SelectCommand = cmd_kisiler_sel;

MySqlCommand cmd_puanlar_sel =

new MySqlCommand("select id,kisiid,puanturu, miktar from puanlar;",conn);

MySqlCommand cmd_puanlar_ins =

new MySqlCommand("insert into puanlar(kisiid,puanturu,miktar) values(@kisiid,@puanturu,@miktar);", conn);

cmd_puanlar_ins.Parameters.Add("@kisiid", MySqlDbType.Int32, 11, "kisiid");

cmd_puanlar_ins.Parameters.Add("@puanturu", MySqlDbType.Int32, 11, "puanturu");

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

MySqlCommand cmd_puanlar_del =

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

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

da_puanlar = new MySqlDataAdapter();

da_puanlar.SelectCommand = cmd_puanlar_sel;

da_puanlar.DeleteCommand = cmd_puanlar_del;

da_puanlar.InsertCommand = cmd_puanlar_ins;

listedoldur();

}

private void bpuanlama_Click(object sender, EventArgs e)

{

fpuanlama frm = new fpuanlama(da_katsayilar, da_kisiler, da_puanlar);

frm.ShowDialog();

listedoldur();

}

private void kisilerigetir()

{

try

{

dt_kisiler = new DataTable();

da_kisiler.Fill(dt_kisiler);

}

catch

{ }

}

private void katsayilarigetir()

{

try

{

dt_katsayilar = new DataTable();

da_katsayilar.Fill(dt_katsayilar);

}

catch

{ }

}

private void puanlarigetir()

{

try

{

dt_puanlar = new DataTable();

da_puanlar.Fill(dt_puanlar);

}

catch

{ }

}

private void listedoldur()

{

kisilerigetir();

katsayilarigetir();

puanlarigetir();

lisim.Items.Clear();

lpuan.Items.Clear();

lderece.Items.Clear();

int say = dt_kisiler.Rows.Count;

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

{

int kisi_id = (int)dt_kisiler.Rows[i]["id"];

int puantoplami = puantoplamihesapla(kisi_id);

if (puantoplami > 0)

{

lisim.Items.Add(dt_kisiler.Rows[i]["isimler"]);

lpuan.Items.Add(puantoplami);

lderece.Items.Add(derecehesapla(puantoplami));

}

private int puantoplamihesapla(int kisiid)

{

int toplam = 0;

// puanlistesi

DataRow[] dr = dt_puanlar.Select("kisiid=" + kisiid);

for (int i = 0; i < dr.Length; i++)

{

int miktar = (int)dr[i]["miktar"];

int puanturu_id = (int)dr[i]["puanturu"];

// puan katsayilari

int katsayi = katsayibul(puanturu_id);

toplam += miktar * katsayi;

}

return toplam;

}

private int katsayibul(int katsayi_id)

{

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

if (dr.Length > 0)

return (int)dr[0]["puan"];

return 0;

}

private string derecehesapla(int toplampuan)

{

// hesaplama alg. yazilacak

// her 50 puan icin bir yildiz

return "*";

}

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 puanlama
{
    public partial class fpuanlama : Form
    {
        MySqlDataAdapter da_katsayilar, da_kisiler, da_puanlar;
        DataTable dt_katsayilar, dt_kisiler, dt_puanlar;
        public fpuanlama(MySqlDataAdapter _da1,MySqlDataAdapter _da2,MySqlDataAdapter _da3)
        {
            InitializeComponent();

            da_katsayilar = _da1;
            da_kisiler = _da2;
            da_puanlar = _da3;
            listedoldur();

        }

        private void isimdoldur()
        {
            cisim.Items.Clear();
            
            try
            {
                dt_kisiler = new DataTable();
                da_kisiler.Fill(dt_kisiler);

                int say = dt_kisiler.Rows.Count;
                for (int i = 0; i < say; i++)
                {
                    cisim.Items.Add(dt_kisiler.Rows[i]["isimler"]);
                }
            }
            catch
            { 
            }
            cisim.Text = "Seçiniz";
        }

        private void puanturudoldur()
        {
            cpuanturu.Items.Clear();

            try
            {
                dt_katsayilar  = new DataTable();
                da_katsayilar.Fill(dt_katsayilar);

                int say = dt_katsayilar.Rows.Count;
                for (int i = 0; i < say; i++)
                {
                    cpuanturu.Items.Add(dt_katsayilar.Rows[i]["adi"]);
                }
            }
            catch
            {
            }
            cpuanturu.Text = "Seçiniz";
        }


        private void listedoldur()
        {
            isimdoldur();
            puanturudoldur();

            lisim.Items.Clear();
            lpuanturu.Items.Clear();
            ladet.Items.Clear();

            try
            {
                dt_puanlar = new DataTable();
                da_puanlar.Fill(dt_puanlar);

                int say = dt_puanlar.Rows.Count;
                for (int i = 0; i < say; i++)
                {
                    DataRow dr_kisi = 
                        tablodangetir(dt_kisiler, (int)dt_puanlar.Rows[i]["kisiid"]);
                    DataRow dr_tur =
                        tablodangetir(dt_katsayilar, (int)dt_puanlar.Rows[i]["puanturu"]);

                    if (dr_kisi != null && dr_tur != null)
                    {
                        lisim.Items.Add(dr_kisi["isimler"]);
                        lpuanturu.Items.Add(dr_tur["adi"]);
                        ladet.Items.Add(dt_puanlar.Rows[i]["miktar"]);
                    }
                   /* else
                    {
                     // isim ve tur tanimi veritabaninda yer almiyor ise
                        lisim.Items.Add("-");
                        lpuanturu.Items.Add("-");
                        ladet.Items.Add(dt_puanlar.Rows[i]["miktar"]);
                    }*/
                }
            }
            catch
            { 
            
            }
        }

        private DataRow tablodangetir(DataTable dt,int id)
        {
            DataRow[] dr = dt.Select("id=" + id);
            if (dr.Length > 0)
                return dr[0];
            return null;
        }

        private void bekle_Click(object sender, EventArgs e)
        {
            int s_isim = cisim.SelectedIndex;
            int s_puanturu = cpuanturu.SelectedIndex;
            int miktar;
            bool k = Int32.TryParse(tadet.Text, out miktar);

            if ( k && s_isim > -1 && s_puanturu > -1)
            {
                try
                {
                    DataRow dr = dt_puanlar.NewRow();
                    dr["kisiid"] = (int)dt_kisiler.Rows[s_isim]["id"];
                    dr["puanturu"] = (int)dt_katsayilar.Rows[s_puanturu]["id"];
                    dr["miktar"] = miktar;
                    dt_puanlar.Rows.Add(dr);
                    da_puanlar.Update(dt_puanlar);
                }
                catch
                { 
                }

                tadet.Clear();
                listedoldur();
            }



        }

        private void bsil_Click(object sender, EventArgs e)
        {
            int secilen = lisim.SelectedIndex;

            if (secilen > -1)
            {
                try
                {
                    // dt_puanlar.Select(""); // tanimsiz bilgileri silmek icin tercih edilebilir
                    dt_puanlar.Rows[secilen].Delete();
                    da_puanlar.Update(dt_puanlar);
                }
                catch
                { }
                listedoldur();
            }


        }

        private void bkapat_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}

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

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 puanlama

{

public partial class fpuanlama : Form

{

MySqlDataAdapter da_katsayilar, da_kisiler, da_puanlar;

DataTable dt_katsayilar, dt_kisiler, dt_puanlar;

public fpuanlama(MySqlDataAdapter _da1,MySqlDataAdapter _da2,MySqlDataAdapter _da3)

{

InitializeComponent();

da_katsayilar = _da1;

da_kisiler = _da2;

da_puanlar = _da3;

listedoldur();

}

private void isimdoldur()

{

cisim.Items.Clear();

try

{

dt_kisiler = new DataTable();

da_kisiler.Fill(dt_kisiler);

int say = dt_kisiler.Rows.Count;

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

{

cisim.Items.Add(dt_kisiler.Rows[i]["isimler"]);

}

catch

{

}

cisim.Text = "Seçiniz";

}

private void puanturudoldur()

{

cpuanturu.Items.Clear();

try

{

dt_katsayilar = new DataTable();

da_katsayilar.Fill(dt_katsayilar);

int say = dt_katsayilar.Rows.Count;

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

{

cpuanturu.Items.Add(dt_katsayilar.Rows[i]["adi"]);

}

catch

{

}

cpuanturu.Text = "Seçiniz";

}

private void listedoldur()

{

isimdoldur();

puanturudoldur();

lisim.Items.Clear();

lpuanturu.Items.Clear();

ladet.Items.Clear();

try

{

dt_puanlar = new DataTable();

da_puanlar.Fill(dt_puanlar);

int say = dt_puanlar.Rows.Count;

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

{

DataRow dr_kisi =

tablodangetir(dt_kisiler, (int)dt_puanlar.Rows[i]["kisiid"]);

DataRow dr_tur =

tablodangetir(dt_katsayilar, (int)dt_puanlar.Rows[i]["puanturu"]);

if (dr_kisi != null && dr_tur != null)

{

lisim.Items.Add(dr_kisi["isimler"]);

lpuanturu.Items.Add(dr_tur["adi"]);

ladet.Items.Add(dt_puanlar.Rows[i]["miktar"]);

}

/* else

{

// isim ve tur tanimi veritabaninda yer almiyor ise

lisim.Items.Add("-");

lpuanturu.Items.Add("-");

ladet.Items.Add(dt_puanlar.Rows[i]["miktar"]);

}*/

}

catch

{

}

private DataRow tablodangetir(DataTable dt,int id)

{

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

if (dr.Length > 0)

return dr[0];

return null;

}

private void bekle_Click(object sender, EventArgs e)

{

int s_isim = cisim.SelectedIndex;

int s_puanturu = cpuanturu.SelectedIndex;

int miktar;

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

if ( k && s_isim > -1 && s_puanturu > -1)

{

try

{

DataRow dr = dt_puanlar.NewRow();

dr["kisiid"] = (int)dt_kisiler.Rows[s_isim]["id"];

dr["puanturu"] = (int)dt_katsayilar.Rows[s_puanturu]["id"];

dr["miktar"] = miktar;

dt_puanlar.Rows.Add(dr);

da_puanlar.Update(dt_puanlar);

}

catch

{

}

tadet.Clear();

listedoldur();

}

private void bsil_Click(object sender, EventArgs e)

{

int secilen = lisim.SelectedIndex;

if (secilen > -1)

{

try

{

// dt_puanlar.Select(""); // tanimsiz bilgileri silmek icin tercih edilebilir

dt_puanlar.Rows[secilen].Delete();

da_puanlar.Update(dt_puanlar);

}

catch

{ }

listedoldur();

}

private void bkapat_Click(object sender, EventArgs e)

{

this.Close();

}

NYP-2 2016 Hafta-8

Etiketler: mysql, MySqlCommand, MySqlConnection, MySqlConnectionStringBuilder, MysqlDataAdapter

NYP-2 2016 7. Hafta Uygulamaları

caglarPosted on 9 Mayıs 2016 C#, Ders Notları, Nesneye Yönelik Programlama-II, Yazılım kategorisine gönderildi No Comments

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 tarifeler
{
    public partial class Form1 : Form
    {
        MySqlDataAdapter da_paket, da_musteri;
        DataTable dt_paket, dt_musteri;
        public Form1()
        {
            InitializeComponent();

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

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

            // paket tablosu
            MySqlCommand cmd_paket_sel = 
                new MySqlCommand("select id,adi,dk,sms,mb from paket", conn);
            MySqlCommand cmd_paket_ins =
                new MySqlCommand("insert into paket(adi,dk,sms,mb) values(@adi,@dk,@sms,@mb)", conn);
            cmd_paket_ins.Parameters.Add("@adi", MySqlDbType.VarChar, 45, "adi");
            cmd_paket_ins.Parameters.Add("@dk", MySqlDbType.Double, 11, "dk");
            cmd_paket_ins.Parameters.Add("@sms", MySqlDbType.Double, 11, "sms");
            cmd_paket_ins.Parameters.Add("@mb", MySqlDbType.Double, 11, "mb");

            MySqlCommand cmd_paket_upd = 
                new MySqlCommand("update paket set dk=@dk, sms=@sms, mb=@mb where id=@id", conn);
            cmd_paket_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");
            cmd_paket_upd.Parameters.Add("@dk", MySqlDbType.Double, 11, "dk");
            cmd_paket_upd.Parameters.Add("@sms", MySqlDbType.Double, 11, "sms");
            cmd_paket_upd.Parameters.Add("@mb", MySqlDbType.Double, 11, "mb");


            da_paket = new MySqlDataAdapter();
            da_paket.SelectCommand = cmd_paket_sel;
            da_paket.InsertCommand = cmd_paket_ins;
            da_paket.UpdateCommand = cmd_paket_upd;

            // musteri tablosu
            MySqlCommand cmd_musteri_sel = 
                new MySqlCommand("select id,musteriadi,paketid,k_dk,k_sms,k_mb from musteri", conn);
            MySqlCommand cmd_musteri_ins =
                new MySqlCommand("insert into musteri(musteriadi,paketid,k_dk,k_sms,k_mb) values(@musteriadi,@paketid,@k_dk,@k_sms,@k_mb)", conn);
            cmd_musteri_ins.Parameters.Add("@musteriadi", MySqlDbType.VarChar, 45, "musteriadi");
            cmd_musteri_ins.Parameters.Add("@paketid", MySqlDbType.Int32, 11, "paketid");
            cmd_musteri_ins.Parameters.Add("@k_dk", MySqlDbType.Int32, 11, "k_dk");
            cmd_musteri_ins.Parameters.Add("@k_sms", MySqlDbType.Int32, 11, "k_sms");
            cmd_musteri_ins.Parameters.Add("@k_mb", MySqlDbType.Int32, 11, "k_mb");

            MySqlCommand cmd_musteri_del = 
                new MySqlCommand("delete from musteri where id=@id", conn);
            cmd_musteri_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

            da_musteri = new MySqlDataAdapter();
            da_musteri.SelectCommand = cmd_musteri_sel;
            da_musteri.InsertCommand = cmd_musteri_ins;
            da_musteri.DeleteCommand = cmd_musteri_del;

            paketgetir();
            musterigetir();
        }


        private void paketgetir()
        {
            ctarife.Items.Clear();
            try
            {
                dt_paket = new DataTable();
                da_paket.Fill(dt_paket);
                int satirsay = dt_paket.Rows.Count;
                for (int i = 0; i < satirsay; i++)
                    ctarife.Items.Add(dt_paket.Rows[i]["adi"]);
            }
            catch
            { 
            }

            ctarife.Text = "Seçiniz";
        }

        private void musterigetir()
        {
            lmusteri.Items.Clear();
            ltarife.Items.Clear();
            ldk.Items.Clear();
            lsms.Items.Clear();
            lmb.Items.Clear();
            ltutar.Items.Clear();

            try
            {
                dt_musteri = new DataTable();
                da_musteri.Fill(dt_musteri);
                int satirsay = dt_musteri.Rows.Count;

                for (int i = 0; i < satirsay; i++)
                {

                    int paketid = (int)dt_musteri.Rows[i]["paketid"];

                    DataRow dr = tarifeyigetir(paketid);

                    if (dr != null)
                    {
                        double tutar = 
                            (int)dt_musteri.Rows[i]["k_dk"] * (double)dr["dk"] + 
                            (int)dt_musteri.Rows[i]["k_sms"] * (double)dr["sms"] + 
                            (int)dt_musteri.Rows[i]["k_mb"] * (double)dr["mb"];

                        lmusteri.Items.Add(dt_musteri.Rows[i]["musteriadi"]);
                        ltarife.Items.Add(dr["adi"]);
                        ldk.Items.Add(dt_musteri.Rows[i]["k_dk"]);
                        lsms.Items.Add(dt_musteri.Rows[i]["k_sms"]);
                        lmb.Items.Add(dt_musteri.Rows[i]["k_mb"]);
                        ltutar.Items.Add(tutar);
                    
                    
                    }
                
                }

            }
            catch
            { 
            
            }
        }


        private DataRow tarifeyigetir(int id)
        {
            try
            {
                DataRow[] drs=dt_paket.Select("id=" + id);
                if (drs.Length > 0)
                    return drs[0];
            }
            catch
            { 
            }

            return null;
        
        }

        private void bekle_Click(object sender, EventArgs e)
        {
            int dk, sms, mb;
            bool k1 = Int32.TryParse(tdk.Text, out dk);
            bool k2 = Int32.TryParse(tsms.Text, out sms);
            bool k3 = Int32.TryParse(tmb.Text, out mb);
            int secilen = ctarife.SelectedIndex;

            if(secilen>-1 && k1 && k2 && k3 && tmusteri.Text.Length>0)
            {
                try
                {
                    DataRow dr = dt_musteri.NewRow();
                    dr["musteriadi"] = tmusteri.Text;
                    dr["paketid"] =(int)dt_paket.Rows[secilen]["id"];
                    dr["k_dk"] = dk;
                    dr["k_sms"] = sms;
                    dr["k_mb"] = mb;
                    dt_musteri.Rows.Add(dr);
                    da_musteri.Update(dt_musteri);
                    
                    tmusteri.Clear();
                    ctarife.Text = "Seçiniz";
                    tdk.Clear();
                    tsms.Clear();
                    tmb.Clear();
                }
                catch
                { }

                musterigetir();
            }
        }

        private void bsil_Click(object sender, EventArgs e)
        {
            int secilen = lmusteri.SelectedIndex;
            if (secilen > -1)
            {
                try
                {
                    dt_musteri.Rows[secilen].Delete();
                    da_musteri.Update(dt_musteri);
                }
                catch
                { }
                musterigetir();
            }


        }

        private void btarife_Click(object sender, EventArgs e)
        {
            ftarifeler frm = new ftarifeler(da_paket);
            frm.ShowDialog();
            paketgetir();
        }
    }
}

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

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 tarifeler

{

public partial class Form1 : Form

{

MySqlDataAdapter da_paket, da_musteri;

DataTable dt_paket, dt_musteri;

public Form1()

{

InitializeComponent();

MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();

bag.Server = "localhost";

bag.UserID = "root";

bag.Password = "123456";

bag.Database = "hafta7_16_2";

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

// paket tablosu

MySqlCommand cmd_paket_sel =

new MySqlCommand("select id,adi,dk,sms,mb from paket", conn);

MySqlCommand cmd_paket_ins =

new MySqlCommand("insert into paket(adi,dk,sms,mb) values(@adi,@dk,@sms,@mb)", conn);

cmd_paket_ins.Parameters.Add("@adi", MySqlDbType.VarChar, 45, "adi");

cmd_paket_ins.Parameters.Add("@dk", MySqlDbType.Double, 11, "dk");

cmd_paket_ins.Parameters.Add("@sms", MySqlDbType.Double, 11, "sms");

cmd_paket_ins.Parameters.Add("@mb", MySqlDbType.Double, 11, "mb");

MySqlCommand cmd_paket_upd =

new MySqlCommand("update paket set dk=@dk, sms=@sms, mb=@mb where id=@id", conn);

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

cmd_paket_upd.Parameters.Add("@dk", MySqlDbType.Double, 11, "dk");

cmd_paket_upd.Parameters.Add("@sms", MySqlDbType.Double, 11, "sms");

cmd_paket_upd.Parameters.Add("@mb", MySqlDbType.Double, 11, "mb");

da_paket = new MySqlDataAdapter();

da_paket.SelectCommand = cmd_paket_sel;

da_paket.InsertCommand = cmd_paket_ins;

da_paket.UpdateCommand = cmd_paket_upd;

// musteri tablosu

MySqlCommand cmd_musteri_sel =

new MySqlCommand("select id,musteriadi,paketid,k_dk,k_sms,k_mb from musteri", conn);

MySqlCommand cmd_musteri_ins =

new MySqlCommand("insert into musteri(musteriadi,paketid,k_dk,k_sms,k_mb) values(@musteriadi,@paketid,@k_dk,@k_sms,@k_mb)", conn);

cmd_musteri_ins.Parameters.Add("@musteriadi", MySqlDbType.VarChar, 45, "musteriadi");

cmd_musteri_ins.Parameters.Add("@paketid", MySqlDbType.Int32, 11, "paketid");

cmd_musteri_ins.Parameters.Add("@k_dk", MySqlDbType.Int32, 11, "k_dk");

cmd_musteri_ins.Parameters.Add("@k_sms", MySqlDbType.Int32, 11, "k_sms");

cmd_musteri_ins.Parameters.Add("@k_mb", MySqlDbType.Int32, 11, "k_mb");

MySqlCommand cmd_musteri_del =

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

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

da_musteri = new MySqlDataAdapter();

da_musteri.SelectCommand = cmd_musteri_sel;

da_musteri.InsertCommand = cmd_musteri_ins;

da_musteri.DeleteCommand = cmd_musteri_del;

paketgetir();

musterigetir();

}

private void paketgetir()

{

ctarife.Items.Clear();

try

{

dt_paket = new DataTable();

da_paket.Fill(dt_paket);

int satirsay = dt_paket.Rows.Count;

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

ctarife.Items.Add(dt_paket.Rows[i]["adi"]);

}

catch

{

}

ctarife.Text = "Seçiniz";

}

private void musterigetir()

{

lmusteri.Items.Clear();

ltarife.Items.Clear();

ldk.Items.Clear();

lsms.Items.Clear();

lmb.Items.Clear();

ltutar.Items.Clear();

try

{

dt_musteri = new DataTable();

da_musteri.Fill(dt_musteri);

int satirsay = dt_musteri.Rows.Count;

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

{

int paketid = (int)dt_musteri.Rows[i]["paketid"];

DataRow dr = tarifeyigetir(paketid);

if (dr != null)

{

double tutar =

(int)dt_musteri.Rows[i]["k_dk"] * (double)dr["dk"] +

(int)dt_musteri.Rows[i]["k_sms"] * (double)dr["sms"] +

(int)dt_musteri.Rows[i]["k_mb"] * (double)dr["mb"];

lmusteri.Items.Add(dt_musteri.Rows[i]["musteriadi"]);

ltarife.Items.Add(dr["adi"]);

ldk.Items.Add(dt_musteri.Rows[i]["k_dk"]);

lsms.Items.Add(dt_musteri.Rows[i]["k_sms"]);

lmb.Items.Add(dt_musteri.Rows[i]["k_mb"]);

ltutar.Items.Add(tutar);

}

catch

{

}

private DataRow tarifeyigetir(int id)

{

try

{

DataRow[] drs=dt_paket.Select("id=" + id);

if (drs.Length > 0)

return drs[0];

}

catch

{

}

return null;

}

private void bekle_Click(object sender, EventArgs e)

{

int dk, sms, mb;

bool k1 = Int32.TryParse(tdk.Text, out dk);

bool k2 = Int32.TryParse(tsms.Text, out sms);

bool k3 = Int32.TryParse(tmb.Text, out mb);

int secilen = ctarife.SelectedIndex;

if(secilen>-1 && k1 && k2 && k3 && tmusteri.Text.Length>0)

{

try

{

DataRow dr = dt_musteri.NewRow();

dr["musteriadi"] = tmusteri.Text;

dr["paketid"] =(int)dt_paket.Rows[secilen]["id"];

dr["k_dk"] = dk;

dr["k_sms"] = sms;

dr["k_mb"] = mb;

dt_musteri.Rows.Add(dr);

da_musteri.Update(dt_musteri);

tmusteri.Clear();

ctarife.Text = "Seçiniz";

tdk.Clear();

tsms.Clear();

tmb.Clear();

}

catch

{ }

musterigetir();

}

private void bsil_Click(object sender, EventArgs e)

{

int secilen = lmusteri.SelectedIndex;

if (secilen > -1)

{

try

{

dt_musteri.Rows[secilen].Delete();

da_musteri.Update(dt_musteri);

}

catch

{ }

musterigetir();

}

private void btarife_Click(object sender, EventArgs e)

{

ftarifeler frm = new ftarifeler(da_paket);

frm.ShowDialog();

paketgetir();

}

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 tarifeler
{
    public partial class ftarifeler: Form
    {
        MySqlDataAdapter da;
        DataTable dt;
        public ftarifeler(MySqlDataAdapter _da)
        {
            InitializeComponent();
            da = _da;
            verigetir();
        }

        private void verigetir()
        {
            lad.Items.Clear();
            ldk.Items.Clear();
            lsms.Items.Clear();
            lmb.Items.Clear();
            try
            {
                dt = new DataTable();
                da.Fill(dt);
                int satirsay = dt.Rows.Count;
                for (int i = 0; i < satirsay; i++)
                {
                    lad.Items.Add(dt.Rows[i]["adi"]);
                    ldk.Items.Add(dt.Rows[i]["dk"]);
                    lsms.Items.Add(dt.Rows[i]["sms"]);
                    lmb.Items.Add(dt.Rows[i]["mb"]);
                }
            }
            catch
            { }
        }

        private void bekle_Click(object sender, EventArgs e)
        {
            double fdk, fsms, fmb;
            bool k1 = Double.TryParse(tdk.Text, out fdk);
            bool k2 = Double.TryParse(tsms.Text, out fsms);
            bool k3 = Double.TryParse(tmb.Text, out fmb);

            if (tad.Text.Length > 0 && k1 && k2 && k3)
            {
                try
                {
                    DataRow dr = dt.NewRow();
                    dr["adi"] = tad.Text;
                    dr["dk"] = fdk;
                    dr["sms"] = fsms;
                    dr["mb"] = fmb;

                    dt.Rows.Add(dr);
                    da.Update(dt);

                    tad.Clear();
                    tdk.Clear();
                    tsms.Clear();
                    tmb.Clear();
                }
                catch { 
                }

                verigetir();

            }
        }

        private void bduzenle_Click(object sender, EventArgs e)
        {
            double fdk, fsms, fmb;
            bool k1 = Double.TryParse(tdk.Text, out fdk);
            bool k2 = Double.TryParse(tsms.Text, out fsms);
            bool k3 = Double.TryParse(tmb.Text, out fmb);
            int secilen = lad.SelectedIndex;

            if ( secilen>-1 && k1 && k2 && k3)
            {
                try
                {
                    DataRow dr = dt.Rows[secilen];
                    dr["dk"] = fdk;
                    dr["sms"] = fsms;
                    dr["mb"] = fmb;
                    da.Update(dt);

                    tad.Clear();
                    tdk.Clear();
                    tsms.Clear();
                    tmb.Clear();
                
                }
                catch
                { }

                verigetir();
            }

        }

        private void bkapat_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

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 tarifeler

{

public partial class ftarifeler: Form

{

MySqlDataAdapter da;

DataTable dt;

public ftarifeler(MySqlDataAdapter _da)

{

InitializeComponent();

da = _da;

verigetir();

}

private void verigetir()

{

lad.Items.Clear();

ldk.Items.Clear();

lsms.Items.Clear();

lmb.Items.Clear();

try

{

dt = new DataTable();

da.Fill(dt);

int satirsay = dt.Rows.Count;

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

{

lad.Items.Add(dt.Rows[i]["adi"]);

ldk.Items.Add(dt.Rows[i]["dk"]);

lsms.Items.Add(dt.Rows[i]["sms"]);

lmb.Items.Add(dt.Rows[i]["mb"]);

}

catch

{ }

}

private void bekle_Click(object sender, EventArgs e)

{

double fdk, fsms, fmb;

bool k1 = Double.TryParse(tdk.Text, out fdk);

bool k2 = Double.TryParse(tsms.Text, out fsms);

bool k3 = Double.TryParse(tmb.Text, out fmb);

if (tad.Text.Length > 0 && k1 && k2 && k3)

{

try

{

DataRow dr = dt.NewRow();

dr["adi"] = tad.Text;

dr["dk"] = fdk;

dr["sms"] = fsms;

dr["mb"] = fmb;

dt.Rows.Add(dr);

da.Update(dt);

tad.Clear();

tdk.Clear();

tsms.Clear();

tmb.Clear();

}

catch {

}

verigetir();

}

private void bduzenle_Click(object sender, EventArgs e)

{

double fdk, fsms, fmb;

bool k1 = Double.TryParse(tdk.Text, out fdk);

bool k2 = Double.TryParse(tsms.Text, out fsms);

bool k3 = Double.TryParse(tmb.Text, out fmb);

int secilen = lad.SelectedIndex;

if ( secilen>-1 && k1 && k2 && k3)

{

try

{

DataRow dr = dt.Rows[secilen];

dr["dk"] = fdk;

dr["sms"] = fsms;

dr["mb"] = fmb;

da.Update(dt);

tad.Clear();

tdk.Clear();

tsms.Clear();

tmb.Clear();

}

catch

{ }

verigetir();

}

private void bkapat_Click(object sender, EventArgs e)

{

this.Close();

}

NYP-2 2016 Hafta-7

Etiketler: c#, mysql, mysql veritabanı, MySqlConnectionStringBuilder, MysqlDataAdapter

Java-2 2016 Hafta-10

caglarPosted on 9 Mayıs 2016 Ders Notları, JAVA, JAVA-II, Yazılım kategorisine gönderildi No Comments

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


public class ornek1 implements ActionListener {

	JList jl1,jl2;
	DefaultListModel dlm1,dlm2,dlm_id;
	JTextField jtf_isim,jtf_telno;
	public ornek1() {
		JFrame jfrm = new JFrame("Personel Bilgileri");
		jfrm.setLayout(new FlowLayout());
		jfrm.setSize(150,290);
		jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		
		JPanel jpn_main = new JPanel();
		jpn_main.setPreferredSize(new Dimension(150,290));
		jpn_main.setLayout(new GridLayout(1,2));
		
		jfrm.add(jpn_main);
		
		dlm_id= new DefaultListModel();
		
		JPanel jpn1 = new JPanel();
		dlm1= new DefaultListModel();
		jl1= new JList(dlm1);
		JScrollPane jscp1= new JScrollPane(jl1);
		jscp1.setPreferredSize(new Dimension(70,200));
		jpn1.add(jscp1);
		jtf_isim = new JTextField();
		jtf_isim.setPreferredSize(new Dimension(70,30));
		JButton jbtn1= new JButton("Ekle");
		jbtn1.addActionListener(this);
		jbtn1.setActionCommand("ekle");
		jbtn1.setPreferredSize(new Dimension(70,30));
		jpn1.add(jtf_isim);
		jpn1.add(jbtn1);
		
		JPanel jpn2 = new JPanel();
		dlm2= new DefaultListModel();
		jl2= new JList(dlm2);
		JScrollPane jscp2= new JScrollPane(jl2);
		jscp2.setPreferredSize(new Dimension(70,200));
		jpn2.add(jscp2);
		jtf_telno = new JTextField();
		jtf_telno.setPreferredSize(new Dimension(70,30));
		JButton jbtn2= new JButton("Sil");
		jbtn2.addActionListener(this);
		jbtn2.setPreferredSize(new Dimension(70,30));
		jpn2.add(jtf_telno);
		jpn2.add(jbtn2);	
		
		jpn_main.add(jpn1);
		jpn_main.add(jpn2);
		
		listedoldur();
		
		jfrm.setVisible(true);
	}

	public void listedoldur()
	{
		try{
		Connection conn = baglan();
		
		if(conn!=null)
		{
			dlm_id.clear();
			dlm1.clear();
			dlm2.clear();
			String sql="select id, isim, telno from personel;";
			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(sql);
			while(rs.next()) // kayit varsa
			{
				dlm_id.addElement(rs.getInt("id"));
				dlm1.addElement(rs.getString("isim"));
				dlm2.addElement(rs.getString("telno"));
			}
		}
		
		
		
		}catch(Exception ex)
		{
			System.out.println(ex);
			
		}
		
	}
	
	@Override
	public void actionPerformed(ActionEvent ae) {

		Connection conn = baglan();
		
		if(ae.getActionCommand().equals("ekle"))
		{
			try{
				
				if(jtf_isim.getText().length()>0 && 
						jtf_telno.getText().length()>0)
				{
					String sql = "insert into personel(isim,telno) values(?,?)";
					PreparedStatement ps = conn.prepareStatement(sql);
					ps.setString(1, jtf_isim.getText());
					ps.setString(2, jtf_telno.getText());
					ps.executeUpdate();
					
					jtf_isim.setText("");
					jtf_telno.setText("");
					listedoldur();
				}
			}
			catch(Exception ex)
			{
				System.out.println(ex);
				
			}
		}
		else
		{
			try{
				
				int secilen = jl1.getSelectedIndex();
				
				if(secilen>-1)
				{
					String sql = "delete from personel where id=?;";
					PreparedStatement ps = conn.prepareStatement(sql);
					ps.setInt(1, (int)dlm_id.get(secilen));
					ps.executeUpdate();
					listedoldur();
				}
				
			}
			catch(Exception ex)
			{
				System.out.println(ex);	
			}
			
		}
		

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

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		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

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

import javax.swing.*;

public class ornek1 implements ActionListener {

JList jl1,jl2;

DefaultListModel dlm1,dlm2,dlm_id;

JTextField jtf_isim,jtf_telno;

public ornek1() {

JFrame jfrm = new JFrame("Personel Bilgileri");

jfrm.setLayout(new FlowLayout());

jfrm.setSize(150,290);

jfrm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

JPanel jpn_main = new JPanel();

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

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

jfrm.add(jpn_main);

dlm_id= new DefaultListModel();

JPanel jpn1 = new JPanel();

dlm1= new DefaultListModel();

jl1= new JList(dlm1);

JScrollPane jscp1= new JScrollPane(jl1);

jscp1.setPreferredSize(new Dimension(70,200));

jpn1.add(jscp1);

jtf_isim = new JTextField();

jtf_isim.setPreferredSize(new Dimension(70,30));

JButton jbtn1= new JButton("Ekle");

jbtn1.addActionListener(this);

jbtn1.setActionCommand("ekle");

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

jpn1.add(jtf_isim);

jpn1.add(jbtn1);

JPanel jpn2 = new JPanel();

dlm2= new DefaultListModel();

jl2= new JList(dlm2);

JScrollPane jscp2= new JScrollPane(jl2);

jscp2.setPreferredSize(new Dimension(70,200));

jpn2.add(jscp2);

jtf_telno = new JTextField();

jtf_telno.setPreferredSize(new Dimension(70,30));

JButton jbtn2= new JButton("Sil");

jbtn2.addActionListener(this);

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

jpn2.add(jtf_telno);

jpn2.add(jbtn2);

jpn_main.add(jpn1);

jpn_main.add(jpn2);

listedoldur();

jfrm.setVisible(true);

}

public void listedoldur()

{

try{

Connection conn = baglan();

if(conn!=null)

{

dlm_id.clear();

dlm1.clear();

dlm2.clear();

String sql="select id, isim, telno from personel;";

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery(sql);

while(rs.next()) // kayit varsa

{

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

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

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

}

}catch(Exception ex)

{

System.out.println(ex);

}

@Override

public void actionPerformed(ActionEvent ae) {

Connection conn = baglan();

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

{

try{

if(jtf_isim.getText().length()>0 &&

jtf_telno.getText().length()>0)

{

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

PreparedStatement ps = conn.prepareStatement(sql);

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

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

ps.executeUpdate();

jtf_isim.setText("");

jtf_telno.setText("");

listedoldur();

}

catch(Exception ex)

{

System.out.println(ex);

}

else

{

try{

int secilen = jl1.getSelectedIndex();

if(secilen>-1)

{

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

PreparedStatement ps = conn.prepareStatement(sql);

ps.setInt(1, (int)dlm_id.get(secilen));

ps.executeUpdate();

listedoldur();

}

catch(Exception ex)

{

System.out.println(ex);

}

public Connection baglan()

{

Connection conn=null;

try{

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

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

}

catch(Exception ex)

{

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

}

return conn;

}

/**

* @param args

public static void main(String[] args) {

new ornek1();

}

Java-2 2016 Hafta-10

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