servlet中调用数据库

web工程，目标平台部署到sailfin。sailfin平台中已经创建MySQL数据源。编写一个servlet，连接sailfin中的MySQL。
    举例：
    public class firstservlet extends HttpServlet
    {
        static Connection dbcon;
        public void doPost(HttpServletRequest req,
                           HttpServletResponse res)
            throws ServletException, IOException
        {
            try
            {
                Class.forName("com.mysql.jdbc.Driver");
                String dbURL = "jdbc:mysql://localhost:3306/test";  //JDBC数据源设置的url
                String username = "root";                           //JDBC数据源设置的用户名
                String password = "111111";                        //JDBC数据源设置的用户名
                dbcon = DriverManager.getConnection(dbURL, username, password);
                ……
            }
            catch(Exception e)
            {
                System.out.println("UNKNOWN!?");
                System.out.println(e.toString());
            }
            ……
            try
            {
                PreparedStatement s = dbcon.prepareStatement("select * from user where id=? and name=?");  //user为test下的表
                s.setString(1, accnum);
                s.setString(2, pinnum);
                ResultSet result = s.executeQuery();
            }
            catch(SQLException e)
            {
                System.out.println(e.toString());
            }
            ……
        }
    }