package test;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Types;
public class Text {
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Connection con=Text.getConnection();
// System.out.println(con);
CallableStatement cs = con.prepareCall("{?=call hm_pro_product_limit()}");//hm_pro_product_limit()存储过程的名字
//没有参数的函数
cs.registerOutParameter(1, Types.VARCHAR);//第一个占位为输出,类型是varchar
cs.execute(); //不能忘记execute()
System.out.println(cs.getString(1)); //打印输出结果,对应registerOutParameter
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection con = null;
try {
Class.forName("org.postgresql.Driver");
String url="jdbc:postgresql://127.0.0.1/postgres";
String user="postgres";
String pwd="postgres";
con = DriverManager.getConnection(url,user,pwd);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
}
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Types;
public class Text {
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Connection con=Text.getConnection();
// System.out.println(con);
CallableStatement cs = con.prepareCall("{?=call hm_pro_product_limit()}");//hm_pro_product_limit()存储过程的名字
//没有参数的函数
cs.registerOutParameter(1, Types.VARCHAR);//第一个占位为输出,类型是varchar
cs.execute(); //不能忘记execute()
System.out.println(cs.getString(1)); //打印输出结果,对应registerOutParameter
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection con = null;
try {
Class.forName("org.postgresql.Driver");
String url="jdbc:postgresql://127.0.0.1/postgres";
String user="postgres";
String pwd="postgres";
con = DriverManager.getConnection(url,user,pwd);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
}