整合测试

1.         编写SessionBean，在其中添加如下方法：

public String testDS() {

        String resl = null;

        try {

            Properties p = new Properties();

            p.put(Context.INITIAL_CONTEXT_FACTORY,  "org.jnp.interfaces.NamingContextFactory");

            p.put(Context.PROVIDER_URL, "jnp://localhost:1099");

            Context ctx = new InitialContext(p);

            resl += "testing the database...\n";

            javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("java:/MSSQLDS");     
             //这个”MSSQLDS”必须和mssql-ds.xml文件中的jndi-name保持一致，否则会出错

            java.sql.Connection conn =null;

            java.sql.Statement st=null;

            java.sql.ResultSet rs=null;

            try {

                conn = ds.getConnection();

                st = conn.createStatement();

                String sqlStr = "select * from Employees";

                rs = st.executeQuery(sqlStr);

                while (rs.next()) {

                    resl += rs.getString("FirstName") + " " +rs.getString("LastName")+"\n";

                }

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9]  下一页