การต่อ DATABASE MySQL พร้อม Insert Image 
Tuesday, December 3, 2013, 07:24 PM
Posted by Administrator
Insert และ เอา รูป จาก Database มาแสดง
1 create table ดังนี้
CREATE TABLE `customers` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL,
`surname` varchar(30) NOT NULL,
`phone` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

สร้างหน้าตาดังนี้






















ด้านซ้ายคือ ImagePanel ซึ่งมี code ดังนี้





import java.awt.Graphics;
import java.awt.image.BufferedImage;
import javax.swing.JPanel;
public class ImagePanel extends JPanel{
	BufferedImage  img;
	public ImagePanel(){}
	public void setImage(BufferedImage i){
		img = i;
		repaint();
	}
	public BufferedImage getImage(){
		return img;
	}
	public void paint(Graphics g){
		g.drawImage(img, 0, 0,this.getWidth(),this.getHeight(), this);
	}
}



code ของหน้าจอหลัก

import java.awt.EventQueue;

import javax.imageio.ImageIO;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.filechooser.FileFilter;
import javax.swing.JButton;
import javax.swing.JFileChooser;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.UIManager;

import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.IOException;
import java.sql.*;

public class InsertProduct extends JFrame
{

	private JPanel contentPane;
	private JTextField txt_name;
	private JTextField txt_price;
	private ImagePanel imagePanel;

	/**
	 * Launch the application.
	 */
	public static void main(String[] args)
	{
		try
		{
			UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
		} catch (Exception e){}
		EventQueue.invokeLater(new Runnable()
		{
			public void run()
			{
				try
				{
					InsertProduct frame = new InsertProduct();
					frame.setVisible(true);
				} catch (Exception e)
				{
					e.printStackTrace();
				}
			}
		});
	}
	public InsertProduct()
	{
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 450, 300);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);

		imagePanel = new ImagePanel();
		imagePanel.setBounds(10, 11, 248, 240);
		contentPane.add(imagePanel);

		JButton btnBrowse = new JButton("browse image");
		btnBrowse.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent arg0)
			{
				JFileChooser fc = new JFileChooser("c://");
				fc.setFileFilter(new JPEGImageFileFilter());
				int res = fc.showOpenDialog(null);
				if (res == JFileChooser.APPROVE_OPTION)
				{
					File file = fc.getSelectedFile();
					// this.
					try
					{
						imagePanel.setImage(ImageIO.read(file));
					} catch (IOException e)
					{
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
			}
		});
		btnBrowse.setBounds(268, 11, 156, 23);
		contentPane.add(btnBrowse);

		JLabel lblProductName = new JLabel("product name");
		lblProductName.setBounds(268, 51, 102, 14);
		contentPane.add(lblProductName);

		txt_name = new JTextField();
		txt_name.setBounds(268, 74, 156, 23);
		contentPane.add(txt_name);
		txt_name.setColumns(10);

		JLabel lblPricePerUnit = new JLabel("price per unit");
		lblPricePerUnit.setBounds(268, 108, 102, 14);
		contentPane.add(lblPricePerUnit);

		txt_price = new JTextField();
		txt_price.setColumns(10);
		txt_price.setBounds(268, 131, 156, 23);
		contentPane.add(txt_price);

		JButton btn_insert = new JButton("Insert");
		btn_insert.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				try
				{
					Connection con = null;
					Class.forName("com.mysql.jdbc.Driver");
					con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/yyy", "root", "1234");

					Class.forName("com.mysql.jdbc.Driver");

					String price = txt_price.getText();
					String name = txt_name.getText();

					String insert = "INSERT INTO product(id,name,price_per_unit,image) " + " VALUES (0,?,?,?)";

					PreparedStatement preparedStmt = con.prepareStatement(insert);
					ByteArrayOutputStream buff = new ByteArrayOutputStream();
					ImageIO.write(imagePanel.getImage(), "PNG", buff);
					byte[] buff_temp = buff.toByteArray();
					ByteArrayInputStream inBuff = new ByteArrayInputStream(buff_temp);

					preparedStmt.setString(1, name);
					preparedStmt.setString(2, price);
					preparedStmt.setBinaryStream(3, inBuff, buff_temp.length);

					preparedStmt.execute();
					System.out.println("finish");
					con.close();
				} catch (Exception ee)
				{
					ee.printStackTrace();
				}
			}
		});
		btn_insert.setBounds(269, 185, 89, 23);
		contentPane.add(btn_insert);
	}
}
class JPEGImageFileFilter extends FileFilter implements java.io.FileFilter{
	public boolean accept(File f){
		if (f.getName().toLowerCase().endsWith(".jpeg"))
			return true;
		if (f.getName().toLowerCase().endsWith(".jpg"))
			return true;
		if (f.isDirectory())
			return true;
		return false;
	}
	public String getDescription()
	{
		return "JPEG files";
	}
}




