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:

  • UDPServer UDPClient Converting String to Int in Java? Integer x = Integer.valueOf(str); // or int y = Integer.parseInt(str); int foo = Integer.parseInt("1234"); UDPServer UDPClient Servlet package demo5; import java.net.DatagramPacket; i… Read More
  • JAVA servlet MVC2 WEB Configuration WebContent/WEB-INF/config.properties /bbs.do=com.mvc.bbs.BoardAction /guest.do=com.mvc.guest.GuestAction cs WebContent/WEB-INF/web.xml <servlet>     <servlet-name>… 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
  • TCPClient TCPServer package aptech.edu; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.net.Socket; import java.net.UnknownHostException; public class TCPClient { public static void main(St… Read More
  • JDBC - insert, delete, display, Connnection Database Display connection mysql workbench Install : https://www.youtube.com/watch?v=V8F-RxzI_2w 1- Insert /2-Delete/3-Display/ 4-Exit 3 Connecting to database... ID: 1, Name: Dai, Class: cl, Age: 13 ID: 3, Name: Dang, Class:… Read More

0 nhận xét:

Post a Comment

 

BACK TO TOP

Xuống cuối trang