JAVA JDBC连接 SQLServer2012 Maven项目

package com.sql.test; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Types; import com.sql.util.JdbcUtil; public class sqlTest { private static Connection conn; public static void main(String[] args) { GetProduseInsert(); GetProduseSelect02(); GetProduseSelect(); } /* * 执行SELECT无参数存储过程,查询数据 */ public static void GetProduseSelect() { if (conn == null) { System.out.println("连接数据库失败"); } else { try { CallableStatement call = conn.prepareCall("{call p_Select_User()}"); ResultSet rs = call.executeQuery(); while (rs.next()) { String name = rs.getString("UserName"); String pwd = rs.getString("UserPwd"); String UserId = rs.getString("UserId"); System.out.println(name + "\t" + pwd + "\t" + UserId); } conn = JdbcUtil.getConnection(); JdbcUtil.closeAll(rs, call, conn); System.out.println("查询成功"); System.out.println("-----------------------"); } catch (Exception e) { System.out.println("查询失败"); System.out.println("-----------------------"); } } } /* * 执行INSERT有参数存储过程,查询数据 */ public static void GetProduseInsert() { if (conn == null) { System.out.println("数据库连接失败"); } else { try { CallableStatement call = conn.prepareCall("{call p_Insert_User(?,?)}"); call.setString(1, "heyangyi"); call.setString(2, "123"); call.execute(); conn = JdbcUtil.getConnection(); JdbcUtil.closeAll(null, call, conn); System.out.println("添加成功"); } catch (Exception ex) { System.out.println("添加失败"); } } } /* * 执行带输出参数的存储过程 */ public static void GetProduseSelect02() { if (conn == null) { System.out.println("数据库链接失败"); } else { try { CallableStatement call = conn.prepareCall("{call p_Select_UserCount(?,?) }"); call.setString(1, "heyangyi"); call.registerOutParameter(2, Types.INTEGER); call.execute(); conn = JdbcUtil.getConnection(); JdbcUtil.closeAll(null, call, conn); System.out.println("查询成功:" + call.getInt(2)); } catch (Exception e) { System.out.println("查询失败"); } } } }