Spring+CXF+tomcat开发webservice

package util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.sun.tools.xjc.reader.xmlschema.bindinfo.BIConversion.User; import po.UserPo; public class SqlUtil { private static String url = "jdbc:sqlserver://192.168.1.249;DatabaseName=OA_DHB"; private static String user = "javadev"; private static String password = "javadev123!"; private static String driverClass = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; public static Connection getConn() { Connection conn = null; try { Class.forName(driverClass); conn = DriverManager.getConnection(url, user, password); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return conn; } public static void excSql(String sql) { Connection conn = getConn(); try { PreparedStatement stat = conn.prepareStatement(sql); stat.execute(); } catch (SQLException e) { e.printStackTrace(); } finally { if (conn != null) { try { conn.close(); } catch (SQLException e) { } } } } public static UserPo getById(String sql) { Connection conn = getConn(); try { PreparedStatement stat = conn.prepareStatement(sql); ResultSet set = stat.executeQuery(); if (set != null) { while (set.next()) { UserPo po = new UserPo(); po.setId(set.getString("id")); po.setUsername(set.getString("username")); po.setPassword(set.getString("password")); return po; } } } catch (Exception e) { // TODO: handle exception } return null; } }