จะเห็นว่า ตอนInsert จะใช้ PreparedStatement มาช่วย
ByteArrayOutputStream buff = new ByteArrayOutputStream();
ImageIO.write(imagePanel.getImage(), "PNG", buff);
byte[] buff_temp = buff.toByteArray();
ByteArrayInputStream inBuff = new ByteArrayInputStream(buff_temp);

ส่วนนี้ใช้ Save Image ลง Memory ก่อน แล้วค่อย Save ลง DATABASE อีกทีหนึ่ง


ดึงข้อมูลพ้อมรูปมาแสดง




import java.awt.image.BufferedImage;
import javax.swing.JPanel;
import javax.swing.JLabel;
public class ProductPanel extends JPanel
{
public ProductPanel()
{
setLayout(null);
imagePanel = new ImagePanel();
imagePanel.setBounds(0, 0, 223, 109);
add(imagePanel);
label_id = new JLabel("New label");
label_id.setBounds(322, 9, 118, 26);
add(label_id);
label_name = new JLabel("New label");
label_name.setBounds(322, 46, 118, 26);
add(label_name);
label_price = new JLabel("New label");
label_price.setBounds(322, 83, 118, 26);
add(label_price);
lblUd = new JLabel("id");
lblUd.setBounds(233, 9, 62, 26);
add(lblUd);
lblName = new JLabel("name");
lblName.setBounds(233, 46, 62, 26);
add(lblName);
lblPricePerUnit = new JLabel("price per unit");
lblPricePerUnit.setBounds(233, 83, 79, 26);
add(lblPricePerUnit);
}

public void setParam(int id, String name, double price, BufferedImage img)
{
this.id=id;
this.name= name;
this.price=price;
this.img=img;

label_id.setText(""+ this.id);
label_name.setText(""+ this.name);
label_price.setText(""+ this.price);

imagePanel.setImage(img);
}

public int id;
public String name;
public double price;
public BufferedImage img;

private JLabel label_price;
private JLabel label_name;
private JLabel label_id;
private ImagePanel imagePanel;
private JLabel lblUd;
private JLabel lblName;
private JLabel lblPricePerUnit;

}




import java.awt.EventQueue; 
import java.awt.image.BufferedImage;
import java.sql.*;

import javax.imageio.ImageIO;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder; 


public class selectProduct extends JFrame
{

	private JPanel contentPane;

	public static void main(String[] args)
	{
		EventQueue.invokeLater(new Runnable()
		{
			public void run()
			{
				try
				{
					selectProduct frame = new selectProduct();
					frame.setVisible(true);
				} catch (Exception e)
				{
					e.printStackTrace();
				}
			}
		});
	}

	public selectProduct()
	{
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 450, 300);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);
		// //////////////////////////////////
		try
		{
			Connection con = null;
			Class.forName("com.mysql.jdbc.Driver");
			con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/yyy", "root", "1234");
			Statement st = con.createStatement();
			ResultSet rs = st.executeQuery("SELECT * FROM product");
			Class.forName("com.mysql.jdbc.Driver");

			int i=0;
			while (rs.next())
			{
				ProductPanel pp = new ProductPanel();
				BufferedImage img = ImageIO.read(rs.getBinaryStream(4));
				pp.setParam(rs.getInt(1), rs.getString(2), rs.getDouble(3), img);
				pp.setBounds(0, i*120 + 20, 500, 120);
				this.contentPane.add(pp);
				
				System.out.println(pp.id +" "+ pp.name);
				i++;
			}

		} catch (Exception ee)
		{
			ee.printStackTrace();
		}

	}
}



อาจต้องมีการ set ค่าในดรสำ my.ini สำหรับ ขนาดของ รูป
max_allowed_packet=500M

[ view entry ] ( 2532 views )   |  permalink  |  $star_image$star_image$star_image$star_image$star_image ( 2.9 / 1485 )
ดึง RSS โดยใช้ JAVA 
Tuesday, October 8, 2013, 07:58 PM
Posted by Administrator

ดึง RSS โดยใช้ JAVA




