01 May 2016

insert update delete select store procedure mysql in java swing


Create Update store procedure mysql


CREATE PROCEDURE updateStudent      
 (        
     IN  p_id                   INT(11) ,         
     IN  Name                 VARCHAR(45)  ,       
     IN  Class                 VARCHAR(45)  ,       
     IN  Address              VARCHAR(145)
) 
BEGIN   
UPDATE students  
    SET       
            name = Name   
            class = Class  
            address = Address             
    WHERE id = p_id ;  
END 
http://www.sqlinfo.net/mysql/mysql_stored_procedure_UPDATE.php
String sql = "{CALL updateStudent (?,?,?,?)}";
cstmt = conn.prepareCall(sql);
     
cstmt.setInt(1, id);
cstmt.setString(2, txtName.getText());
cstmt.setString(3, txtClass.getText());
cstmt.setString(4, txtAddress.getText());
cstmt.executeUpdate();
Create query delete store procedure mysql

CREATE PROCEDURE deleteStudent (IN p_id int(11))
BEGIN
     Delete From students where id = p_id;

END
http://www.sqlinfo.net/mysql/mysql_stored_procedure_DELETE.php
String sql = "{CALL deleteStudent(?)}";
cstmt = conn.prepareCall(sql);
     
cstmt.setInt(1, id);
cstmt.executeUpdate();
Create query select store procedure mysql

CREATE PROCEDURE selectStudent()
BEGIN
     SELECT * FROM students;

END
http://www.sqlinfo.net/mysql/mysql_stored_procedure_SELECT.php
String sql = "{CALL selectStudent()}";
cstmt = conn.prepareCall(sql);
     
cstmt.executeQuery();
while(rs.next()){
 //Do some thing
}
Create query Insert store procedure mysql


CREATE PROCEDURE insertStudent(
IN p_name VARCHAR(45),
IN p_age INT(11), 
IN p_class VARCHAR(45),
IN p_address VARCHAR(145),
IN p_birthday DATE, 
IN p_images BLOB)
BEGIN
INSERT INTO students (name,age,class,address,birthday,images)

VALUES (p_name,p_age,p_class,p_address,p_birthday,p_images);

END
String sql = "{CALL insertStudent(?,?,?,?,?,?)}";
cstmt = conn.prepareCall(sql);

cstmt.setString(1, txtName.getText()); //String
cstmt.setInt(2, Integer.parseInt(txtAge.getText())); //int
cstmt.setString(3, txtClass.getText());  //String
cstmt.setString(4, txtAddress.getText());  //String
cstmt.setString(5, new SimpleDateFormat("yyyy-MM-dd").format(date)); //date
cstmt.setBinaryStream(6, fin, (int) imgfile.length()); //images

cstmt.executeUpdate();


SELECT Count OUT

CREATE PROCEDURE `getSinhVienTuoi`(OUT young int, OUT old int)
BEGIN
-- young --
    SELECT count(*) INTO young from sinhvien WHERE age < 18;
    
    -- old -- 
    SELECT count(*) INTO old from sinhvien WHERE age >= 18;
END

-- RUN in mysql --

SELECT * from sinhvien;
Call getSinhVienTuoi(@young, @old);
SELECT @old;




Related Posts:

  • StringClient StringServer package network.sample; import java.io.DataInputStream; import java.io.DataOutputStream; import java.io.IOException; import java.net.Socket; public class StringClient { public static void main(String args[]) { try { … Read More
  • Ví dụ Servlet tính tổngServlet in java Enter number for loop  = sum TCPServer.java package network.sample; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.net.ServerSocket; import java.net… Read More
  • Ví dụ Servlet java Ví Dụ Về Servlet 1.Giao thức HTTP Giao thức HTTP cung cấp cho bạn cách thức trò chuyện giữa trình khách(thường là trình duyệt Browser) và trình chủ(web server) khá hiệu quả. GET: Yêu cầu trình chủ trả về nội dung… Read More
  • TCPServer TCPClient Display: Gui a Nhan97 Gui b Nhan98 Gui c Nhan99 Gui d Nhan100 Gui e Nhan101 Gui f Nhan102 Gui g Nhan103..... package network.sample; import java.io.IOException; import java.io.InputStream; import java.io.Out… Read More
  • NumberClient NumberServer MVC: Model View Controller Design Patterns - MVC package network.sample; import java.io.IOException; import java.io.ObjectInputStream; import java.io.ObjectOutputStream; import java.net.Socket; import java.util.Sca… Read More

0 nhận xét:

Post a Comment

 

BACK TO TOP

Xuống cuối trang