java CallableStatement怎么取整数,改为取字符串
连接数据库,建立个存储过程create procedure proc_getTel
(
@empAccount varchar(16),
@empTel varchar(32) output
)
as
begin
select @empTel=empTel from Employee
WHERE empAccount=@empAccount
END
在JAVA平台上用CallableStatement控制
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.util.Scanner;
public class D14_7 {
public static void main(String[] args) {
Scanner sc = new Scanner(System.in);
System.out.println("······员工电话号码查询系统·······");
System.out.println("请输入你要查询的账号");
String empAccount = sc.nextLine();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:Moto168","sa", "");
String sql="{call proc_getTel(?,?)}";
CallableStatement cs=conn.prepareCall(sql);
cs.setString(1,empAccount);
cs.registerOutParameter(2, java.sql.Types.VARCHAR);
cs.execute();
int result =cs.getInt(1);
System.out.println(result);
conn.close();
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
求高手帮我改下,本人是个菜鸟 --------------------编程问答-------------------- int result =cs.getInt(1);改成 String result=cs.getString(1);试试
补充:Java , Java相关