try
		{
			URL yahoo = new URL("http://rss.cnn.com/rss/edition.rss");
			BufferedReader in = new BufferedReader(new InputStreamReader(yahoo.openStream()));
			Scanner sc = new Scanner(in);

			while (sc.hasNext())
			{
				String s = sc.nextLine();
				System.out.println(s);
			}

			sc.close();

		} catch (MalformedURLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}


ในอันนี้จะเป็นการดึง RSS โดยใช้ JAVA ครับ




[ view entry ] ( 17529 views )   |  permalink  |  $star_image$star_image$star_image$star_image$star_image ( 3 / 2280 )
วาดรูปต้นไม้ Binary Search Tree 
Friday, September 27, 2013, 01:38 AM
Posted by Administrator

เป็นการวาดรูปต้นไม้ binary search tree ครับ






class Tree node

import java.awt.Color;
import java.awt.Graphics;

public class TreeNode {
	public int data;
	public TreeNode left, right;

	public TreeNode() {
	}

	public TreeNode(int x) {
		data = x;
	}

	public void draw(Graphics g, int x, int y) {

		
		g.setColor(Color.pink);
		g.fillOval(x, y, 40, 40);
		g.setColor(Color.black);
		g.drawString("" + data, x + 15, y + 23);

	}
}




class BSTree

import java.awt.Graphics;

public class BSTree {
	public TreeNode root;

	public void add(int x) {
		if (root == null) {
			root = new TreeNode(x);
			return;
		}
		add(x, root);
	}

	public void add(int x, TreeNode n) {
		if (n == null)
			return;
		if (n.data == x)
			return;

		if (n.data < x) {
			if (n.right == null) {
				n.right = new TreeNode(x);
			} else {
				add(x, n.right);
			}
		} else {
			if (n.left == null) {
				n.left = new TreeNode(x);
			} else {
				add(x, n.left);
			}
		}
	}

	public int numNode(TreeNode n) {
		if (n == null)
			return 0;
		int k = 0;
		if (n.left != null) {
			k = k + numNode(n.left);
		}
		if (n.right != null) {
			k = k + numNode(n.right);
		}

		return k + 1;
	}

	public int height(TreeNode n) {
		if (n == null)
			return -1;
		if (n.left == null && n.right == null) {
			return 0;
		}
		int kl = 0;
		int kr = 0;

		if (n.left != null) {
			kl = height(n.left);
		}
		if (n.right != null) {
			kr = height(n.right);
		}

		return kl > kr ? kl + 1 : kr + 1;
	}

	int stepX;
	int stepY;

	public void draw(Graphics g, int width, int height) {

		int num = numNode(root);
		int h = height(root);

		stepX = width / (num + 1);
		stepY = height / (h + 1);

		draw(g, 1, num, 1, root,-1,-1);
	}

	public int draw(Graphics g, int start_x, int end_x, int height, TreeNode t,int x_mom ,int y_mom) {
		int num_l = numNode(t.left);

		int x_now=(num_l + start_x) * stepX;
		int y_now= height * stepY;
		
		
		
		t.draw(g, x_now, y_now);
		
		if (t.left != null) {
			draw(g, start_x, start_x + num_l - 1, height + 1, t.left,x_now, y_now);
		}
		if (t.right!= null) {
			draw(g, start_x + num_l + 1, end_x, height + 1, t.right,x_now, y_now);
		}
		
		if(x_mom != -1 && y_mom !=-1)
		{
			g.drawLine(x_mom+15, y_mom+15, x_now+15, y_now+15);
		}
		return 0;
	}

}



call GUI

import java.awt.Graphics;

import javax.swing.JFrame;
import javax.swing.JPanel;

public class GUI extends JPanel {
	BSTree t;
	public GUI() {
		  t = new BSTree();
		for (int i = 0; i < 100; i++) {
			int k=(int) (Math.random() * 100);
			t.add(k);
			System.out.println(k);
		}
		System.out.println(t.height(t.root));

		JFrame f = new JFrame();
		f.add(this);
		f.setSize(600, 600);
		f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		f.setVisible(true);

	}

	public void paint(Graphics g) {
		super.paint(g);
		if(t!=null){
			t.draw(g, this.getWidth(), this.getHeight());
		}
	}

	public static void main(String[] args) {

		new GUI();
	}

}




** ดัดแปลงจากในหนังสือของอาจารย์สมชาย โครงสร้างข้อมูล : ฉบับวาจาจาวา (สมชาย ประสิทธิ์จูตระกูล)**



