Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
- public class stdio {
- private String author;
- private static final String address = "stdio.vn";
- stdio(){
- author = "Kevin La";
- }
- stdio(String author_name){
- author = author_name;
- }
- public static void main(String [] args){
- //Call no arguments constructor
- stdio obj = new stdio();
- System.out.println(obj.author);
- //Call constructor has a argument
- stdio obj1 = new stdio("Alice");
- System.out.println(obj1.author);
- }
- }
- public class Calculation {
- void add(int param1, int param2){
- System.out.println(param1 + param2);
- }
- void add(float param1, float param2){
- System.out.println(param1 + param2);
- }
- public static void main(String [] args){
- Calculation obj = new Calculation();
- obj.add(10, 10);
- obj.add(10.5f, 10.24f);
- }
- }
- public class TestOverload {
- void method(Integer param){
- System.out.println("_Integer invoked");
- }
- void method(long param){
- System.out.println("_long invoked");
- }
- public static void main(String [] args){
- Calculation obj = new Calculation();
- obj.add(10);
- }
- }
- _long invoked
- class Animal{
- }
- class Dog extends Animal{
- }
- public class Test_Animal {
- void eat(Animal animal){
- System.out.println("Animal eats everything");
- }
- void eat(Dog dog){
- System.out.println("Dogs eat meat");
- }
- public static void main(String [] args){
- Test_Animal obj = new Test_Animal();
- Animal animal = new Animal();
- Dog dog = new Dog();
- Animal animal_obj = new Dog();
- obj.eat(animal);
- obj.eat(dog);
- obj.eat(animal_obj);
- }
- }
- Animal eats everything
- Dogs eat meat
- Animal eats everything
| Note: |
|---|
|
For more information about the SQL escape sequences,
see Using SQL Escape Sequences.
|
| Note: |
|---|
|
The JDBC driver does not support the use of CURSOR,
SQLVARIANT, TABLE, and TIMESTAMP SQL Server data types as OUT
parameters.
|
CREATE PROCEDURE GetImmediateManager @employeeID INT, @managerID INT OUTPUT AS BEGIN SELECT @managerID = ManagerID FROM HumanResources.Employee WHERE EmployeeID = @employeeID END
Note:public static void executeStoredProcedure(Connection con) {
try {
CallableStatement cstmt = con.prepareCall("{call dbo.GetImmediateManager(?, ?)}");
cstmt.setInt(1, 5);
cstmt.registerOutParameter(2, java.sql.Types.INTEGER);
cstmt.execute();
System.out.println("MANAGER ID: " + cstmt.getInt(2));
}
catch (Exception e) {
e.printStackTrace();
}
}
public static void executeStoredProcedure(Connection con) {
try {
CallableStatement cstmt = con.prepareCall("{call dbo.GetImmediateManager(?, ?)}");
cstmt.setInt("employeeID", 5);
cstmt.registerOutParameter("managerID", java.sql.Types.INTEGER);
cstmt.execute();
System.out.println("MANAGER ID: " + cstmt.getInt("managerID"));
cstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}
| Note: |
|---|
|
These examples use the execute method of
the SQLServerCallableStatement class to run the stored procedure. This is
used because the stored procedure did not also return a result set. If it did,
the executeQuery method would be
used.
|
create function checkFunc(
@MaSP varchar(10)
)
returns int
AS
BEGIN
declare @kq int
IF EXISTS(SELECT * FROM SANPHAM WHERE MaSP=@MaSP) set @kq=2
ELSE
BEGIN
set @kq = 0
END
return @kq
END
//execute
select dbo.checkFunc('sp02')
public int checkSanPham() {
sql = "select dbo.checkFunc(?)";
connection = connectDB.getConnect();
int kq = 0;
try {
ps = connection.prepareStatement(sql);
ps.setString(1, "sp02");
rs = ps.executeQuery();
if(rs.next()){
System.out.println(rs.getInt(1));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
ps.close();
connection.close();
} catch (Exception e2) {
}
}
return kq;
}
create proc sp_insert
@MaSP varchar(10),
@TenSP varchar(50),
@MaLoaiSP varchar(10),
@GiaBan int,
@SoLuong int
AS
BEGIN
--kiem tra Ma loai san pham co ton tai trong bang LOAISP
IF EXISTS(SELECT TOP 1 MaLoaiSP FROM LOAISP WHERE MaLoaiSP = @MaLoaiSP)
BEGIN
-- Kiem tra neu k ton tai ma san pham thi cho insert
IF NOT EXISTS(SELECT TOP 1 MaSP FROM SANPHAM WHERE MaSP = @MaSP)
BEGIN
INSERT INTO SANPHAM (MaSP,TenSP,MaLoaiSP,GiaBan,SoLuong) VALUES(@MaSP, @TenSP, @MaLoaiSP, @GiaBan, @SoLuong)
END
ELSE
BEGIN
print ('Trung khoa chinh')
END
END
ELSE
BEGIN
print ('MaLoaiSP khong ton tai')
END
END
--execute
exec sp_insert 'sp09','kaka','type001','10','10'
public void themSanPham(String maSP, String tenSP, String maLoaiSP,
String giaBan, String soLuong) {
sql = "{call sp_insert(?,?,?,?,?)}";
connection = connectDB.getConnect();
CallableStatement cs = null;
try {
cs = connection.prepareCall(sql);
cs.setString(1, maSP);
cs.setString(2, tenSP);
cs.setString(3, maLoaiSP);
cs.setInt(4, Integer.valueOf(giaBan));
cs.setInt(5, Integer.valueOf(soLuong));
int i = cs.executeUpdate();
System.out.println(i);
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
cs.close();
connection.close();
} catch (Exception e2) {
}
}
}
