JDBC回顾
今天中午试着做了一个通过JTDS.JAR的驱动进行MS-SQLSERVER_DB连接，连接字符串经常忘记，不如把它放在博客里了，忘了就来看一下，哈哈
public class ConnectionManager{private static String DRIVER_CLASS = "net.sourceforge.jtds.jdbc.Driver";private static String URL = "jdbc:jtds:sqlserver://localhost:1433/forums";private static String USER_NAME = "sa";private static String PASSWORD = "sa";private ConnectionManager(){}//获取数据库连接对象的方法public static Connection getConnection(){Connection conn = null;try{Class.forName(DRIVER_CLASS);conn = DriverManager.getConnection(URL, USER_NAME, PASSWORD);}catch(ClassNotFoundException e){e.printStackTrace();}catch(SQLException e){e.printStackTrace();}return conn;}public static void main(String[] args){String sql = "SELECT * FROM userInfo";List<UserInfo> list = new ArrayList<UserInfo>();Connection conn = null;PreparedStatement stm = null;ResultSet result = null;conn = getConnection();try{stm = conn.prepareStatement(sql);result = stm.executeQuery();UserInfo temp;while (result.next()){temp = new UserInfo(result.getInt("userId"), result.getString("userName"), result.getString("password"));list.add(temp);}}catch(SQLException e){e.printStackTrace();}finally{try{result.close();stm.close();conn.close();}catch(SQLException e){e.printStackTrace();}finally{result = null;stm = null;conn = null;}}for (UserInfo temp : list){System.out.println(temp.getUserId() + "--" + temp.getUserName() + "--" + temp.getPassword());}}}