[ view entry ] ( 20951 views )   |  permalink  |  $star_image$star_image$star_image$star_image$star_image ( 3 / 2463 )
เกม Pong คล้ายๆของ Steve Jobs โดย VB.net ครับ  
Wednesday, September 18, 2013, 12:25 PM
Posted by Administrator

ยังไม่เสร็จสมบูรณ์เป็นโจทย์ให้นร.ไปทำต่อนะครับ






Public Class Form1
    Dim a(5, 5) As Double
    Dim colors(5, 5) As Color
    Dim rand As Random = New Random
    Dim ballsize As Integer = 20
    Dim x, y, vx, vy As Integer


    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        For i = 0 To a.GetUpperBound(0)

            For j = 0 To a.GetUpperBound(0)
                a(i, j) = 1
                colors(i, j) = Color.FromArgb(rand.Next(255), rand.Next(255), rand.Next(255)) 
            Next
        Next
        Me.DoubleBuffered = True

        x = 300
        y = 300
        vx = rand.NextDouble * 20 - 10
        vy = rand.NextDouble * 20 - 10

        Timer1.Start()
        Timer1.Interval = 10
    End Sub



    Private Sub Form1_Paint(sender As Object, e As PaintEventArgs) Handles MyBase.Paint
        Dim w, h As Integer
        w = Me.Width
        h = 80

        For i = 0 To a.GetUpperBound(0)

            For j = 0 To a.GetUpperBound(0)
                If a(i, j) = 1 Then
                    e.Graphics.FillRectangle(New SolidBrush(colors(i, j)), _
                                             CInt(j * w / a.GetLength(1)), _
                                             CInt(i * h / a.GetLength(0)), _
                                            CInt(w / a.GetLength(1)), _
                                            CInt(h / a.GetLength(0)))
                End If
            Next
        Next

        e.Graphics.FillEllipse(New SolidBrush(Color.Red), _
                                             CInt(x - ballsize), _
                                             CInt(y - ballsize), _
                                            CInt(ballsize * 2), _
                                            CInt(ballsize * 2))

    End Sub
    Private Sub Form1_SizeChanged(sender As Object, e As EventArgs) Handles MyBase.SizeChanged
        Refresh()
    End Sub
    Private Sub Timer1_Tick(sender As Object, e As EventArgs) Handles Timer1.Tick
        Dim w, h As Integer
        w = Me.Width
        h = 80
        x = x + vx
        y = y + vy
        If x + ballsize > Me.Width Then
            x = Me.Width - ballsize
            vx = vx * -1
        End If

        If y + ballsize > Me.Height Then
            y = Me.Height - ballsize
            vy = vy * -1
        End If
        If x - ballsize < 0 Then
            x = 0 + ballsize
            vx = vx * -1
        End If

        If y - ballsize < 0 Then
            y = 0 + ballsize
            vy = vy * -1
        End If

        For i = 0 To a.GetUpperBound(0)

            For j = 0 To a.GetUpperBound(0)
                If a(i, j) = 1 Then
                    If x - ballsize < j * w / a.GetLength(1) + w / a.GetLength(1) And _
                       x - ballsize > j * w / a.GetLength(1) And _
                       y - ballsize < i * h / a.GetLength(0) + h / a.GetLength(0) And _
                       y - ballsize > i * h / a.GetLength(0) _
                       Then
                        a(i, j) = 0
                        vy = vy * -1
                    End If
                End If
            Next
        Next
        Refresh()
    End Sub
End Class



[ view entry ] ( 2524 views )   |  permalink  |  $star_image$star_image$star_image$star_image$star_image ( 3 / 2213 )
โรงแรมในฝัน 
Monday, September 16, 2013, 03:21 PM
Posted by Administrator

โจทย์การบ้าน นักเรียน ม.3


-------------
โรงแรมในฝัน (Hotel)
โรงแรมแคนทารีฮิลล์เป็นโรงแรมขนาดใหญ่ซึ่งมีจํานวนห้องพักไม่จํากัด โดย มีรายละเอียดประเภทห้องพัก
และราคาที่พักดังตารางต่อไปนี้



 
ประเภทของห้อง 	จํานวนคนที่พักมากที่สุดต่อห้อง		ราคาต่อห้อง(บาท)
ห้องเดี่ยว 		     1 				                  500
ห้องคู่ 			      2	                      800
ห้องกลาง 		    5                       1,500
ห้องพักรวม 		   15                      3,000



