JSP与数据库的交互

try
        {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
            Connection con = DriverManager.getConnection
                            ("jdbc:sqlserver://localhost:1433;DatabaseName=XXX","sa","XXX");
                            
                            
                            Statement stmt = con.createStatement();
                            ResultSet rst = stmt.executeQuery("select * from XXXX");
                            out.println("

");
                            while(rst.next())
                                {
                                
                                    out.println("");
                                    out.println("");
                                    out.println("");
                                    out.println("");
                                    out.println("");
                                    out.println("");
                                    out.println("");
                                    out.println("");
                                
                                }
                            out.println("

XX	XX	Sx	XXXr	XX	XX	Chasis_Serial_Number
"+rst.getString("XX_Ip")+"	"+rst.getString("XX")+"	"+rst.getString("SW_XX")+"	"+rst.getString("x_X_x_x")+"	"+rst.getString("x_x_x_x")+"	"+rst.getString("x_x_x_x")+"	"+rst.getString("x_x_x")+"

");
                                rst.close();
                                stmt.close();
                                con.close();
        }
        catch(Exception e){
            e.printStackTrace();
        }