งานของคุณ
ให้เขียนโปรแกรมในการคํานวณหาห้องพักให้กับคนที่ต้องการเข้าพักจํานวน n คน โดยให้มีราคารวมของห้องพักต่ําที่สุด

ข้อมูลนําเข้า
มีหนึ่งบรรทัด เป็นจํานวนเต็มบวกที่เป็นค่าของ n โดยที่1 ≤ n ≤ 1,000,000

ข้อมูลส่งออก
มีหนึ่งบรรทัด เป็นจํานวนเต็มบวกที่เป็นราคารวมของห็องพักต่ำที่สุด

ตัวอย่างที่ 1
ข้อมูลนําเข้า
21
ข้อมูลส่งออก
5000


ตัวอย่างที่ 2
ข้อมูลนําเข้า
24
ข้อมูลส่งออก
6000าเข้า
24
ข้อมูลส่งออก
6000

idea (อาจจะไม่ใช่วิธีที่ดีที่สุดนะคราาาาบ)



#include <stdio.h>
#include <conio.h>

void main()
{
	int price[4] = {500,800,1500,300};
	int num[4] = {1,2,5,15};

	int data[1000][4];
	int data_price[1000];

	data[0][0] =0;	data[0][1] =0;	data[0][2] =0;	data[0][3] =0;		data_price[0]=0;
	data[1][0] =1;	data[1][1] =0;	data[1][2] =0;	data[1][3] =0;		data_price[1]=500;
	data[2][0] =0;	data[2][1] =2;	data[2][2] =0;	data[2][3] =0;		data_price[2]=800;
	data[3][0] =1;	data[3][1] =2;	data[3][2] =0;	data[3][3] =0;		data_price[3]=1300;
	data[4][0] =0;	data[4][1] =0;	data[4][2] =4;	data[4][3] =0;		data_price[4]=1500;
	data[5][0] =0;	data[5][1] =0;	data[5][2] =5;	data[5][3] =0;		data_price[5]=1500;



	data[6][0] =1;	data[6][1] =0;	data[6][2] =5;	data[6][3] =0;		data_price[6]=2000;
	data[7][0] =0;	data[7][1] =2;	data[7][2] =5;	data[7][3] =0;		data_price[7]=2300;
	data[8][0] =1;	data[8][1] =2;	data[8][2] =5;	data[8][3] =0;		data_price[8]=2800;

	data[9][0] =0;	data[9][1] =0;	data[9][2] =0;	data[9][3] =9;		data_price[9]=3000;
	data[10][0] =0;	data[10][1] =0;	data[10][2] =0;	data[10][3] =10;	data_price[10]=3000;
	data[11][0] =0;	data[11][1] =0;	data[11][2] =0;	data[11][3] =11;	data_price[11]=3000;
	data[12][0] =0;	data[12][1] =0;	data[12][2] =0;	data[12][3] =12;	data_price[12]=3000;
	data[13][0] =0;	data[13][1] =0;	data[13][2] =0;	data[13][3] =13;	data_price[13]=3000;
	data[14][0] =0;	data[14][1] =0;	data[14][2] =0;	data[14][3] =14;	data_price[14]=3000;
	data[15][0] =0;	data[15][1] =0;	data[15][2] =0;	data[15][3] =15;	data_price[15]=3000;


	
	for(int i=16;i< 100;i++) 
	{
		int min_index= 0;
		int min= 2147483647 ;
		for(int j=1;j<= i/2;j++)
		{
			
			int sum = data_price[j] + data_price[i-j];
			if(sum < min)
			{
				min = sum;
				min_index = j;
			}
		}
		
		data_price = min;

		data[0] =	data[i-min_index][0]+data[min_index][0];	
		data[1] =	data[i-min_index][1]+data[min_index][1];
		data[2] =	data[i-min_index][2]+data[min_index][2];
		data[3] =	data[i-min_index][3]+data[min_index][3 ];
	}


	for(int i=0;i< 100;i++)
	{
		printf(" = %d:\t" ,i  );
		for(int j=0;j< 4;j++)
		{
			printf("%d\t" ,data[j] );
		}
		printf(" = %d\n" ,data_price  );
		
	}



	getch();
}



[ view entry ] ( 1452 views )   |  permalink  |  $star_image$star_image$star_image$star_image$star_image ( 3.1 / 29 )

<<First <Back | 1 | 2 | 3 | 4 | 5 | Next> Last>>